Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / date formating and tra...
Power Automate - Building Flows
Unanswered

date formating and translation issue

(0) ShareShare
ReportReport
Posted on by jacques_t 4

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?

  • jacques_t Profile Picture
    jacques_t 4 on at
    Re: date formating and translation issue

    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... 🙂

     

  • jacques_t Profile Picture
    jacques_t 4 on at
    Re: date formating and translation issue

    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??

  • schwibach Profile Picture
    schwibach Super User 2025 Season 1 on at
    Re: date formating and translation issue

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans