Power Automate: contains function
Checks whether a substring, array element, or object key is present. Case-sensitive, no type coercion.
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.
Checks whether a substring, array element, or object key is present. Case-sensitive, no type coercion.
Returns true when a string, array, or object has no value. Numbers and booleans throw an error.
Converts a string, integer, or float to boolean. Zero is false, non-zero is true.
Returns true when any expression is true.
Converts booleans, integers, floats, and arrays to text. Arrays become JSON; null becomes empty.
Compares two values. Case-sensitive for strings, cross-type for ints and booleans.
Checks if a string ends with specific text. Case-insensitive, space-sensitive, strings only.
Returns true when the first value is greater than the second.
Converts a date to 100-nanosecond intervals since year 0001.
Returns true when the first value is less than or equal to the second.
Returns true only when all expressions are true.
Evaluates a boolean expression and returns one of two values. Strict booleans only.