Clock change - Power App Collection Date column showing wrong Time

(0) Share

Report

Posted on by Epidot

Hi,

The clocks change on the weekend and now I have a problem with the Date/Time I cannot seem to correct.

A Sharepoint list is the source for my Power App with a Date column. These dates in Sharepoint are correct.

My Power App uses the SharePoint list and creates a collection. But as shown below Power Apps is for some reason adding 1 hour to the time.

Where within Power Apps can i amend the Time Zone to correct this?

My Language and time settings show no time settings!

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

Hi @Epidot ,

Yes - daylight saving issues. Firstly Power Apps takes the Regional Settings from the user's device, so that needs to be checked. Your Regional Settings in SharePoint should look something like this

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Epidot 94 on at

Like (0)

Report

Hi. I have tried variations of times on SharePoint and made no difference. My computer time is correct also. What I'm not understanding here is that the power app should simply display the date time that is in the SharePoint list. What is making it adjust that time zone... It should just display the field as it is in SharePoint right? I'm not asking power app to display the date time now, only asking it to display the value in the SharePoint list. I don't understand it.

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

@Epidot ,

The issue is with your local device and I have struck it before, but only on the actual day the daylight saving changeover occurs - when the field is date only, it displays the previous day. It actually saves correctly in SharePoint if the date is chosen in a Date Picker and I ended up hard-coding references to that date adding an hour.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Epidot 94 on at

Like (0)

Report

How do I hardcode to subtract an hour to power apps? Is it easier if I make a new column in the SharePoint list, referencing the date time and subtracting an hour there or can it be done directly in power apps? Thanks

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
Hi @Epidot ,

This is an example of a Label in a Gallery using 1 April 23 as the target date

If( Text( ThisItem.YourDateField, "ddmmyy" ) = "010423", DateAdd( ThisItem.YourDateField, -1, TimeUnit.Hours ), ThisItem.YourDateField )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Epidot 94 on at

Like (0)

Report

Thanks fixed it now with

DateAdd(
ThisItem.'Time Received',
-1,
TimeUnit.Hours
)

Guess i have to keep changing this every time the clocks change.

Thanks for the help.

Was this reply helpful? Yes No