Power Automate expressions cheat sheet

Current timestamp in UTC. Without a format it returns ISO 8601, for example 2026-10-29T05:18:31.3384797Z.

Flows run in UTC. Convert to local time with convertFromUtc() or convertTimeZone() before showing a time to people.

Add a positive or negative number of days to a timestamp.

addHours(), addMinutes() and addSeconds() take the same parameters.

Add any number of time units to a timestamp.

timeUnit is one of Second, Minute, Hour, Day, Week, Month, Year.

Subtract a number of time units from a timestamp.

Current timestamp minus the given time units, without calling utcNow() yourself.

getFutureTime() works the same way forwards, for example getFutureTime(5, 'Day').

Return a timestamp in a standard or custom .NET date format. The locale defaults to en-us.

Case matters in the pattern: MM is the month and mm is minutes; HH is 24-hour and hh is 12-hour (add tt for AM/PM).

Turn a date string, such as a dd/MM/yyyy value typed into a form, into a timestamp.

Without a format it tries the formats that suit the locale, which defaults to en-us (month first).

Convert a timestamp from one time zone to another.

Time zone names come from the Windows default time zones list, for example India Standard Time, GMT Standard Time or Eastern Standard Time.

Convert a UTC timestamp to a local time zone.

The reverse is convertToUtc('<timestamp>', '<sourceTimeZone>', '<format>'?).

The same date at 00:00:00, for example to filter items created today.

startOfHour() and startOfMonth() work the same way.

The first day of the month at 00:00:00.

Day of the week as a number, where Sunday is 0 and Saturday is 6.

dayOfMonth() and dayOfYear() return the day of the month and of the year.

Time between two timestamps as a timespan string such as 1268.00:00:00 (days.hours:minutes:seconds).

Negative when startDate is later than endDate.

Number of 100-nanosecond ticks since 1 January 0001, useful for doing maths on dates.

One day is 864000000000 ticks, so the example gives the whole days since 1 January 2026.

Join two or more strings.

Characters from a zero-based position, for a given length.

Fails if startIndex plus length goes past the end of the text. Use slice() when the text may be shorter.

Characters from a start position up to (not including) an end position. A negative start counts from the end.

Returns an empty string instead of an error when the start is past the end of the text.

Replace a substring with another string and return the result. Case-sensitive.

Split a string into an array at a delimiter.

Lowercase a string, for example before comparing email addresses.

toUpper('<text>') returns uppercase.

Remove leading and trailing whitespace.

Zero-based position of a substring, or -1 when it is not found. Not case-sensitive.

lastIndexOf() finds the last occurrence; nthIndexOf('<text>', '<searchText>', <occurrence>) finds the nth.

True when a string starts with a substring. Not case-sensitive.

endsWith('<text>', '<searchText>') checks the end, also not case-sensitive.

Number of characters in a string or items in an array.

A new random GUID string. Format N, D (default), B, P or X.

Format a number as a string using a .NET numeric format string. The locale defaults to en-us.

Build an array from several values.

array('<value>') wraps a single value in an array.

First item of an array, or first character of a string.

Wrap in coalesce() or check empty() first if the array can be empty.

Last item of an array, or last character of a string.

True when a string has a substring, an array has a value, or an object has a key. Case-sensitive.

True when a string, array or object is empty.

Join array items into one string with a separator.

All items from two or more arrays (or objects), with no duplicates.

Only the items that appear in every array (or object) given.

Drop a number of items from the front of an array and return the rest.

The example drops the header line of CSV text; decodeUriComponent('%0A') is a line break.

The first items of an array, or the first characters of a string.

Sort an array. For an array of objects, give the key to sort by.

Wrap in reverse([<collection>]) for descending order.

Return one value or another depending on a true or false expression.

True when two values, expressions or objects are equivalent.

To compare text without regard to case, lowercase both sides with toLower() first.

True only when every expression is true.

True when at least one expression is true.

Flip true to false and false to true.

True when the first number or string is greater than the second.

greaterOrEquals() also returns true when the values are equal.

True when the first number or string is less than the second.

lessOrEquals() also returns true when the values are equal. Comparing ticks() values is the reliable way to compare dates.

Convert a string such as '10' to an integer.

Convert a string to a floating-point number, optionally reading a locale-specific format.

decimal('<value>') keeps full decimal precision; wrap its result in string() to preserve it.

Convert any value to a string. Null becomes an empty string.

Convert a value to true or false: 1, -1 and 'true' give true; 0 and 'false' give false.

Convert a JSON string (or XML) into an object or array you can read properties from.

Base64-encode a string.

Decode a base64 string back to text.

Use this instead of decodeBase64(), which is deprecated.

URL-encode a string so it is safe in a query string or path.

Preferred over encodeUriComponent(). Decode with uriComponentToString().

The body output of the flow's trigger. Shorthand for trigger().outputs.body.

The full trigger output, including headers. Shorthand for trigger().outputs.

The body output of an action. Shorthand for actions('<actionName>').outputs.body.

Use the action's name with spaces replaced by underscores.

All outputs of an action, such as statusCode, headers and body.

The whole action object at run time, including its status.

The current item in a named Apply to each (for-each) loop.

item() returns the current item of the loop or repeating action you are in.

The current value of a variable created with Initialize variable.

Details about the running flow: name, type, id, location, run and tags.

Power Automate flows carry the flowDisplayName and environmentName tags; workflow()?['run']?['name'] is the name of the current run.

An array of results from the top-level actions inside a Scope, Apply to each or Do until, for error handling.

Run it in an action set to run after the scope has failed, then filter the array for items whose status is Failed.

The ? (null ignore) operator: return null instead of failing when the object is null or the property is missing.

Without ?, a missing property fails the flow with 'Unable to process template language expressions'.

The first value that is not null.

Empty strings, empty arrays and empty objects are not null, so coalesce() keeps them.

Chain ? through several levels and fall back to a default when anything along the way is missing.

Use a fallback when a value is null or empty (coalesce() alone does not catch empty strings).

Insert an expression's result into surrounding text; the value is converted to a string.

Today's date in local time, ready for an email subject or a file name.

Count the items an action returned, giving 0 instead of an error when the list is missing.