Date format changing in Excel

(0) Share

Report

Posted on by LB-20090315-0

Hello,

I have an issue with adding information to an excel spreadsheet.

My flow in power automate extracts data from an email and puts it into my excel spreadsheet for me. The first thing it extracts is the date. The date in the email is written "dd/mm/yyyy". I checked the flow run and this is format power automate is extracting and adding to the spreadsheet.

When I go into excel it automatically has changed to "mm/dd/yyyy" and this example one above was appearing as "02/07/2025". However, when I attempted to filter the dates, Excel recognised this in English format as 2nd July.

Just to clarify, I want it in "dd/mm/yyyy" format. Any advice on how to fix this? Is there something I need to change in excel or in power automate?

Categories:

General topics

I have the same question (1)

All responses (2)

Answers (1)

Verified answer

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Did you try formatting the date before writing to Excel?

E.g.
From: dd/mm/yyyy
To: yyyy-mm-dd

?

I'm sure others will provide elegant options, but I prefer to force the format using the split function:

concat( split(outputs('EmailDate'),'/')[2], '-', split(outputs('EmailDate'),'/')[1], '-', split(outputs('EmailDate'),'/')[0] )

Result:

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
If it' s a date column in Excel, the disply format depends on the column settings in Excel, not Power Automate!

Convert the date from the email to a Power Automate date string (ISO 8601, with parseDateTime())

Add this to the "Add a row" action

Set the "DateTime Format" in the "Add a row" action's "Advanced options" to "ISO 8601"

In the Excel set the date column to the desired format.

Was this reply helpful? Yes No