Flow 'Get Item' showing wrong date from Sharepoint list.

(0) Share

Report

Posted on by KennyK

Hello,

I'm experiencing an issue where my flow is showing an incorrect end date from the Sharepoint list event date.

In sharepoint the End date is 4/22

2020-04-21 10_03_01-COVID Labor Pool Tracker Calendar - All.png

However in 'Get Item' , the date is showing as

2020-04-21 10_08_44-Run History _ Power Automate.png

The only common denominator is that the all of the dates causing the issue have a time of 11:00 PM. Anything set earlier doesn't seem to have an issue.

Has anyone else run into anything like this?

thanks

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Gristy 2,429 on at

Like (0)

Report

Hello,

Date/Time is stored in UTC format, i assume your regional settings in SharePoint are not UTC.

You can use convert time zone action in flow to convert the date if you need to display in your local regions timezone.

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@KennyK

All dates in SharePoint are stored in UTC - your data is displayed on your site in your time zone (usually).

So, you have a time zone issue. Take a look at the Convert time zone action or the following expressions if the time difference is causing you issues.:

Was this reply helpful? Yes No
KennyK 29 on at

Like (0)

Report

I've found my issue. I wasn't converting the entire date.
Just the times.

Was this reply helpful? Yes No
alrezac on at

Like (1)

Report

Hi,

Looks like you got your issue sorted out. I just wanted to add on a bit more information here on date conversion if you would like to learn a little bit more.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No