Time Data From Sharepoint List to Microsoft Word Template Incorrect

[aebara]

Hello all,

When an item is created in SharePoint, my flow grabs & creates an image based on a PowerApps input, and also grabs some data from a SP list. This data is then dropped into a few fields on a Word template.

Most of my fields are working fine with the exception of a time/date field.

The time is off by 4 hours when I view a filled template.

For example: If I submit an item to a SharePoint list at 1 PM, the time on my document will say 5 PM. Everything appears correctly in my app if I view that record, and the same goes for SharePoint.

I am configured in the correct time zone on PowerApps, and SharePoint. I still believe it could be a time zone issue.

Maybe the 'Word Online' service needs to be configured or something? 

Any guidance would be much appreciated. Thank you!

[Shujaath_Khan · Accepted solution]

Hi @aebara 

Maybe SharePoint is saving in DateTime in UTC and you need to convert into your local format.

Hope it helps: https://stackoverflow.com/questions/36642327/sharepoint-wrong-date-in-word-templates-quick-part

Thanks

Please click Accept as solution if my post helped you solve your issue. If the content was useful in other ways, please consider giving it Thumbs Up.

[aebara]

Wonderful, thank you!