Cheat sheet · Power Automate

Cheat sheet for Power Automate expressions

Power Automate expressions with examples: format and compare dates, JSON, conditions, variables, filter queries, and trigger conditions.

01Questions and answers

Frequently asked questions

How do I format a date in Power Automate?

With formatDateTime(), for example formatDateTime(utcNow(), 'yyyy-MM-dd'). utcNow() returns UTC. To display a local date, convert first, for example with convertTimeZone(utcNow(), 'UTC', 'W. Europe Standard Time', 'yyyy-MM-dd HH:mm') for Germany. For month and day names in another language, pass a locale such as 'de-DE' as the third argument to formatDateTime().

Why is the time wrong?

utcNow() returns UTC. Without a conversion, the time in Germany, for example, is off by one hour (winter) or two hours (summer). For data from a connector, check which time zone the value uses.

How do I check whether a field is empty?

With empty(). For text fields, empty(coalesce(triggerBody()?['Comment'], '')) covers both missing and empty values.

What's the difference between a filter query and Filter array?

The filter query filters in SharePoint before data is transferred. "Filter array" filters only within the flow.

Why does my filter query return nothing?

Check the internal column name, the column type, and the filter value. For large lists, pagination can help.

Do expressions change in the German interface?

No. Expressions always use English function names, commas between arguments, and the period as the decimal separator.

02Next step

Building approval processes with Power Automate?

The Approval Toolkit for Microsoft Power Automate contains ten building blocks, four scenarios, a planner, and a handbook so that you can plan, build, and test approvals yourself.

Your process. My solution.

Tell me where things get stuck today - in a free, no-obligation initial consultation via Microsoft Teams, we will clarify what the Power Platform can do for your process and what a sensible first step looks like.