I created a flow with an email trigger. I saved some information from the mail in SharePoint.
In the screenshot you can see the timestamp from flow when the email is arraived ("Zeitpunkt") and the timestamp when the item is created ("Erstellt").
This two actions happed 6 minutes successively. So the timestamp in the field "Zeitpunkt" is wrong. It should be 02.01.2018 16:04.
Wrong Timestamp in SharePoint
What is happend? I checked the timezone settings in the SharePoint website and in Flow.
Timezone in Flow
Timezone in SharePoint Website
The timezone in Flow is in UTC. And the time zone setting in the SharePoint website in UTC +1.
Why is 2018-01-02T15:04:10+00:00 convertet to 2018-01-02T08:04:10+01:00 ?
What can I do to get the right timestamp in SharePoint?
@Anonymous
It's almost two years since your original post, but... you saved my week!
I think I found the reason you need to substract one hour when transforming timezone from UTC to (UTC+1) in order to store the right value in your sharepoint
You are using a Text column to store the value instead of a Date column, right?
I got this result when I substracted 1 hour when transforming timezone, my local time is also (UTC+1) and my sharepoint site is proprly configured.
Creado column correspond to 'Created': 09:40 local time (UTC+1)
On the first three columns I am storing the REceivedDateTime from a new email received, applying the same Flow TimeZone manipulation in all these three cases: source time zone (UTC-1), destination TimeZone (UTC+1)
EmailDateText: Text column (09:40, UTC+1: my local time)
EmailDateTimeDate: Date column, no time displayed
EmailDateTimeDateTime: DateTime column (10:40, UTC+2)
Now on the fourth column, I am storing the result of utcNow() without Timezone manipulation
utcNow column: Text column (08:40, UTC)
Thanx again!
Hi,
I was experiencing a similar issue in my Work Tracker flow (see "Quickly track your work hours and work location in an Excel table" template). The time stamp was being recorded as 5 hours ahead of my current UT-6 time (US CT time). I used a convert time zone action and then referenced that action in the "add row in table" excel action below, and it works for me now.
I'm not sure if this is the best fix, but I'm posting in case someone else may be able to use it to help fix their issue.
Thanks!
Shelby
Sorry but I am not satisfied sending an email with options as it does not provide the approvers comments. Here is a screen shot and sorry to take up your time but if you can help me get this working but with my time zone as I'm in Chicago,Ill
I ended finding a work around that does not display the UTC time so I thought I post it here. In the yes or no approval at the end select the send an email trigger at the end of the flow.
https://syscloudpro.com/2018/02/08/microsoft-flow-approval-email-send-with-options/
How is that done if I might ask? Where do I edit this from? I was able to get the correct time zone but on an approval email being sent, it shows the correct time zone & Microsoft's time zone which is 6 hrs ahead of my time. I would like to either correct it or make is invisible in the approval flow email.
Hi @Anonymous,
That is an excellent point you make about the summer/winter time change since we also experience that in the US.
@v-xida-msft, any chance you can talk to the Flow team about that? I know not all countries observe time change during the year, but for the other ones, this might be an issue.
Regards,
Fausto Capellan, Jr
Hallo Kris,
I converted the timestamp in Flow as you suggested.
In my first try, I converted the time in my own time zone +1. As you can see in the screenshots, there is the right time in Flow. Nevertheless, if I save this timestamp in a date/time field in SharePoint, it’s one hour too late.
Right timestamp in Flow after converting to UTC +1
Wrong timestamp after saving this timestamp in SharePoint
That is a strange result.
Therefore, I converted the timestamp in the second try to GTM (+0). GTM and UTC should be the same time zone…
I wondering but now there is the right time in SharePoint. (See in screenshot below.)
Convert timestamp to GTM
Right timestamp in SharePoint after saving the GTM time
I hope this converting do not make problems with our summer/winter time change. Do you have any experience?
Best regards,
Anja
Hi @Anja,
Which time zone does your received email stay in?
I agree with @faustocapellanj’s thought almost, I think this issue is related to the time zone. The Microsoft Flow would convert your date and time into UTC format (UTC +00:00) automatically, no matter which time zone is set on your side.
You could consider take a try to add a “Date Time – Convert time zone” action within your flow (which @faustocapellanj suggested) and convert the data and time into your time zone:
More details about the usage of “Date time - Convert time zone” action, please check the following article:
https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/
Best regards,
Kris
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2