Power Automate - Convert Excel to PDF - Date formatting not consistent

Forum|Forum|11 months ago
February 20, 2025
1 reply
431 views

I have a very simple Power Automate flow set up where a shared inbox recieves an email and the excel attachment is converted to PDF and shaved to sharepoint.

I am running into an issue however where after the conversion, the date that I had formatted as =text(C$10,"dddd, mmmm dd, yyyy") is not returning correctly. When I would expect "Friday, January 31, 2025" I am getting "2025-01-31 00:00:00.000".

What do I need to change to have the date show correctly on my report?

try67

Community Expert

Are you using Acrobat? If not, this is not the place for your question. If so, how?

A

analytical_gemstoneAuthor

Participant

This is being done with the Adobe Convert Excel to PDF step within Power Automate. My excel file has it formatted correctly so something is happening during the conversion.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded