cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BeR001
Helper I
Helper I

DATE FORMAT CHANGE DURING AN IMPORT FROM CSV TO EXCEL

DEAR ALL,

 

I'M GETTING CRAZY.
In my flow, I ecxtract data from a csv file and I add them to an excel file.

When I run my flow and check it, the date format is correct : dd/mm/yyyy hh:mm. See Below

BeR001_0-1662558501468.png

 

When I open my excel file, I see : 09/07/2022 instead of the 07/09/2022 put by my flow.
My date format in my excel file is French (Belgium) dd/mm/yyyy

So during the import, days and months are switched...

I don't know what I can do.

Is there a parameter to change in Power automate ?

Thank you in advance.

Bertrand

1 ACCEPTED SOLUTION

Accepted Solutions
BeR001
Helper I
Helper I

I've found the solution by added :

 

formatDateTime(items('Apply_to_each')?['dueDateTime'],'MM/dd/yyyy')

 

View solution in original post

1 REPLY 1
BeR001
Helper I
Helper I

I've found the solution by added :

 

formatDateTime(items('Apply_to_each')?['dueDateTime'],'MM/dd/yyyy')

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

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

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,997)