Date format changing in Excel

Like (0) Share

Report

Posted on 18 Feb 2025 22:05:17 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:

Process Advisor

All responses (2)

Answers (1)

Chriddle 7,708 Super User 2025 Season 1 on 19 Feb 2025 at 08:52:04

Like (0)

Report
Date format changing in Excel

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.
Verified answer

DJ_Jamba 2,815 Super User 2025 Season 1 on 18 Feb 2025 at 22:56:17

Like (0)

Report
Date format changing in Excel

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: