Date Format changing when "Add Row to Table" command

Like (0) Share

Report

Posted on 3 Mar 2021 11:41:08 by Community Power Pla...

I have a date in a PowerApps that is sent to Excel through Power Automate.

In the process i format the date with the following:

formatDateTime(variables('VFechaInicio'),'dd/MM/yyyy')

Once the row is added to Excel, the format is created as MM/dd/yyyy, does someone how to fix this issue?

https://ibb.co/GtTbGn4

All responses (14)

Answers (0)

HaleckzisZhoria 3 on 27 Feb 2024 at 16:08:18

Like (0)

Report

Re: Date Format changing when "Add Row to Table" command

Thanks so much @gidiscacciati ! That works for me.
I also used parseDateTime to ISO format my string.
DonJO 2 on 27 Apr 2023 at 11:08:30

Like (0)

Report

Re: Date Format changing when "Add Row to Table" command

The only one solution is to select the hole column and apply the settings for all the column
kp_2 5 on 13 Mar 2023 at 19:44:09

Like (1)

Report

Re: Date Format changing when "Add Row to Table" command

gidiscacciati thank you for sharing this! Your solution worked for me, too! This was driving me crazy!
gidiscacciati 69 on 02 Mar 2023 at 18:51:45

Like (5)

Report

Re: Date Format changing when "Add Row to Table" command

Did anyone get a solution for this? I'm also having the same issue. I format the date as 'dd/MM/yyyy' in power automate, "Add row into a table" output shows the date in the correct format (06/02/2023), but in excel it shows 02/06/2023. What in the world is going on here?

Power Automate output:

Excel File:

EDIT: I would like to add here something that finally worked for me. If I use 'yyyy-MM-dd' as date format in formatDateTime, when the data gows to excel, it reads it correctly, and keeps the default formatting (in my case, default format in Excel is dd/MM/yyyy)
jonsey1995 3 on 05 Jan 2023 at 13:36:25

Like (0)

Report

Re: Date Format changing when "Add Row to Table" command

Also having this issue, anyone found a solution?
Irama 15 on 13 Dec 2022 at 05:10:43

Like (0)

Report

Re: Date Format changing when "Add Row to Table" command

Same issue, still haven't found a work around😓
FFS 38 on 18 Jul 2022 at 17:12:32

Like (0)

Report

Re: Date Format changing when "Add Row to Table" command

I have the same issue, output in Power Automate is correct. Regions on Excel 365 and Power Automate both on UK but still it's switching to US format. Any ideas?
DamoBird365 8,942 Microsoft Employee on 03 Mar 2021 at 17:14:59

Like (0)

Report

Re: Date Format changing when "Add Row to Table" command

Hi @Anonymous,

If it's just an asthetic thing, I have tried adding a comma to the start of the date using concat and that works but that won't help you if you need to perform calcs on the date in Excel?

concat('''',formatDateTime(addDays(utcNow(),3),'dd/MM/yyyy'))

Damien
Community Power Pla... on 03 Mar 2021 at 16:30:23

Like (1)

Report

Re: Date Format changing when "Add Row to Table" command

Yes @DamoBird365

The output of the Power Automate is correct, apparently is just Excel turning it aroung only when possible, if the day is bigger than 12 then it understand the correct order and stays dd/MM/yyyy. what a crazy behavior...
Community Power Pla... on 03 Mar 2021 at 16:29:23

Like (0)

Report

Re: Date Format changing when "Add Row to Table" command

.

Community site session details

Date Format changing when "Add Row to Table" command

Helpful resources

News and Announcements

Quick Links

Thomas Rice – Community Spotlight

Kudos to the February Top 10 Community Stars!

Announcing Our 2025 Season 1 Super Users!

Leaderboard

Featured topics

Product updates

Community site session details

Date Format changing when "Add Row to Table" command

Helpful resources

News and Announcements

Quick Links

Thomas Rice – Community Spotlight

Kudos to the February Top 10 Community Stars!

Announcing Our 2025 Season 1 Super Users!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates