cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cadone
Helper V
Helper V

Date is Good, Time is not

All,

 

In my flow, I am using current time & convert time to my time zone actions. Flow works well. After running the flow, I verified the flow by expanding the actions. The time / date is prefect in the convert to my zone action.

 

I do a update item action so the share point list item shows that date/time. Here the date is good. time is about 6 hours slow. I checked the regional setting in the SharePoint site settings. its shows my time zone.

Also, I want to show date & time in 2 separate columns. possible?

 

What could be wrong with the mismatch?

Why is the time on the 'update item' action writing 6 hours less?

Screen Shot 2021-02-13 at 11.23.57 PM.png

1 ACCEPTED SOLUTION

Accepted Solutions
PrasadAthalye
Community Champion
Community Champion

Sharepoint stores all date fields in UTC. That is, if you are saving a datetime field in a list, Sharepoint actually converts the time that you selected into UTC, and converts it back to whatever time zone the person is in when retrieving.

 

So If you wish to write current local time in the SharePoint list, do not convert to your timezone. Just just UTCnow() expression in update item and it will work.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

2 REPLIES 2
PrasadAthalye
Community Champion
Community Champion

Sharepoint stores all date fields in UTC. That is, if you are saving a datetime field in a list, Sharepoint actually converts the time that you selected into UTC, and converts it back to whatever time zone the person is in when retrieving.

 

So If you wish to write current local time in the SharePoint list, do not convert to your timezone. Just just UTCnow() expression in update item and it will work.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

@PrasadAthalye 

 

Thank you so much for explaining how the time works with SharePoint. I never knew.

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,185)