Power Automate: range function
Creates an array of consecutive integers from a start and a count.
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.
Creates an array of consecutive integers from a start and a count.
Returns items common to multiple arrays. Works with numbers, strings, and objects.
Merges arrays and removes duplicates.
Returns a given number of items from the front of an array or string.
Removes a given number of items from the front of an array.
Sorts an array in ascending order by value or property.
Reverses the order of items in an array.
Encodes a string for safe system-to-system transfer. Adds 33% size overhead.
Returns 1-366 for any date.
Returns the first non-null value from a list. Null if all are null.
Returns the highest value from numbers or arrays. Type mismatches break it silently.
Returns the remainder of a division.