Dear Team, We r facing issue in the power apps view and edit forms for the date field.
Date field display is not consistent and showing diff value in the form even though list data is storing the correct value.
Eg. We have two records with 2020-Mar-01 and 2020-Mar-02. but the UI is showing both records as 2020-Mar-02
Also, one user have records for 1-Mar-2020 and 28-Feb-2020 but power apps form showing the 28-Feb-2020 record as 29-Feb-2020. Also, all previous records like 27th Feb and 26th Feb are displaying one day ahead like 28th Feb and 27th Feb,
Date field behavior is very unusual. we r left with no idea after all the troubleshooting done. Appreciate your help on this. Thanks in advance.
Hi @vijayk ,
Do you mean that the time value displaying differently in powerapps and sharepoint list?
The reason why you met this problem is that the default time zone is different in powerapps and sharepoint list.
PowerApps will always display local time by default.
While sharepoint display time based on the time zone that you set.
In your issue, I think the time zone you set in sharepoint list is different from the time zone in your current location.
So when you load time from sharepoint list, it will transfer to your local time automatically in PowerApps.
1)Time in PowerApps
Time will display as local time by default in powerapps. No matter which region you set in the studio page.
For example, I choose US as my region in this setting page.
However, since my current location is China, the time will display Beijing time by default in PowerApps.
2)Time in sharepoint
Time will not change based on your location.
You need to set your time zone manually.
Site information->view all site settings->region settings
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 sharepoint list, time will not change.
Best regards,
Yes, it's already set to DateTimeZone.local.
I used date time filed with date only option in SharePoint list. even though the date is showing 1st mar 2020 but in the form it's showing as 2nd March 2020. It's not happening for all the records. Thanks.
+1 to the comments of @RobElliott
You can also convert from UTC to local time by using this formula
DateAdd( your_date_here, −TimeZoneOffset( your_date_here ), Minutes )
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi @vijayk , make sure your DateTimeZone is correct in the app and not set to UTC, iI should be DateTimeZone.Local.
Also make sure your regional settings are set correctly for your SharePoint site (in Site Settings).
Rob
Los Gallardos
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 2