web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : dcxEOU1eXKUqSLUW4n0k7B
Power Automate - Building Flows
Unanswered

Wrong Timestamp in SharePoint

Like (0) ShareShare
ReportReport
Posted on 2 Jan 2018 15:34:25 by

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 SharePointWrong Timestamp in SharePoint

 

What is happend? I checked the timezone settings in the SharePoint website and in Flow.

Timezone in FlowTimezone in FlowTimezone in SharePoint WebsiteTimezone 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?

  • efialttes Profile Picture
    14,756 on 20 Nov 2019 at 08:59:16
    Re: Wrong 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.

     

     

     

    FlowSPDatesFromOutlook.png

     

    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!

  • Community Power Platform Member Profile Picture
    on 01 Aug 2019 at 15:39:43
    Re: Wrong Timestamp in SharePoint

    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. 

    Flow Work Tracker Time Conversion.PNG

    Thanks!

    Shelby

  • ahernandez Profile Picture
    14 on 12 Jun 2019 at 15:30:27
    Re: Wrong Timestamp in SharePoint

    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

  • ahernandez Profile Picture
    14 on 12 Sep 2018 at 21:08:51
    Re: Wrong Timestamp in SharePoint

    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/

     

  • ahernandez Profile Picture
    14 on 07 Sep 2018 at 13:34:57
    Re: Wrong Timestamp in SharePoint

    I sure can here you go

     

    https://www.screencast.com/t/2Mf0tc0r

     

     

     

  • faustocapellanj Profile Picture
    1,662 on 07 Sep 2018 at 01:03:15
    Re: Wrong Timestamp in SharePoint

    Hi @ahernandez

     

    Can you please post screenshots of your flow so we can take a look at it?

     

    Thanks.

  • ahernandez Profile Picture
    14 on 29 Aug 2018 at 15:04:27
    Re: Wrong Timestamp in SharePoint

    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.

  • faustocapellanj Profile Picture
    1,662 on 03 Jan 2018 at 14:58:01
    Re: Wrong Timestamp in SharePoint

    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

  • Community Power Platform Member Profile Picture
    on 03 Jan 2018 at 08:23:44
    Re: Wrong Timestamp in SharePoint

    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 +1Right timestamp in Flow after converting to UTC +1Wrong timestamp after saving this timestamp in SharePointWrong 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 GTMConvert timestamp to GTMRight timestamp in SharePoint after saving the GTM timeRight 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

  • v-xida-msft Profile Picture
    on 03 Jan 2018 at 03:30:33
    Re: Wrong Timestamp in SharePoint

    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:10.JPG

     

    11.JPG

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete