date formating and translation issue

(0) Share

Report

Posted on by jacques_t

Hello,

I am french and for my convenience, and to be abble to find help with my flows, I am using PA in english.

There's my issue :

when I format a date while using english version to put it in a excel file, the date format in excel is the english one (dd/MM/yy), even if I use this formula : convertFromUtc(utcNow(), 'Romance Standard Time', 'dd/MM/yy HH:mm:ss')

Of course, it seems to be normal as the output is a decimal number based on the english format...

the logical way to resolve this would be to use english language with french date format (dd/MM/yy) but the option in unavailable in the parameters : you must use date format according to your language...

any ideas to bypass that?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

schwibach 2 Moderator on at

Like (0)

Report

Maybe, I'm off here....
But you're looking to display the date correctly in Excel.
Can you change the way the date displays in Excel?

Was this reply helpful? Yes No
jacques_t 4 on at

Like (0)

Report

las no : the dqte arrive in in excel as a decimal number... and the translation gives the decimal number for english format... but you inspire me a solution though... i can go for english format in power automate (MM/dd/yyyy) and then it will be at the correct decimal equivalent... and in my version of excel be transformed with the good date...
a little bit twisted in my opinion... and a very nasty thing from power automate....
suppose that I share an english flow with a french guy with PA user interface in french... what will be the result? or if i send a copy to him??

Was this reply helpful? Yes No
jacques_t 4 on at

Like (0)

Report

Excel for business is a connector, it should not vary across destinations... and if it does, this should be ok to specify the format in the action dialog box... at least to prevent anyone to lose his hair trying to solve the issue... 🙂

Was this reply helpful? Yes No