cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SamuelSantos
Level: Power Up

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_error_01.jpgFlow send the desire date and time.

FLOW_error_02.jpgSharepoint is not showing the time I sent.FLOW_error_03.jpgExcel 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
Dual Super User
Dual Super User

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
AKRogers
Level 8

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!

Dual Super User
Dual Super User

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

SamuelSantos
Level: Power Up

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

 

 

SamuelSantos
Level: Power Up

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?

AKRogers
Level 8

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
Dual Super User

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.
SamuelSantos
Level: Power Up

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,882)