cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
masaustin
Frequent Visitor

Convert time zone date with invariant culture format

Hello everyone,

 

I wonder how to convert time zone and the invariant culture format at the same time?

 

For example, I'd like to convert UTC-5:00 to UTC+8:00, then convert the output format from (en-US) to (zh-TW), but there are only Standard Date and Time Format option in the "convert time zone" function, is there any other way it can be done?

1 ACCEPTED SOLUTION

Accepted Solutions

@manuelstgomes Finally I found a special way to solve this problem by using Excel, share with you.

 

02.PNG

First I create a sheet with three columns, "Time" is for input, and set the date format at "Converted" and trans to text at the same time. 

 

works.PNG 

And I set the Flow:

  1. use button to input date for testing =>instead of forms from my original Flow
  2. convert timezone and output in format [d]
  3. add the value into the "Time" column from excel
  4. get the value from "Converted" column
  5. output as skype message for testing =>instead of Sharepoint & Outlook from my original Flow
  6. delete the raw flow just created

Then I finally got the zh-TW date format generator I need! 

View solution in original post

5 REPLIES 5
manuelstgomes
Super User
Super User

HI @masaustin ,

 

There's a way to convert the format of the date that suits you by using the "Convert Timezone action".

small-Screenshot_2019-11-06_at_09_10_51.jpg

 

Or you can define your own format using the "Compose Action". You can use a formula like:

 

formatDateTime(utcNow(),'MM/dd/yyyy')

 

The language is based on the local preferences of the person running the Flow, but you can't force the translation to a specific language.

 

Hope this helps you.

 

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

Cheers
Manuel

Hi @manuelstgomes ,

 

Thanks for your reply, I've tried that before, even the option shows Chinese, but the output text still English: 

 

擷取.PNG

 

for example I choose the second option"[D]", then I got "Wednesday, November 6, 2019" not like the preview the option shows. 

Just like you said, it seems can't force the translation to a specific language, and that's exactly what I'm asking for.

 

Hi @masaustin 

 

It sucks I know. I tried to find an online API that you could use to achieve this but found none. Probably you'll be luckier.

 

Sorry for the bad news

 

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

Cheers
Manuel

@manuelstgomes Finally I found a special way to solve this problem by using Excel, share with you.

 

02.PNG

First I create a sheet with three columns, "Time" is for input, and set the date format at "Converted" and trans to text at the same time. 

 

works.PNG 

And I set the Flow:

  1. use button to input date for testing =>instead of forms from my original Flow
  2. convert timezone and output in format [d]
  3. add the value into the "Time" column from excel
  4. get the value from "Converted" column
  5. output as skype message for testing =>instead of Sharepoint & Outlook from my original Flow
  6. delete the raw flow just created

Then I finally got the zh-TW date format generator I need! 

Hi @masaustin 

Awesome!!!! Well done.

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

Cheers
Manuel

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,378)