Power Platform Community Forum Thread Details

Hi all,

I'm trying to figure out a way to manage daylight savings time for a staff scheduling tool I am creating with Power Apps/Power Automate/SharePoint Lists.

I am using the Date Picker in Power Apps along with a dropdown box (this part is for the time) to select the start and end of a shift. Right now I've got it set up to where the date/time successfully goes over to Power Automate and is then used to create a new list item in SharePoint which is displayed using the calendar view option for lists. The date/time is currently going from Power Apps to Power Automate in this format: 2021-05-24T04:30:00Z.

I understand the Z makes it UTC, so I need to do some conversion prior to that point, because it ends up showing in local time on my SharePoint list calendar, e.g. 11:30pm 05/23 instead of 4:30am 05/24 using the example in the previous paragraph. That part I think is simple enough. The problem I am trying to think through is that no matter where the user is located when viewing or editing these items, I want it to always have the same start and end time. So if the manager writes a couple months worth of schedule with start times of 6am, that doesn't get shifted when we change DST from UTC -5 to UTC -6 here in central US time zone.

Is there any advice or best practice on how to format my date/time items or strings when they get sent from Power Apps to Power Automate to account for this?

Thanks for any help!

Categories:

Building Power Apps