Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Answered

Date format changing in Excel

Like (0) ShareShare
ReportReport
Posted on 18 Feb 2025 22:05:17 by 76
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:
  • Chriddle Profile Picture
    7,724 Super User 2025 Season 1 on 19 Feb 2025 at 08:52:04
    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!
    1. Convert the date from the email to a Power Automate date string (ISO 8601, with parseDateTime())
    2. Add this to the "Add a row" action
    3. Set the "DateTime Format" in the "Add a row" action's "Advanced options" to "ISO 8601"
    4. In the Excel set the date column to the desired format.
  • Verified answer
    DJ_Jamba Profile Picture
    2,815 Super User 2025 Season 1 on 18 Feb 2025 at 22:56:17
    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:
     

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

Quick Links

Announcing the Engage with the Community forum!

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - General Discussion

#1
stampcoin Profile Picture

stampcoin 23

#2
Pstork1 Profile Picture

Pstork1 20 Most Valuable Professional

#3
Gprior Profile Picture

Gprior 19

Overall leaderboard
Loading started