Force sharepoint date/time list field to display in another time zone

Question

I have a Sharepoint list that is getting entries populated from a power app. The Sharepoint list item that gets populated is a date/time field. What happens: The user selects November 1 at 9:00 am (for example) in the power app, it gets written to the sharepoint list, that list field is used to display in a calendar web part. Unfortunately, if the user is located in a time zone other than Central (our Sharepoint Regional time zone- which cannot be changed because we have offices in each US time zone), the time switches from what they selected (9:00 am in this example) to Central Time (11:00 in this example, as illustrated below). How can I force this date/time list field to display in the calendar as Pacific time? I'm guessing JSON in the list settings (image provided below also). If this is how to do it, could someone please provide the necessary JSON code I should use? Thank you in advance.
[

](https://filestore.community.support.microsoft.com/api/images/7835f385-32b3-4b4b-9b39-223a7d524dc6?upload=true&fud_access=wJJIheezUklbAN2ppeDns8cDNpYs3nCYjgitr%2bfFBh2dqlqMuW7np3F6Utp%2fKMltnRRYFtVjOMO5tpbpW9UyRAwvLeec5emAPixgq9ta07Dgnp2aq5eJbnfd%2fU3qhn54M29Xh6W5vv%2bdt2dNQDKfQW%2bFC5UvSpL5UYaXzgHxlNh%2bD2c8qzpWNe9vEisTCr9D1NeRPP1UDS15VwmQaxsgeawLoIz99EUK1%2fB%2b%2bYXY1N%2bekgdeAxihVHj3tWW5qyX7r48Ll1orW52pOaqJKk%2fykroLrnpLwoAP%2fNpfdvjq5ApZy4KeMgX7bLhaT8UooHWOzBVenXrddZk2UbyFkFOBzQeJ23nyYR%2bx0t8IeHEJHXilSvEf2aSjZ3Gd3sqRHtin%2b97WpqaN5Mqr2BoooP2ewvqXyfhACIUcykvZ763MGkY%3d"filestore.community.support.microsoft.com")
[

](https://filestore.community.support.microsoft.com/api/images/e19aabb1-d58a-45b2-8c5e-fb0c391443e4?upload=true&fud_access=wJJIheezUklbAN2ppeDns8cDNpYs3nCYjgitr%2bfFBh2dqlqMuW7np3F6Utp%2fKMltnRRYFtVjOMO5tpbpW9UyRAwvLeec5emAPixgq9ta07Dgnp2aq5eJbnfd%2fU3qhn54M29Xh6W5vv%2bdt2dNQDKfQW%2bFC5UvSpL5UYaXzgHxlNh%2bD2c8qzpWNe9vEisTCr9D1NeRPP1UDS15VwmQaxsgeawLoIz99EUK1%2fB%2b%2bYXY1N%2bQ7HDAMbXxBMdZztOWCvw80r%2fX4P0ecrtFrzKLjT%2bw%2feZmbJErmFyJt09O6VtT%2bkgFkEV0DDaEpHCSPtG0sWs2kVXdxz%2fXEuZg6PkCWR0Z%2fF2sEj2X%2fNNpGdTVQ2XVmK5ACNC2e0NHD2HWfm7AJVMF7xSTUDPtn0seTjpvhtB3k1WQk65MVsZJIkBiKzhy8Jw%3d"filestore.community.support.microsoft.com")

Answer 1

Hi @Tina M. Pruitt,

I'm afraid it is not possible to change the time to US time zone even using JSON if you don't change the SharePoint site time zone to US. This scenario has been proven impossible by many experts in cases like this.

As a workaround, I suggest your users convert all the times to UTC no matter the user's location using the TimeZoneOffset() if possible.

Reference:

• DateAdd, DateDiff, and TimeZoneOffset functions.
• Troubleshoot date and time issues in Power Apps canvas apps

---

If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.