Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Incorrect Sharepoint Date & Time List Field Update

I have an approval workflow linked to a sharepoint list, that updates status of a list item based on the response of the approver. There are two date and time fields in a list item. The issue is that when the list item is updated using the Update List Item action, the two date and time fields get incorrect values. There's a 7 hour difference between the initial list item values and the updated list item values. Below is an example.


Initial List Item Values (Before Update)

Visitor Arrival: 4/16/2017 9:00 AM
Visitor Departure: 4/16/2017 12:00 PM


Updated List Item Values (After Update)

Visitor Arrival: 4/16/2017 2:00 AM
Visitor Departure: 4/16/2017 5:00 AM


Can somebody help me out please? Below is a screenshot of the workflow.


Manage your flows - Microsoft Flow (1).jpg


Helper II
Helper II

Looks like others have the same problem as I do.

I got a flow that creates a row in a Sharepoint list... and the time values was 09:53 in the output from the flow... but sharepoint shows 11:53... so I checked sharepoint regional setting and it's utc+1 (as it should)... so I then created a text field and had the flow send in the time there aswell... and it turned out correct.

So Power Automate sends 09:53
Sharepoint Datefield shows 11:53
And Sharepoint textfield shows 09:53


Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,351)