Power Automate - Using Flows

Answered

Date format swapping between Power Automate and Excel using 'add a row into a table'

Like (0) Share

Report

Posted on 22 Jan 2025 10:12:47 by CU22010947-0

Hello,

I'm not sure if this is a Power Automate or an Excel issue but I thought I would try here first.

we have an online system for referrals which uses Microsoft Forms.

Since the recent update to Microsoft Forms took away the automatic update feature to its associated spreadsheet, I have set up a flow to transfer the data from the forms into an Excel spreadsheet when a form is filled in.

this is working well and is transferring the data to the spreadsheet.

However there is a issue with the 'Client Date of Birth' field.

We are in the UK and all the date fields are set up with the 'dd/MM/yyyy' date format.

I have also used 'FormatDateTime' to set the date format to 'dd/MM/yyyy'

However when the data is transferred to the spreadsheet, if the 'day' part of the date of birth is between 1 and 12, Excel then swaps the date round.

This date was inputted as 08/03/1996.

I have another flow which transfers the form data into a pdf. This transfers the date correctly:

I have checked every regional setting on the browser, Sharepoint, Excel, Forms, Windows and they are all set to UK.

The column on the spreadsheet is set to UK date in the format dd/MM/yyyy.

If the day number is bigger than 12, then it stays as the correct format.

Any ideas why this is being swapped?

Thanks

Categories:

Business Process Flows

All responses (5)

Answers (1)

CU22010947-0 8 on 05 Feb 2025 at 09:01:36

Like (0)

Report

Date format swapping between Power Automate and Excel using 'add a row into a table'

Thank you Chriddle.

That did solve the issue. Excel is no longer swapping the dates.
Verified answer

Chriddle 7,724 Super User 2025 Season 1 on 28 Jan 2025 at 13:31:33

Like (0)

Report

Date format swapping between Power Automate and Excel using 'add a row into a table'

Don't use formatDateTime() at all.

Just set the "Add a row into a table" connector's "DateTime Format" to "ISO 8601".
CU22010947-0 8 on 28 Jan 2025 at 10:34:47

Like (0)

Report

Date format swapping between Power Automate and Excel using 'add a row into a table'

Unfortunately the 'format date by examples' did not solve the problem.

The date is in the correct format within Power Automate, both on the flow result and the raw outputs.

However once the date is put in Excel, the day and month have been swapped.
CU22010947-0 8 on 23 Jan 2025 at 12:12:02

Like (0)

Report

Date format swapping between Power Automate and Excel using 'add a row into a table'

Thank you plarrue,

I will try this and see if it works.
plarrue Moderator on 22 Jan 2025 at 10:32:02

Like (0)

Report

Date format swapping between Power Automate and Excel using 'add a row into a table'

Hi

Have you tried "Format date by examples"?

Use format data by examples to change the format of data with Power Automate - Power Automate | Microsoft Learn

Regards,

Philippe

Community site session details

Date format swapping between Power Automate and Excel using 'add a row into a table'

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Automate - Using Flows

Featured topics

Product updates

Community site session details

Date format swapping between Power Automate and Excel using 'add a row into a table'

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Using Flows

Featured topics

Product updates