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

Like (1) Share

Report

Posted on 4 Oct 2024 08:41:28 by SB-12091310-0

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?

Categories:

Business Process Flows

All responses (4)

Answers (1)

Verified answer

David_MA 10,858 Super User 2025 Season 1 on 04 Oct 2024 at 12:56:18

Like (1)

Report

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.