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?
Solved! Go to 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:
Then I finally got the zh-TW date format generator I need!
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
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.
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.
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:
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
12 | |
9 | |
7 | |
7 | |
7 |
User | Count |
---|---|
19 | |
18 | |
17 | |
9 | |
7 |