Function Friday – Xpath

Power Automate doesn’t give you any built-in methods for editing XML content, and that’s fine. XML is a devil-spawned file format that should die thousands of deaths and never see the light of day again. But, if you’re forced to use XML and need the ability to search and parse […]

Error Handling with Power Automate

One of the things in Power Automate that doesn’t seem to get a lot of attention is the available features for error handling. So today we’re going to delve into the kinds of features and design patterns you can use to help your flows run smoothly, even when things go […]

Function Friday – Coalesce

I had intended to cover the XML XPath function this week. But due to some time constraints I needed to make this a quick hit this week, so I’m going over the coalesce function instead. The coalesce function is quite simple. You pass in any number of arguments and coalesce […]

Function Friday – JSON Manipulation

Apologies for the delay. It’s been a rough few weeks lately. A lot of the work we do as developers is to pass data back and forth. Typically these days that data is passed in JSON format (though the usage of XML is still fairly widespread). Sometimes we need to […]

Function Friday – URI Parsing Functions

Sometimes you need to work with URI (uniform resource identifiers) in Power Automate. URIs point at something, like websites, files, and so forth. You should be familiar with their most common format, the URL (uniform resource locator): The first portion (“https”) identifies the protocol or scheme. The second portion (“barretblake.dev”) […]

Function Friday – Date and Time Wrap Up: Timezones and Ticks

This time I’m walking through the remaining Date and Time functions. These include the functions that convert between and work with timezones: convertFromUtc, convertToUtc, convertTimeZone, utcNow. But first, we’re going to take a look at ticks. Just what the heck are ticks, anyway? Ticks are an integer value that represents […]