web

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

News and Announcements icon

Power Platform CommunityForums Power Automate How to convert utcNow(...

Power Automate

Answered

How to convert utcNow() to different time zone?

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I'm trying to include the date and time in the filename of an Excel file, created through a flow. I need the time to be converted to the Japan time zone, so my code looks like this:

formatDateTime(convertTimeZone(utcNow(), 'UTC', 'JST'),'yyyyMMddhhmm')

However, this outputs an error saying that the value 'JST' is incorrect (see attachment). I also tried to replace it by 'Japan Standard Time' but the result in the same. I followed an example where it was using 'Eastern Standard Time' and that worked. So I'm wondering what's the exact syntax for the Japan time, does anyone know?

Thanks a lot!

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (2)

Report
Copy link

Link copied!
You can use the Convert time zone action to see the list of time zones you have available. Once you've set that up you can go into Peek code to see what it generates.

{ "kind": "ConvertTimeZone", "inputs": { "baseTime": "@{utcNow()}", "formatString": "yyyyMMddhhmm", "sourceTimeZone": "UTC", "destinationTimeZone": "Tokyo Standard Time" } }

So, for your example you should be able to do the following:

convertTimeZone(utcNow(), 'UTC', 'Tokyo Standard Time', 'yyyyMMddhhmm')

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey Grant,

Thanks a lot for your quick reply! I finally understand how to find the String values to pass as the destinationTime now. I tried with your suggestion and my filename displays the correct time.

Was this reply helpful? Yes No

Join the conversation