Skip to main content

Notifications

Community site session details
Power Automate - Building Flows
Answered

Update row with today's date displaying in MM/dd/yyyy when should be dd/MM/yyyy?

Like (1) ShareShare
ReportReport
Posted on 4 Oct 2024 08:41:28 by 23
Hi everyone,
I have a flow that's working fine technically, but the final step is to update an excel row with today's date, and is being converted to MM/dd/yyyy in excel, when I see that Power Automate is returning the desired format of dd/MM/yyyy.
 
It's updating the correct column/row. The only issue is with the date format.
 
I've checked excel and the cells are formatted as date dd/MM/yyyy, the sheet is in English (UK), and I just tell why this would be happening.
 
When I change the call format to text, it appears correctly as dd/MM/yyyy. However this is not ideal as I plan to use some conditional formatting with the dates.
 
Can anyone suggest anything to fix this please?
 
  • Verified answer
    David_MA Profile Picture
    10,858 Super User 2025 Season 1 on 04 Oct 2024 at 12:56:18
    Update row with today's date displaying in MM/dd/yyyy when should be dd/MM/yyyy?
    Is the update row action using the output of the compose action? If not, show how you are populating it in the update row action? One thing you may also want to try is to set the Excel action to ISO8601 date format and populate it with yyyy-MM-dd and then see if it displays using your regional settings.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 97

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard
Loading complete