Unanswered

Date display issue in power apps using SharePoint online list

(0) Share

Report

Posted on by vijayk

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Someone had similar issue on sharepoint date. After going through this post is was resolved. Check if it can help
https://powerusers.microsoft.com/t5/Building-Power-Apps/9h-time-difference-between-a-submitted-powerapps-date-and-the/m-p/469337

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
@vijayk

+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."

Was this reply helpful? Yes No
vijayk 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No