TimeZone issue after winter time came into effect in the Netherlands, cannot use 30-10-2022 as a date anymore

(0) Share

Report

Posted on by debarbanson

187

Hi all,

I have a form in edit mode which looks as the following. Date / Time is picked up from Sharepoint list.

Screenshot 2022-11-03 at 15.28.43.png

All of a sudden, if the user wants to save the date as 30-10-2022 (when winter time came into effect in the Netherlands), it will subtract one hour from the entered time (so e.g. input is 7.45, after save it becomes 6.45). The form mode also stays in Unsaved mode, that's why the Save and Cancel item also remain visible.

Given there is a check when navigating away from the screen if there are unsaved changes, the user is currently stuck on this screen.

Only escape is to change 30-10-2022 to e.g. 29-10-2022 and then it will save perfectly fine. As can be seen below, Save and Cancel button are not visible and in Sharepoint the date/time equals the input in PowerApps.

Screenshot 2022-11-03 at 15.32.37.png

Looking at Sharepoint, if I try to save as 30-10-2022 06.45, it will store it as 05.45, that's why I guess after the save the time gets reflected minus one hour in Powerapps.

Timezone settings of the Sharepoint site are as follows:

Screenshot 2022-11-03 at 15.36.12.png

Settings of the DataCard:

Default: ThisItem.'Arrived Load Terminal 1'

Update: DateValue26.SelectedDate + Time(Value(Hourvalue26.Selected.Value), Value(MinuteValue26.Selected.Value),0)

Settings of the DatePicker

Screenshot 2022-11-03 at 15.38.15.png

Screenshot 2022-11-03 at 15.44.46.png

I am a bit clueless on how to solve this issue? Stating to the user please do not use 30-10-2022 as a date does not make sense, there must be a reason why this is happening and hopefully also an easy fix to work around this.
Hope someone can help me out! Many thanks in advance!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

debarbanson 187 on at

Like (0)

Report

@RandyHayes, do apologize for tagging, however you have helped me out in the past, do you have any idea how to tackle this with your power apps super powers?
I'm really stuck and users need to continue working with the app tomorrow and so far, I do not have a solution besides not using 30-10-2022, which is not a solution.

Was this reply helpful? Yes No
debarbanson 187 on at

Like (0)

Report

Made a bit more progress myself, it has to do with the Format I use ("dd-mm-yyyy").
If I update the Language field of the Datevalue card to 'nl-NL' then it at least stores correctly if I input 30-10-2022 00:00.
However the moment I want to input 30-10-2022 03:00, Sharepoint automatically saves this as 30-10-2022 02:00. And all times I enter after 02:00 for that specific date until 23:59 will be saved - 1 hour. So 23:59 ends up as 22:59.
The moment I input as date 31-10-2022 00:00 or any time after that, it saves it correctly.
So the issue is really pinpointed to this specific date that the Daylight Savings Time ends and StandardTime kicks in again (which in the Netherlands in practice means that at 03:00 the time is set back to 02:00.

How can I work around this and still be able to store 30-10-2022 03:00 in Powerapps in a way that Sharepoint will also save it as 03:00?

Was this reply helpful? Yes No
Verified answer

debarbanson 187 on at

Like (1)

Report

Topic can be closed. Solved it as follows by changin the update statement of the DataCard:
Please note I start with an if statement to check for blank value since not in all cases in my app a date will be filled upon initial input, if so it will just pass an empty field to Sharepoint.
If you don't include that, it seems to take the date of today, which was something I did not want to happen 🙂

If(DateValue2.SelectedDate = Blank(),
DateValue2.SelectedDate + Time(Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value), 0),
DateTimeValue(
Text(
DateValue2.SelectedDate,
DateTimeFormat.ShortDate,
"en-GB"
) & " " &
Time(Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value), 0),"en-GB"))

Hopefully usuful to someone else in future as well

shoutout to this blog as well which helped me get going:
https://linnzawwin.blogspot.com/2020/10/time-picker-in-power-apps-canvas-app.html

Was this reply helpful? Yes No