Date Format changing when "Add Row to Table" command

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

General topics

I have the same question (0)

All responses (14)

Answers (0)

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

It might simply be a case of selecting the column in Excel and right clicking -> format cells -> date and save the file. From that point onwards the new dates will be in the correct format for you?

Damien

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @DamoBird365 !

Sadly I had already checked this, the format has been like that for a few days already:

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sorry if it was an obvious one @Anonymous 🙂

I will give it a go myself and report back. Have you tried custom in the date formatting of excel?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous
Just realised that today of all days is not a good one for testing this. 3/3/2021 🙂

When I tried it, it worked for me first time. I used the following expression:

@{formatDateTime(addDays(utcNow(),3),'dd/MM/yyyy')}

Have you looked at your input/output history of the excel step?

Damien

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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...

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
FFS 38 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Irama 15 on at

Like (0)

Report
Copy link

Link copied!

Same issue, still haven't found a work around😓

Was this reply helpful? Yes No
jonsey1995 3 on at

Like (0)

Report
Copy link

Link copied!

Also having this issue, anyone found a solution?

Was this reply helpful? Yes No