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

Tina M. Pruitt 0 Reputation points

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.



A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
8,558 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 12,086 Reputation points Microsoft Vendor

    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.


    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.