Power Platform Community Forum Thread Details

I am using a Flow to generate a contract from a Word template using Power Automate which should add/merge the specific contract date from an item in List.

The date in List is 09/12/2024 (i.e. 09 Dec 2024) but the date the Flow adds is 08/12/2024 i.e. 08 December! Needless to say, I need the output contract date to be the same as the input contact date. I checked the regional settings in the Site and they are set to Europe UTC+1

Any ideas why this happens and any ideas for a work around?

Thank you in advance

Categories:

General topics

The key to understanding dates in a flow is to understand that they operate differently than they do in SharePoint. SharePoint stores all dates in UTC time. But SharePoint will adjust the dates automatically when saving them or retrieving them to match the regional settings of the Site. Power Automate doesn't do that automatic translation for you. So when you are reading/writing dates in the flow you should always be using UTC. In addition SharePoint will store the dates as Dates and Times even when they are set to be Date Only. I believe your problem is that the date you are retrieving is stored in UTC with midnight as the time. So when you key in 9/12/2024 in SharePoint in a site that is UTC +1 it actually stores it as 8/12/2024 11:00PM. When you then retrieve it in the flow you get the 8/12/2024 date.

The fix is to do the Conversion from UTC to your timezone for any dates that were added using SharePoint. There is a function for ConvertFromUTC() that can do that.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog