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 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

BUT WHY?

Helpful resources

Announcements
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)