cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Matthew5
Advocate II
Advocate II

Date Format Changing To American

Morning, 

I'm having some difficulty getting PowerAutomate to record dates as dd/mm/yyyy in an excel document. This was working fine end of last month when it was set up, so I guess works fine when it's a date that physically could not be in the American format of mm/dd/yyyy (e.g. 31/10/2022 since there is no 31st month) 

It looks like PVA is recording the date as the American format, which I knew:

Matthew5_0-1667553284532.png

 

So I've used compose and a datetimeformat for dd/MM/yyyy which also works correctly and even shows in the flow as recording correctly in the excel table... yet it hasn't?

 

Matthew5_1-1667553359450.png

PVA flow excel:

Matthew5_2-1667553383772.png

 

But here's how it's actually recorded in the Excel table:

Matthew5_3-1667553430858.png

 

Is anyone able to assist at all in having the date format show in Excel as dd/mm/yyyy as it's needed in that format for our uploader automation. 

Many thanks,

1 REPLY 1
Matthew5
Advocate II
Advocate II

It looks like changing the format in Excel to 'Text' instead of 'Custom' has done the trick

Helpful resources

Announcements
Power Virtual Agents News & Announcements

Power Virtual Agents News & Announcements

Keep up to date with current events and community announcements in the Power Virtual Agents community.

Power Virtual Agents Community Blog

Power Virtual Agents Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,928)