Power Automate: join Function
Converts an array into a delimited string.
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.
Converts an array into a delimited string.
Converts a string to an integer. Floats error; 19+ digit numbers silently corrupt.
Breaks a string into an array using a delimiter.
Converts a string to lowercase.
Converts a string to uppercase.
Returns the lowest number in an array. Works with integers and floats.
Adds seconds, minutes, hours, or days to a date in one call.
Converts a date into any format using specifiers or custom patterns like 'ddd MM yyyy'.
Adds or removes seconds from a date with a custom format.
Adds or removes minutes from a date with a custom format. No date range limits.
Adds or removes days from a date with a custom format.
Adds or removes hours from a date with a custom format.