Unanswered

Populating a word template from a Sharepoint List is not copying the dates and time correctly

(1) Share

Report

Posted on by matty2000

I have a Flow that works well except for when it populates the date and time from SharePoint as it is correct in SharePoint but when the word document is populated, the date seems to be changed to UTC time. How do i stop the time from being converted by the Populate a Word template connector or Power Automate?

This seems like an easy fix but i have checked my Account settings and all regions are set to the correct time zone including SharePoint. Is there something i am missing here?

SharePoint List date and Time:

Power Automate Time and Date:

Any help would be greatly appreciated,

With Thanks,

Matt

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi Matt,

The input date time is in UTC format. You need to apply function to convert to local time zone. Here is an example:

In the below example, I am converting UTC time to IST (India Standard Time):

convertFromUtc('2024-07-24T03:00:00Z','India Standard Time','MM/dd/yyyy hh:mm tt')

Replace hardcode datetime value with input datetime dynamically in the above expression.

Output:

Was this reply helpful? Yes No
matty2000 42 on at

Like (0)

Report
Copy link

Link copied!

Hi Manish,

Thanks for the prompt response and i have attempted your solution and it does not work as intended as my compose action does not work due to the SharePoint Date not being the correct format:

Compose error:

Compose Function:

SharePoint Field Output from get item action (Field 4 is Date and Time type field):

Can you please advise upon what changes i need to make to make this work? Do i need to convert the field to a string and how do i do this?

Thanks in Advance for your assistance.

Was this reply helpful? Yes No