Power Platform Community Forum Thread Details

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.

Categories:

Building Power Apps

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.