Answered

Incorrect time showing in Sharepoint List send by Flow

(1) Share

Report

Posted on by SamuelSantos

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.

Sharepoint is not showing the time I sent.Excel 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?

Categories:

General topics

I have the same question (0)

All responses (18)

Answers (1)

AKRogers 354 on at

Like (1)

Report

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:

The update:

The outcome in SharePoint:

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!

Was this reply helpful? Yes No
Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (7)

Report

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.

Was this reply helpful? Yes No
SamuelSantos 14 on at

Like (0)

Report

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

Was this reply helpful? Yes No
SamuelSantos 14 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
AKRogers 354 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
SamuelSantos 14 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
ninjaryder1st 234 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
DragonLord 200 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ninjaryder1st 234 on at

Like (0)

Report

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

Was this reply helpful? Yes No