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