cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Frequent Visitor

Re: Convert time zone date with invariant culture format

@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
Highlighted
Super User II
Super User II

Re: Convert time zone date with invariant culture format

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

Highlighted
Frequent Visitor

Re: Convert time zone date with invariant culture format

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.

 

Highlighted
Super User II
Super User II

Re: Convert time zone date with invariant culture format

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

Highlighted
Frequent Visitor

Re: Convert time zone date with invariant culture format

@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

Highlighted
Super User II
Super User II

Re: Convert time zone date with invariant culture format

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (5,974)