← Al Davies, 250 High Street

How to get the current date and time in your time zone in Power Automate

Use utcNow() to get the current time, then wrap it in convertFromUtc() with your time zone name, such as convertFromUtc(utcNow(), 'Eastern Standard Time', 'yyyy-MM-dd HH:mm'). utcNow() alone always returns UTC, not local time.

What is the one expression to copy?

convertFromUtc(utcNow(), 'Eastern Standard Time', 'MM/dd/yyyy hh:mm tt')

Add a Compose action, open the Expression tab, paste the line above, and select OK. Change the time zone name to match your office. The output is text, such as 10/31/2026 03:11 AM.

How do you build it step by step?

Compose action in Power Automate with a convertFromUtc expression in the Inputs box and the result 2026-10-31 03:11 below
One Compose action holds the local time for the rest of the flow.
  1. Select + (Insert a new step), then Add an action, and search for Compose. In the classic designer, select New step.
  2. Select the Inputs box, then select the fx button (Insert expression) or the Expression tab.
  3. Type utcNow() and select OK to see the UTC time.
  4. Edit the expression to wrap it: convertFromUtc(utcNow(), 'Your Time Zone Name').
  5. Add a format as the third part if you want only the date, such as 'yyyy-MM-dd'.
  6. Save the flow and run a test.

Why is the time wrong by several hours?

Before and after panels: utcNow() returns 1:00 AM on Nov 1 in UTC, the wrong day for someone in New York at 9 PM on Oct 31; convertFromUtc returns 9:00 PM on Oct 31
utcNow() can show tomorrow's date until you convert it to your time zone.

Microsoft documents that utcNow() returns the current timestamp in Coordinated Universal Time. A flow that runs at 9 PM in New York can show tomorrow's date, because UTC is already past midnight.

Convert the value before you use it in an email, a file name, or a date column. If a date is already wrong in a list or an email, our wrong day or time guide covers that fix.

Tip: Convert once in a Compose action, then reuse its output everywhere else.

Which function fits which job?

FunctionWhat it returnsExample use
utcNow()The current time in UTCStore a timestamp
utcNow('yyyy-MM-dd')Today's UTC date as textA file name
convertFromUtc(utcNow(), 'Eastern Standard Time')The current time in one time zoneAn email body
getFutureTime(7, 'Day')UTC time seven days from nowA due date
getPastTime(1, 'Day')UTC time one day agoA yesterday filter
startOfDay(utcNow())Midnight UTC todayA date-only compare

What are the common format codes?

  1. yyyy-MM-dd gives 2026-10-31.
  2. hh:mm tt gives a 12-hour time with AM or PM.
  3. Capital MM means month. Small mm means minutes.

The formatDateTime guide has the full list of format strings Microsoft shows.

What are the time zone names?

convertFromUtc() uses the Windows time zone names, not city names. Microsoft publishes the full list on its Default Time Zones page.

Common names for US offices are Eastern Standard Time, Central Standard Time, Mountain Standard Time, and Pacific Standard Time. Each name already includes daylight saving changes, so you do not switch names in summer.

WorksFails
'Eastern Standard Time''EST'
'Pacific Standard Time''America/New_York'
'GMT Standard Time''New York'

How do you get yesterday, tomorrow, or next week?

Use getPastTime() and getFutureTime() with a number and a unit, then wrap the result in convertFromUtc(). For a date only, add a format at the end.

To add days to a date you already hold, see Add days to a date. To skip weekends, see Add business days to a date.

convertFromUtc(getFutureTime(7, 'Day'), 'Eastern Standard Time', 'yyyy-MM-dd')

What do you do with the result?

FAQ

Does Power Automate have a local time function?

No. The expression language has utcNow() only. Use convertFromUtc() or convertTimeZone() to change the result into your time zone.

Does daylight saving time need a manual change?

No. A Windows time zone name such as Eastern Standard Time follows the daylight saving rules for that region.

Should I store the time in a variable?

Use a Compose action for a value you set once. See the Compose versus variable guide.

Sources