Power Automate: formatNumber function
Converts a number to currency, percentage, or a custom format with locale support.
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: triggerBody function
Returns the trigger's body inside an expression.
Power Automate: guid function
Generates a unique hexadecimal identifier.
Power Automate: not function
Negates a boolean value. Strict boolean input required.
Power Automate: startsWith function
Checks if a string begins with specific text. Case-insensitive, space-sensitive.
Power Automate: float function
Converts strings and integers to floating-point numbers.
Power Automate: contains function
Checks whether a substring, array element, or object key is present. Case-sensitive, no type coercion.
Power Automate: empty function
True if a collection, string, or variable has no value.
Power Automate: bool function
Converts a string, integer, or float to boolean. Zero is false, non-zero is true.
Power Automate: or function
Returns true when any expression is true.
Power Automate: string function
Converts booleans, integers, floats, and arrays to text. Arrays become JSON; null becomes empty.
Power Automate: equals function
Compares two values. Case-sensitive for strings, cross-type for ints and booleans.