cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hasitha360
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

 

10 REPLIES 10
FUS
Helper III
Helper III

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

BUT WHY?

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Kudoed Authors
Users online (2,560)