Hi,
I'm having trouble displaying date/time columns in a list's calendar view. Full day events are displayed spanning 2 days:
Background info about my data and schema:
- The data is coming into a Power Apps table from a SharePoint list as a text string (e.g. "10/28/2023 10:30:00 AM").
- In my dataflow, the date strings get transformed into a Date/Time column (not a Date/Time/Zone column), (e.g. 10/28/2023, 10:30:00 AM)
- In Power Apps, the date columns have the following setting:
- Time zone adjustment: Time zone independent
- I created a Calendar View in Dynamics 365 for the table/list with the following settings:
- Time Zone Display Mode: Specific Time Zone
- Display Time Zone: (GMT) Coordinated Universal Time
Configuring the Calendar View time zone settings in Dynamics 365 allowed my events to display the correct date/time. Without them, the calendar still tried to display them with a Pacific Time offset. Even though the times are now correct, events that are 12:00 AM to 12:59 PM (all day events) don't appear correctly. They come up spanning 2 days.
After editing the times for one of the events, I realized the calendar view still treated the date as if it was in Pacific Time, even though the calendar is configured for UTC. Anyone know a solution to this?
Either the calendar view is buggy or I'm missing something. I'm thinking of doing the following:
- Setting a Pacific Time zone in the data flow so all times are in Pacific Time, and just let calendar view display the way it wants to (local time).
- But I don't think this will work because I've already had problems where events on Pacific Standard Time appear incorrect when Standard Time transitions to Daylight Time (events past that transition are off by 1 hour).
- Alternatively change my time zone to Arizona so the system hopefully stops trying to be clever. This seems like a crazy solution.
Any help appreciated!
Albert
