PowerApps SharePoint O365 List Items timezone issue

(0) Share

Report

Posted on by KalyanPolasi

I am having this issue with SharePoint list customized using PowerApps.

Few things to know about:

My SharePoint regional settings are EST
User Local Settings are IST

Issue:

Our SharePoint list has DateTime column for the user to input date. So, when user picks time in IST on the customized form and saves it, SharePoint is again converting it to IST by thinking the submitted information is in EST. So, the time that gets saved on SharePoint is incorrect

E.g.,

User selects 11AM IST on PowerApps customized form and submit.
It gets saved as 9:30PM IST. As I mentioned above it seems it is treating 11AM IST as 11AM EST and converting it to 9:30PM IST.

Interestingly, when I open the submitted item to read - it shows the 11AM on the PowerApps form. So, the problem is when we see the submitted Date value on SharePoint view.

Thanks,

Kalyan Polasi

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

KalyanPolasi 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Guys,

Did anyone got chance to look at this? Any directions please
KalyanPolasi 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Guys,

Did anyone got chance to look at this? Any directions please
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for posting in the community @KalyanPolasi. Please review the below response from another thread where a user was having a similar issue. Let me know if it helps!

Based on the issue that you mentioned, I think this issue is related to local Time Zone and the Time Zone format of your SP Site.

I think the TimeZoneOffset function could not achieve your needs. The TimeZoneOffset function returns the number of minutes between the user's local time and UTC (Coordinated Universal Time).

If the users and you are in different time zone (e.g. the user is in EST, and you are in PST), even you and the end users enter same date time in Date Time field within your app, the display date time value in your SP list would also be different.

Currently, as an alternative solution, if you want the end users to see same date time value within your SP list, please ask them to convert their Time Zone format of their SP Site into the same one as you (converted into your local time zone).

@Anonymous
rebeccas 2,591 on at

Like
a
(2)

Report
Copy link

Link copied!

Check your time zone in SP. For some weird reason it can be different on each site AND on each list. This one has got me several times..super annoying!