Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Dates changes into the previous day

I have created a sharpoint list and the form that is completed includes a requested date, however, once it is saved it keeps changing it to the day before!?!? No idea why this is suddenly happening, anyone else experience this?


I've turned on the audit trail whic alerts me when a change happens and this is what it is telling me. Is it something to do with the US time being 8 hours different?!?! Really confused....



Community Support
Community Support

Hi @linky_07,


This is because flow currently only supports UTC+00. We are planning to add support for Timezones in flow.


A workaround for now is to change the timezone from the sharepoint list to UTC+00.


You can also try to use the Workflow Definition Language addhours in compose action to change to the correct time:

1. First add the dynamic content (For example, the [Start Time] here) into the formula, just like you did before:

"@Addhours(body([Start Time], -1)"

2. Then save the flow, it will show you that the formula is not right, which would expose the code used for the dynamic content in the error messages part:

large (1).png

3. After that, remove the @{} symbol, which would leave only the contents body('Create_event')['Start'], then use this as the function parameter.





Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



This is not the problem, it is changing some I created yesterday and not others, maybe it is a sharepoint rahter than workflow.





Any news on my reply to this?

Hi @linky_07,


Will the date show correctly in SharePoint?




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

No, it's the sharepoint list that changes to the previous day!

Hi, I agree, I have the same problem here with 2 flows:

- 1st one is creating a new item in a Sharepoint list: in the output of the flow the "begin date" field is ok but it displays as the previous day in Sharepoint.

- 2nd flow is updating the previously created item (same Sharepoint list): same "begin date" field is updated, sometimes with the same value (the "begin date" didn't change between creation an dupdate), sometimes with an updated value. In both cases the date displayed in the Sharepoint list is then ok!


How come updating a date field fixes the "previous day issue" in a Sharepoint list? Could you please get back to us on this please?





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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,118)