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.
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
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
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.
User | Count |
---|---|
5 | |
5 | |
4 | |
2 | |
2 |