An ever-growing Power Automate Functions
My way of explaining each function with as much detail as I can. You'll find suggestions, best practices, things to avoid, and limitations.
Last updated
I'll include all my experiences (good and bad) working with the functions.
I want people to use it and share it. So I won't put any restriction on it on this reference.
Please contribute! The better I can make it, the better it will be for everyone.
I learn from lots of places, so some things may be found elsewhere.
Collection (11)
contains
Checks if a value exists in a collection or string.
Viewempty
True if a collection, string, or variable has no value.
Viewfirst
Returns the initial element of an array or the first character of a string.
Viewintersection
Returns items common to multiple arrays. Works with numbers, strings, and objects.
Viewjoin
Converts an array into a delimited string.
Viewlast
Returns the last element of an array or the last character of a string.
Viewlength
Returns the size of a string or the number of elements in an array.
Viewrange
Creates an array of consecutive integers from a start and a count.
Viewskip
Removes a given number of items from the front of an array.
Viewtake
Returns a given number of items from the front of an array or string.
Viewunion
Merges arrays and removes duplicates.
ViewData Conversion (11)
array
Wraps a single value into an array. Accepts strings, booleans, integers, and floats.
Viewbase64
Encodes a string for safe system-to-system transfer. Adds 33% size overhead.
Viewbool
Converts a string, integer, or float to boolean. Zero is false, non-zero is true.
ViewcreateArray
Builds an array from mixed types: strings, booleans, integers, and nested arrays.
Viewfloat
Converts strings and integers to floating-point numbers.
Viewint
Converts a string to an integer. Floats error; 19+ digit numbers silently corrupt.
Viewjson
Converts a string to a JSON object. Validates structure and formats output.
Viewreverse
Reverses the order of items in an array.
Viewsort
Sorts an array in ascending order by value or property.
Viewstring
Converts booleans, integers, floats, and arrays to text. Arrays become JSON; null becomes empty.
Viewxpath
Parses an XML document to extract nodes, attributes, and counts. Input must be XML type.
ViewData Selection (1)
Go to topDate (14)
addDays
Adds or removes days from a date with a custom format.
ViewaddHours
Adds or removes hours from a date with a custom format.
ViewaddMinutes
Adds or removes minutes from a date with a custom format. No date range limits.
ViewaddSeconds
Adds or removes seconds from a date with a custom format.
ViewaddToTime
Adds seconds, minutes, hours, or days to a date in one call.
ViewdateDifference
Returns days.hours:minutes:seconds between two dates as a string.
ViewdayOfWeek
Returns an integer 0-6 for the day of the week from a date.
ViewdayOfYear
Returns 1-366 for any date.
ViewformatDateTime
Converts a date into any format using specifiers or custom patterns like 'ddd MM yyyy'.
ViewstartOfDay
Resets a timestamp to midnight.
ViewstartOfHour
Returns the exact start of an hour from a timestamp.
ViewstartOfMonth
Returns the first day of any month.
Viewticks
Converts a date to 100-nanosecond intervals since year 0001.
ViewutcNow
Returns the current UTC date and time.
ViewFlow (5)
Outputs
Returns an action's full results inside an expression. The mechanism behind Dynamic Content.
ViewVariables
Returns the current value of a variable.
Viewitem
Accesses each element inside repeating actions like Apply to Each.
ViewtriggerBody
Returns the trigger's body inside an expression.
Viewworkflow
Returns the running Flow's name, ID, region, and run details at runtime.
ViewLogical Operator (8)
and
Returns true only when all expressions are true.
Viewcoalesce
Returns the first non-null value from a list. Null if all are null.
Viewequals
Compares two values. Case-sensitive for strings, cross-type for ints and booleans.
Viewgreater
Returns true when the first value is greater than the second.
ViewgreaterOrEquals
Returns true when the first value is greater than or equal to the second.
ViewlessOrEquals
Returns true when the first value is less than or equal to the second.
Viewnot
Negates a boolean value. Strict boolean input required.
Viewor
Returns true when any expression is true.
ViewMath (9)
add
Sums two numbers. Has a 19-digit precision limit that silently corrupts large results.
Viewdiv
Divides two numbers. Has a 19-digit precision limit that silently corrupts large results.
Viewless
Returns true when the first value is smaller than the second.
Viewmax
Returns the highest value from numbers or arrays. Type mismatches break it silently.
Viewmin
Returns the lowest number in an array. Works with integers and floats.
Viewmod
Returns the remainder of a division.
Viewmul
Multiplies two numbers. Has a 19-digit precision limit that silently corrupts large results.
Viewrand
Returns a random integer within a range. Negative numbers supported; no floats.
Viewsub
Subtracts two numbers. Has a 19-digit precision limit that silently corrupts large results.
ViewString Manipulation (14)
concat
Combines strings, booleans, integers, and arrays into a single string.
ViewendsWith
Checks if a string ends with specific text. Case-insensitive, space-sensitive, strings only.
ViewformatNumber
Converts a number to currency, percentage, or a custom format with locale support.
Viewguid
Generates a unique hexadecimal identifier.
ViewindexOf
Returns the position of text within a string. Zero-based; -1 when not found.
ViewlastIndexOf
Returns the position of the last occurrence of text in a string. -1 if not found.
ViewnthIndexOf
Returns the position of the Nth occurrence of a substring. -1 if not found.
Viewreplace
Swaps text within a string.
Viewsplit
Breaks a string into an array using a delimiter.
ViewstartsWith
Checks if a string begins with specific text. Case-insensitive, space-sensitive.
Viewsubstring
Extracts part of a string using a start index and a length. Zero-based.
ViewtoLower
Converts a string to lowercase.
ViewtoUpper
Converts a string to uppercase.
Viewtrim
Removes leading and trailing spaces. Inner spaces stay intact.
ViewURI Conversion (5)
uriHost
Returns the domain name from a URL. Strips protocol, path, and query string.
ViewuriPath
Returns just the path segment from a URL.
ViewuriPathAndQuery
Returns the full path and query string from a URL.
ViewuriQuery
Returns the query string from a URL. Empty when there are no parameters.
ViewuriScheme
Returns the protocol from a URL: 'https', 'ftp', or any valid scheme.
View