An ever-growing Power Automate Functions
My way of explaining each entry 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 them.
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 (12)
chunk
Splits a string or array into pieces of a fixed size. The last chunk is often shorter.
Viewcontains
Checks whether a substring, array element, or object key is present. Case-sensitive, no type coercion.
Viewempty
Returns true when a string, array, or object has no value. Numbers and booleans throw an error.
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. The delimiter goes between items, never at the ends.
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 (12)
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.
Viewdecimal
Converts a string to a precise decimal number.
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 (19)
addDays
Adds or subtracts days from a date. The day count must be an integer, not a decimal.
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.
ViewconvertFromUtc
Converts a UTC timestamp into a target time zone. Returns a string with no offset or Z marker.
ViewdateDifference
Returns days.hours:minutes:seconds between two dates as a string.
ViewdayOfMonth
Returns the day of a timestamp as an integer 1-31.
ViewdayOfWeek
Returns an integer for the day of the week from a date. Sunday is 0, Saturday is 6.
ViewdayOfYear
Returns 1-366 for any date.
ViewformatDateTime
Converts a date into any format using specifiers or custom patterns like 'ddd MM yyyy'.
ViewgetFutureTime
Returns the current timestamp plus a number of time units. Always counts from UTC now.
ViewgetPastTime
Returns the current timestamp minus a number of time units. Always counts back from now in UTC.
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.
ViewsubtractFromTime
Subtracts an interval from a timestamp you supply. Returns a string; months clamp to month end.
Viewticks
Converts a date to 100-nanosecond intervals since year 0001.
ViewutcNow
Returns the current UTC date and time.
ViewFlow (6)
Outputs
Returns an action's full results inside an expression. The mechanism behind Dynamic Content.
ViewVariables
Returns the current value of a variable.
Viewbody
Returns the body output of a named action. Names use underscores for spaces and are case-sensitive.
Viewitem
Accesses each element inside repeating actions like Apply to Each.
ViewtriggerBody
Returns the trigger's body as JSON. Use ?['key'] to reach a single value.
Viewworkflow
Returns the running Flow's name, ID, region, and run details at runtime.
ViewLogical Operator (10)
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.
ViewisFloat
Checks if a string is a floating-point number.
ViewisInt
Checks if a string is an integer.
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 (15)
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
Replaces every instance of a substring within a string. Case-sensitive; strings only.
Viewslice
Extracts a substring by position. Supports negative indices; endIndex is exclusive.
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 length. Zero-based; errors if the range overflows.
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.
ViewPower Automate Function Reference (4)
convertTimeZone
Converts a timestamp between two time zones, daylight saving included. Output drops the zone marker.
ViewconvertToUtc
Converts a timestamp from a source time zone to UTC using Windows time zone names.
ViewparseDateTime
Converts a date string into an ISO 8601 timestamp using a locale and optional format. Locale comes second.
Viewbase64ToBinary
Converts a base64-encoded string into binary file content. The content type changes; the base64 does not.
View