Below is my current setup for DateTimeZone.
It is set to local.
User1 is CST
User2 is EST
User3 is Mountain
User4 is Pacific
So I will have people from each of the time zones using this tool.
When they submit the case, it will update SPO.
Right now, when each user submits their ticket, the time will reflect their individual time zone.
So I want to know, if this is possible, or if there is an easier way to do this.
I want the app to display local time zone to the end user. So that is all working as it should.
What I would like to do, is when the user submits their ticket, the time that is posted will be CST to SPO.
Example.
User2 who is EST. User2 pulls up the tool at 9:00am their local time. They are submitting at ticket at this time. It shows 9am to them, all is good. They click submit, and it goes back to the first screen as it should. The time that actually gets posted to SPO though, is 8am CST.
So, is there a way to local time zone, but when the App goes to submit the time to SPO, it converts the time to CST (without the user seeing it in the APP), and posts the time to SPO in CST.
SharePoint stores Date/Time as UTC and when it displays the Date/Time in SharePoint it converts it to the time zone set in the users SharePoint Profile. If the user doesn't have a time zone set in their profile then it will use the default time zone of the site.
When Power Apps gets the Date/Time from SharePoint it is in UTC and then convert to the users local time based on the time zone of the user's device (pc or mobile device). When you save Date/Time to SharePoint from Power Apps it converts the Date/Time to UTC based on the time zone of the user's device.
If the users have their time zone set the same on both their device and SharePoint then the Date/Time should display correctly for everyone. Most of time when there are time zone issue it is because a user doesn't have their time zones set correctly in SharePoint or on their device.
WarrenBelz
146,651
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional