Unanswered

Date values coming different for few users while submitting details using PowerApps

(0) Share

Report

Posted on by AJ_vizMan

Hi team, we have a PowerApps created in our organization. And Users are now facing an issue while submitting details using App.

Issue : User A select Date value as 10/10/2022 but, it is saved in SharePoint list as 09/10/2022. And Users can see the details submitted with date 09/10/2022.

There is difference of 1 day.

Connect Date is the control used to select Date. It is 'Date & Time' type column in SharePoint list.

I am using 'Local' Date Time Zone and SharePoint site has 'UTC-8 Pacific Time (US & Canada) time zone setting.

Can you please suggest potential issue of date difference? Thanks for help

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-jefferni on at

Like (0)

Report
Hi @AJ_vizMan ,

Sounds like a Daylight-Saving Time issue. Please try and save the date in UTC time zone. Update of this Data Card try:

DateAdd(DataCardValue5.SelectedDate, TimeZoneOffset(), Minutes )

and set DateTimeZone of DataCardValue5 to DateTimeZont.UTC

Best regards,

Was this reply helpful? Yes No
AJ_vizMan on at

Like (0)

Report

Hi @v-jefferni - Thank you for response. But, Above solution still doesn't help to resolve.
Are other things might result the issue? 1. Time zone in SharePoint site where List is hosted to store data?

I have set 'UTC' time zone in SharePoint site where list is hosted.
Please suggest ways to resolve it

Was this reply helpful? Yes No