cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rixmcx59
Helper II
Helper II

Create item action subtracts 1 day from date values

Hello all, I have a workflow with 2 date columns, Start Date and Created Date. When my Create Item action runs it's subtracting 1 day. 7/22/2022 becomes 7/21/2022. Do i have to set the time zone somewhere in the flow? I have not had to do this in the past?

 

thanks

3 REPLIES 3
MarconettiMarco
Super User
Super User

Hello @rixmcx59 ,

usually you don't have to put the right timezone, cause PA is getting your env/tenant timezone.

What's exactly the issue?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

rixmcx59
Helper II
Helper II

I have  2 identical SharePoint lists, one for current data, one for history. My workflow copies the current data to the history list (Create Item) then deletes all data from the primary list.

The Created Date and Start Date do not match in the 2 lists, as mentioned in my post, the dates in the history list are -1 day. Also The Created Date is a custom column, not SharePoint "Created".

Thanks for the reply

rixmcx59
Helper II
Helper II

My flow

rixmcx59_0-1659532570490.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,257)