Date and time format wrong when converting xlsx to pdf

[marc756]

Hi all

I got an issue when converting an xlsx spreadsheet into a pdf using the convert file connector from OneDrive. The date and number format is put out as "en-US" instead of "de-CH", which means date format is mm/dd/yyyy instead of dd.mm.yyyy. The xlsx displays the correct values in the fat client as well as in the online version. All my regional settings in O365 (account, onedrive, sharepoint) are correctly set. I also found an option in the Power Automate settings that says "regional settings" but they're also correctly set... 

[marc756]

Here's the onedrive conversion connector that causes the issue: 

This is how the date looks in Excel:

This is how it's translated during the conversion:

 

[v-litu-msft]

Hi @marc756,

I tested the Flow on my side but not find the same issue. I tried both Convert file using path and Convert file and they could convert it normally. All of My regional settings are 'en-us', not "de-CH".

 

Here is Excel number format setting:

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

[marc756]

Hi Lin Tu

Thanks for verifying. I figured out that the cell format was prefixed with an asterisk, which allows to convert into another regional format. I've now set it to use dd.mm.yyyy explicitly:

Now, it's getting very odd, as the date in the converted pdf is now in UK format dd/mm/yyyy:

😕

[marc756]

I've conducted another test today and it remains odd. I've created two lines with different de-CH formatting in a blank excel file:

 

 

And here's the output of the PDF converted by PowerAutomate:

So it seems to be a delimiter issue. Instead of a period '.' the PDF shows a slash '/'

Can you file a bug report for this issue?

[SebastianR]

Same issue, make´s me wicked. I think this is a major bug in onedrive.

Please MS fix it:-)