You’re offline. This is a read only version of the page.
Announcements
I think this might be more of a problem with Excel than Power Automate, but having posted this in the Excel forum, I was told to take it here.
Short version: Power Automate is sending dates in the format dd/MM/yyyy to Excel. Excel is incorrectly interpreting them as MM/dd/yyyy.
Long version: I'm using the "Add a row into a table" function in Power Automate. One of the columns is supposed to be the date the row was filled. In Power Automate I'm using this function: formatDateTime(convertFromUtc(utcNow(), 'GMT Standard Time'),'dd/MM/yyyy')
Note: I'm using convertFromUtc because I understand it will account for daylight saving time (if data comes in on 2 June at 00:30 British Summer Time (1 June, 23:30 UTC) I understand it will output 02/06/2024 instead of 01/06/2024. Correct me if I'm wrong about this, or if it's not necesssary.
Testing the flow today, I can confirm Power Automate is sending 03/06/2024 to Excel, as expected. But Excel is displaying 06/03/2024. The column formatting is set to Date in the format dd/MM/yyyy. I have confirmed this by changing the formatting so it writes out the month in full, and I get "06 March 2024". If I convert it to text, I get 45357.
I'm guessing Excel thinks it's being sent a MM/dd/yyyy date and decides to convert it for me. I do want Excel to recognise it as a date (so I can use date filters when necessary) but I don't want it to try to reformat it.
I expect I could just get Power Automate to output a MM/dd/yyyy date as a workaround, but I would prefer to get it working as expected if possible.
Share
Report
All responses (
Answers (
410
