Answered

SharePoint list item is showing incorrect date and time.

(0) Share

Report

Posted on by Wompwoh

I have a flow that transforms attributes of a received email into a SharePoint list. I want the sharepoint list item to show the date and time the email was received to be classified as "Date Reported" in sharepoint.

However, there is a pretty huge time/date discrepancy that I'm not understanding. I originally thought it was an issue with sharepoint converting it to UTC time, but that doesn't seem to be consistent. For example, an email that was received on 9/13/2023 @ 11:22am is showing up as 9/12/2023 @ 5:00pm in sharepoint. If it was changing to UTC time, It should show up as 5:22pm, not 5pm flat. Even then, MST time is -7 to UTC and 11am to 5pm is only a 6 hour difference.

Any idea what's going on here? Let me know if I need to clarify anything.

Outlook:

SharePoint:

Here is the flow that takes the email data and transforms it into a sharepoint list item:

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

I suspect there are two things causing this. One is that a date/time field set to Date only will default to midnight UTC for the date supplied. That's why its 5:00 PM not 5:22 PM. The second thing is daylight savings time. That's why for that date its a 6 hour difference instead of 7 hours.

Was this reply helpful? Yes No
Wompwoh 19 on at

Like (0)

Report

MST time is not affected by daylight savings time, nor is UTC time. They're should be a 7 hour difference throughout the year. To your other point, is there a setting that will change this default time? I can't seem to find anything like that in sharepoint list settings unless I missed it. Is there a way to resolve this in Power Automate?

Was this reply helpful? Yes No
Verified answer

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Is the column in SharePoint set for Date Only? if it is then the default time is midnight and can't be changed. MST isn't affected, but during daylight savings SharePoint will interpret Mountain time as MDT , which is daylight savings time. Mountain Time Zone - Wikipedia But as you point out UTC doesn't observe Daylight savings, that's why the difference is now 6 hours instead of 7

Was this reply helpful? Yes No
Wompwoh 19 on at

Like (0)

Report

It's set to "Date & Time". I realized that by turning off the time component I do get the correct date. I think for my current use case, the time component is a "nice to have" sort of thing, but I will look at this another time if it becomes a need. Thank you!

Was this reply helpful? Yes No