cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoaoSantos489
Resolver I
Resolver I

Convert Excel To PDF - Date Format

Hey Guys,

 

I have a very simple flow that converts an excel file to PDF. 

Problem Is when the conversion is made to PDF the date format changes... 

Images Bellow:

Flow

m1.PNG

The Excel File:

m2.PNG

The PDF file converted

m3.PNG

 

I know I can solve this by doing a work around through the flow, but I didnt want to go that way. 

2 REPLIES 2
fchopo
Super User
Super User

Hi @JoaoSantos489 

It seems it's a general issue about exporting Excel to PDF. Have you tried to format the excel columns as Text and not as dates?

Regards,
Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!
GuyBoswell
Helper V
Helper V

I get the same.  Except for me it translates, '15 December 2022', to, 'Thursday, December 15, 2022'.  Which then doesn't fit in the column so is replaced by, '################'

Very frustrating!

Is this a Power Automate thing or an Excel thing or an Adobe thing?

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,374)