OneDrive converts PDF with wrong Dates

[SebastianR]

Hello everyone, does anyone know what the problem is that when I convert Excel files into a PDF with Powerautomate (Flow) using the OneDrive function, the date fields "10.01.2021" contained in Excel are converted into US format "01/10/2021" , I've already scoured all regional and language settings and set them to German or Gregorian. I also tried it with Zapier.com, but the result is the same 😞 I would be happy about a solution.

THX Sebastian Rothe

[v-yiwenxie-msft · Accepted solution]

Hi @SebastianR 

In my understanding, you want your date field values in excel in OneDrive to be converted from ‘01/10/2021(MM/dd/yyyy)’ into ‘10.01.2021(dd.MM.yyyy)’.

If I’ve misunderstood your need, please feel free to let me know.
And could you please take screenshots of your detailed flow?

You can simply use the function:

formatDateTime(items('Apply_to_each')?['date'],'dd.MM.yyyy')

For more info about the formaDateTime(), please go to the link: Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

The steps are for your reference:

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.