Power Automate: convertFromUtc function
Converts a UTC timestamp into a target time zone. Returns a string with no offset or Z marker.
CATEGORY
Power Automate Function Reference
Power Automate expressions are where a lot of the real magic happens, and this is my reference for the functions that power them. When the point-and-click designer runs out of road, a well-placed expression gets you exactly what you need. I document the everyday date and time helpers like the "addDays" function, the "addHours" function, and the "addMinutes" function, along with the more flexible "addToTime" function for shifting timestamps. I cover math with the "add" function, logic with the "and" function, and data shaping with the "addProperty" function and the "array" function. Need to convert data types? The "base64ToBinary" function gets its own walkthrough, and the "action" and "actions" functions let you reach into earlier steps. Every entry gives you the syntax, the parameters, the return value, a practical example, and the edge cases that catch people out.
Power Automate: convertToUtc function
Converts a timestamp from a source time zone to UTC using Windows time zone names.
Power Automate: isInt function
Checks if a string is an integer.
Power Automate: slice Function
Extracts a substring by position. Supports negative indices; endIndex is exclusive.
Power Automate: isFloat function
Checks if a string is a floating-point number.
Power Automate: dayOfMonth function
Returns the day of a timestamp as an integer 1-31.
Power Automate: decimal function
Converts a string to a precise decimal number.
Power Automate: less function
Returns true when the first value is smaller than the second.
Power Automate: range function
Creates an array of consecutive integers from a start and a count.
Power Automate: intersection Function
Returns items common to multiple arrays. Works with numbers, strings, and objects.
Power Automate: union Function
Merges arrays and removes duplicates.
Power Automate: take Function
Returns a given number of items from the front of an array or string.