cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Dual Super User II
Dual Super User II

Re: Incorrect time showing in Sharepoint List send by Flow

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

7 REPLIES 7
Highlighted
Helper V
Helper V

Re: Incorrect time showing in Sharepoint List send by Flow

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!

Highlighted
Dual Super User II
Dual Super User II

Re: Incorrect time showing in Sharepoint List send by Flow

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

Highlighted
New Member

Re: Incorrect time showing in Sharepoint List send by Flow

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".

 

 

Highlighted
New Member

Re: Incorrect time showing in Sharepoint List send by Flow

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?

Highlighted
Helper V
Helper V

Re: Incorrect time showing in Sharepoint List send by Flow

@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

Highlighted
Dual Super User II
Dual Super User II

Re: Incorrect time showing in Sharepoint List send by Flow

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.
Highlighted
New Member

Re: Incorrect time showing in Sharepoint List send by Flow

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!

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (6,943)