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.
What is happend? I checked the timezone settings in the SharePoint website and in Flow.
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?
Even thugh your tenant is set to your respective time zone, Flow will always read date and time in UTC. Perhaps you can try using the Date Time - Convert time zone step to convert your date/time to your time zone. I've had to do this in the past and it's really inconvenient, but to me that seems to be the only way to work around the whole UTC format in Flow.
Fausto Capellan, Jr
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:
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.
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.)
I hope this converting do not make problems with our summer/winter time change. Do you have any experience?
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.
Fausto Capellan, Jr
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.
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.
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 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.
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)
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications