Convert time zone date with invariant culture format

[masaustin]

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?

[manuelstgomes]

HI @masaustin ,

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

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

[masaustin]

Hi @manuelstgomes ,

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

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.

[manuelstgomes]

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

[masaustin · Accepted solution]

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

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. 

 

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! 

[manuelstgomes]

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