search

aprildunnam / PowerApps

Collection of Power Apps template apps, components and examples
Other
422 stars 228 forks source link

Desk Reservations Time Inconsistent #102

Closed lsloyack closed 1 year ago

lsloyack commented 1 year ago

Good morning,

When inputting into the "Time Slot" section the confirmed value is inconsistent within the "Dashboard" and the "Desk Reservations" SharePoint list . (i.e. An input of 9AM to 10AM time slot will equal to 3PM to 4PM in the "Dashboard" and SharePoint."

Thank you for your time and the effort you put in developing such an incredible product!

Time Slot Input ![Time Slot Input 2](https://user-images.githubusercontent.com/124215780/218114079-1f10698d-393a-4f1d-915c-f08f05f6070e.PN Time Slot Input 3 G) Time Result Issue 1 Sharepoint Result Issue 2

blazniupnik commented 1 year ago

@lsloyack Check your sharepoint timezone. I also noticed time vary when reservations are made with different devices and their timezones/date formats set. Get back if you get any conclusions. All best

lsloyack commented 1 year ago

@blazniupnik Thank you so for the quick reply! The SharePoint time zone was incorrect. I converted the regional time zone from ET to CST though, unfortunately with no change. What is most perplexing, is that the TimeZoneOffSet() = 360. Which would equate correctly to CST. But, yet the issue remains unchanged?

Correct Timezone much for the quick reply! Timezones

lsloyack commented 1 year ago

Issue resolved for my needs all was needed was to remove the TimeZoneOffset entirely.

MikeBetts44 commented 1 year ago

Could you explain this solution a little more @lsloyack please? I've had to get everyone to change their browser language. Are you saying I don't need to do that?