cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SamuelSantos
New Member

Incorrect time showing in Sharepoint List send by Flow

Hi, guys.

 

I'm having a huge problema when working with time in Flow and Sharepoint (who isn't, right?). I'm able to get the time and convert to my TimeZone. BUT, everytime I send the time to an item in a list in Sharepoint, the time isn't correct, and I don't have any vague idea what's going on here. Can anybody know what am I doing wrong?

 

As you can see down below, Flow sends the time showing in my clock (16h07). But whan Sharepoint writes the same value, it shows 08h07. BUT excel receive the right one.

 

Flow send the desire date and time.Flow send the desire date and time.

Sharepoint is not showing the time I sent.Sharepoint is not showing the time I sent.Excel show the time I sentExcel show the time I sent

 

 

Of course there's a workaround, a bad one actually, to convert this time to a timezone with 8 hour different, but I don't want to believe this feature is this awful. It has to be one mistake, a silly one I'm doing here. I don't know what to do any more, I'm trying to fix this for a entire day. Please, can anybody help me?

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

Check the regional settings in the Site Collection settings in SharePoint.  SharePoint online normally defaults to whatever timezone the server is in unless you change the regional settings for the site collection.  For me that means Pacific Time, even though my local time zone is Eastern US.  Also, the Z you see at the end of the timestring in Flow says that time is being shown in UTC.  So if you input that into a SharePoint list it will display in SharePoint as 8 hours earlier (PST is -8 from UTC).  I suspect that is what you are seeing.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

12 REPLIES 12
AKRogers
Helper V
Helper V

Hi @SamuelSantos,

 

How are you getting the time and then converting it?  Also, do you know for certain that your SharePoint environment is configured correctly for your timezone?  

 

I made a quick flow that uses the Convert time zone action with a base time of utcNow().  I converted the time to my timezone and then used an Update item action to update a date field with that converted time value.  The correct time shows up in my SharePoint list.  Check it out:

ConvertTimeZone_111519.png

 

The update:

ConvertedTimeUpdate_111519.png

 

The outcome in SharePoint:

UpdatedTime_111519.png

 

Let me know a bit more about how you're getting the time and we can dig in!

 

Ashley

 

If this response provided an answer to your question please mark it as a solution so that others can find it.

If you found this helpful, consider giving it a thumbs up!

Pstork1
Dual Super User
Dual Super User

Check the regional settings in the Site Collection settings in SharePoint.  SharePoint online normally defaults to whatever timezone the server is in unless you change the regional settings for the site collection.  For me that means Pacific Time, even though my local time zone is Eastern US.  Also, the Z you see at the end of the timestring in Flow says that time is being shown in UTC.  So if you input that into a SharePoint list it will display in SharePoint as 8 hours earlier (PST is -8 from UTC).  I suspect that is what you are seeing.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Thanks for reply.

 

I'm not able to upload image here ( how do you uploaded an image to an reply)????

 

But I'm doing pretty much everything you are. Take the utcnow() and converting to my timezone (UTC-03:00) Brasilia.

 

I did another flow with another list just to test easily and the results are even more weirder. The same utcnow() variable, in Sharepoint list gives me as plain text: "11/15/2019 5:25:00 PM". And in the date field "15/11/2019".

 

 

I'm gonna check the settings as soon as I can, but was not me that put that Z in the end, was Sharepoint. There's anyway to prevent it?

@SamuelSantos 

SharePoint likes to have datetimes in the ISO acceptable format.  Check out the settings in that column to see the format that is currently being used for display!

 

Ashley

Yes, SharePoint put it there because it always stores everything in UTC format.  It only translates it for display.  On the web it will translate to the user's local timezone, but in PowerApps it tends to revert to the local of the server in my experience.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
SamuelSantos
New Member

Thanks everybody!

 

My Sharepoint was in wrong time in regional settings as @Pstork1 mentioned. And thanks @Pstork1 and @AKRogers to reply so fast. Was really helpful to me to understand better Flow and Sharepoint.

 

Turns out I didn't need to convert the timezone, Sharepoint (when properly set) handles this for us. I could just put the UctNow() in the field data, but as there was another problem, I wasn't aware of, I couldn't figure it out alone. Thanks!

You Sir, are good!     It was in the SP Site Settings<<Site Administration>>> Regional Settings.   This was for the entire SP site, not just the SP List I was working with.    All other settings for my computer were set correctly.   

DragonLord
Helper III
Helper III

i still have this problem.

my site is set to GMT and as we have just had daylight saving time, the hours are out by 1 hour

Hello @DragonLord,

 

Try checking and ensuring the time zone settings are correct for each step in your flow that deals with time (ie: check your settings for the source of your time (the site), and the end program (ie: Outlook calendar), along with any interactions in between that are built into the flow using PowerAutomate.  You might notice along the way that Microsoft converts to a "universal coordinated time" for Outlook meetings placed from a flow, but it still shows up at the correct local time on my calendar when converted back from Coordinated Universal Time (see image).  

ninjaryder1st_0-1617111484352.png

 

Its to do with the daylight saving.  PowerAutomate can cope with time zones but not with time zones that change through the year.  We really need computers, specifically SharePoint, Excel, Power Apps and Power Automate, to understand local time.  Or at least all three of them to interperate local time the same.

 

Unfortunately Ashley, nobody in the real world uses ISO acceptable formats, so SharePoint is out of step with the whole of humanity!!!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (4,153)