Potential Bug: Wrong time saved to SharePoint from Canvas App on the Sunday of Daylight Savings

[quail]

I have a Canvas App with a SharePoint Online List as a data source. It has two Date/Time columns. When creating a new event through the Canvas app for November 7, 2021, the switch over for Daylight savings, it will save the wrong time to SharePoint. For example, if I enter 10am in the app, it will save as 9am to SharePoint. It will display as 9am in the app as well. 11/6 and 11/8 save correctly. I imagine this will be the same for the Spring change over as well. 

I am in the US in the Eastern Time Zone. 

Updating with the below information: 

I am using the out of the box Edit Form in Canvas app to write to a SharePoint list. The update formula for the date/time card is:

DateValue.SelectedDate + Time(Value(HourValue.Selected.Value), Value(MinuteValue.Selected.Value), 0)

For all days except the DLS change over days, like 11/7, it works fine. Only on 11/7 is the time wrong. 

I recently discovered that if you DateDiff Between 11/7 and 11/8 you get 25 hours. The spring change over is 23 hours. 

25 hours = DateDiff( 11/7 12AM, 11/8 12AM, Hours)

This suggests to me that there might be something off in how Power Apps is calculating the hours on these days

To test this, place a Datapicker on the screen. Add a label and put the following formula:

DateDiff(DatePicker.SelectedDate, DateAdd(DatePicker.SelectedDate, 1, Days), Hours)

[StalinPonnusamy]

Hi @quail 

Did you tried to convert the date to UTC time like

StartDate: DateAdd(DateField, TimeZoneOffset(),Minutes)

[quail]

hello @StalinPonnusamy , 

Thank you for responding. 

However, this solution did not work. I believe Canvas apps speaks with SharePoint in Local Time. Using this formulae saved the times in the adjusted UTC time, so for 10am it saved as 2pm on 11/7, on 10/1, as 1pm. 

Let me provide a little more information. 

I am using the out of the box Edit Form in Canvas app to write to a SharePoint list. The update formula for the date/time card is:

DateValue.SelectedDate + Time(Value(HourValue.Selected.Value), Value(MinuteValue.Selected.Value), 0)

For all days except the DLS change over days, like 11/7, it works fine. Only on 11/7 is the time wrong. 

I recently discovered that if you DateDiff Between 11/7 and 11/8 you get 25 hours. The spring change over is 23 hours. 

25 hours = DateDiff( 11/7/2021 12AM, 11/8/2021 12AM, Hours)

This suggests to me that there might be something off in how Power Apps is calculating the hours on these days. 

[John_Dang · Accepted solution]

This is a known issue.

You can use this code in the update property of the data card:

Concatenate(Text(DateValue1.SelectedDate)," ",Text(Value(HourValue1.Selected.Value)),":",Text(MinuteValue1.Selected.Value))

[quail]

Thank you! That seems to work. I was using the rather convoluted solution below. But yours is much simpler. Thank you.

With(
    {Date: DateValue1_2.SelectedDate, Hour: HourValue1_2.Selected.Value, Minute: MinuteValue1_2.Selected.Value},
    If(
        Value(Hour) = 0,
        Date + Time(Value(Hour), Value(Minute), 0),

        Date + 
        Time(
            Switch(
                DateDiff(Date, DateAdd(Date, 1, TimeUnit.Days), TimeUnit.Hours),
                25,
                Value(Hour) + 1,
                23,
                Value(Hour) - 1,
                Value(Hour)
                ), 
            Value(Minute), 
            0
        )
    )
)