web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate utcNow() Resulting in ...

Power Automate

Answered

utcNow() Resulting in a Rounded Hour Time of "9 Hours Ago"

(0) Share

Report

Report

Posted on by APM1994

43

I have created a flow which takes the time of 'now' each time something is approved, and saves that date/time

However, it keeps saving the time as 9 hours ago, rounded to an exact hour.

For example, if it is 10:25AM the flow will save the time 1:00AM

The expression I am using is: string(formatDateTime(utcNow(),'dd/MM/yyyy hh:mm tt'))

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (0)

Report
Hi @APM1994

utcNow() returns time in UTC. So, you will need to convert UTC to your local time zone:

Or using expressions:

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

For a list of time zones, see Default Time Zones | Microsoft Learn

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report

I would suggest using the Convert time zone to get the current UTC time in your own time zone and with the format you want.

The output would be something like this:

You would then be able to reference the output of Convert time zone (or whatever you want to name it) in your flow to get the date/time.

Was this reply helpful? Yes No

Join the conversation