Answered

Date picker not patched correctly

(0) Share

Report

Posted on by MostafaGamal

Hi All, i use date picker in power apps and this data is patched in SharePoint but when i choose a date the value saved in the SharePoint is one day earlier than what i choose

for example if i choose 2 of Dec the date saved us 1 of Dec

How to solve that ? Power Apps.PNG

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MostafaGamal ,

It is probably because your SharePoint settings are on a different time zone to your local PC.

Have a look at the TimeZoneOffset function

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

.
MostafaGamal on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz i read the topic but i didnt yet now how to fix this issue
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@MostafaGamal ,

What code have you tried - happy to look at it.
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi@MostafaGamal,
Based on the issue that you mentioned, do you want to patch the real date to your SP list?
Do you mean that the date in SharePoint is different from the date selected in PowerApps?
The reason why you met this problem is that:
SharePoint's default time zone is based on your set in the Site Settings
PowerApps' default time zone is local time zone.
So when PowerApps load time, it will transfer to local time automatically.
Please check the difference as follows.
// Date time in PowerApps:
You can see that if I don't change the Date time zone into UTC, the PowerApps will always load Beijing time zone by default because I am located in China.
// Date time in SharePoint:
You can go to Site information->View all site settings->Regional settings to set your time zone.
Please change the time zone and Locale to your current location and time zone.
Then the time zone will be same in PowerApps and SharePoint.
When you loading time from the SharePoint list, date time will not change.
Please check if this could work for you.
Regards,
Qi