cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StephCORKING
Helper III
Helper III

Sharepoint convert word to PDF - date issue in converted file

Hello,

I have a flow that converts a Word Document that has been populated from a sharepoint list, into a PDF file.   The process appeared to be working up until yesterday and since then, whenever I convert the file, the date values in the PDF file are 1 day earlier that the date values in the Word document.

 

I need to go live with this flow ASAP and am completely blocked.

 

 

3 REPLIES 3
v-alzhan-msft
Community Support
Community Support

Hi @StephCORKING ,

 

Could you please share a screenshot of the configuration of your flow?

 

Best regards,

Alice       

 

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

Hi Alice,

 

Here is the flow

 

 Screen Shot 2020-01-09 at 07.49.37.png

 

The naming convention was not good as I was getting annoyed.  Basically, the first update file properties is filling the Word template and library.  The second update file properties inserts the date fields as text (this is how i managed to get it to work).  After that, I convert the file to PDF and then it is emailed to the employee.   

 

I wonder if it is because I am formatting the date/time to long date (no time) and when it creates the PDF file, it uses UTC instead of local time?

 

Steph

DSut
Advocate I
Advocate I

I got stuck on this one for ages. The only workaround I found was to use a text column like you did.
I also had to format the date in the update properties, date as text property to get it to show it correctly in the pdf.

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 (4,149)