Power Automate: sub Function
Subtracts two numbers. Has a 19-digit precision limit that silently corrupts large results.
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: length Function
Returns the size of a string or the number of elements in an array.
Power Automate: indexOf Function
Returns the position of text within a string. Zero-based; -1 when not found.
Power Automate: substring Function
Extracts part of a string using a start index and length. Zero-based; errors if the range overflows.
Power Automate: replace Function
Replaces every instance of a substring within a string. Case-sensitive; strings only.
Power Automate: join Function
Converts an array into a delimited string. The delimiter goes between items, never at the ends.
Power Automate: int Function
Converts a string to an integer. Floats error; 19+ digit numbers silently corrupt.
Power Automate: split Function
Breaks a string into an array using a delimiter.
Power Automate: toLower Function
Converts a string to lowercase.
Power Automate: toUpper Function
Converts a string to uppercase.
Power Automate: min Function
Returns the lowest number in an array. Works with integers and floats.
Power Automate: addToTime Function
Adds seconds, minutes, hours, or days to a date in one call.