Date is Good, Time is not

[cadone]

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?

[PrasadAthalye · Accepted solution]

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.

[cadone]

@PrasadAthalye 

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