DATE FORMAT CHANGE DURING AN IMPORT FROM CSV TO EXCEL

[BeR001]

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

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

[BeR001 · Accepted solution]

I've found the solution by added :

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