Unanswered

Powerapps and SharepointList with Date fields - Dates correct in SP, but not in PA.

(0) Share

Report

Posted on by martinav

3,347

There are a lot of time issues here regarding timezone and date time discrepancies. I did not find one that addressed my issue:

Conditions:
SP Regional settings UTC -6

PC Set to Central Time

MS FLow populates date field with UTC()

Sharepoint reads correct local time

Powerapps shows the next day if date is posted in the afternoon-ish.

Setup:

MS Flow populates Engineering Released date with UTC()

Sharepoint list shows this, which is correct:

Powerapps view shows this... in both a datacard, and a lookup field (value wrong):

Lookup command:

"Release Date:  "&Text(LookUp('Engineering Change Request',ECR_Number=ECRSelected,Engrg_x0020_Release_x0020_Date))

Settings for datacard:

Not sure how to fix this, without a "fake" that will still be correct when time changes for daylight savings.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

martinav 3,347 on at

Like
a
(0)

Report
Copy link

Link copied!

I just noted a situation... a post made before noon on one day is correct.... a post made just after noon shows the next day. Is the fact that the Flow UTC() function includes both date and time... and my time field is date ONLY... does the field round UP to the next day after noon is passed?? I would not have guessed this. As dates would typically roll on midnight, not noon even if rounded.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @martinav,

I think this issue is related to the Time Zone.

It is a known fact, when working date times within Microsoft Flow, the date time value would be converted into UTC Time Zone format.

Please take a try to set the Time Zone format of your PowerApps as that with your local Time Zone format, then check if the issue is solved.

Note: In order to set the Time Zone format of your PowerApps, please set the Time Zone format of your Office 365 (within Office 365 portal) and the Time Zone format of your browser to your local Time Zone format.

Best regards,

Kris

Was this reply helpful? Yes No
martinav 3,347 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft,

I have been through that exercise already. But, for sake of thoroughness, here are my settings:

Office 365 portal: good

And windows: good

Any other suggestions? This one appears to be just fine.

What about the issue of a data/time value going into a date only field? How does it handle rounding? This is after-noon, before-noon issue. If the time stamp is after noon, then the date flips up a day. Its not a 6hour off issue, but a 12hour off issue.

Was this reply helpful? Yes No