Time zone settings in Microsoft sharepoint lists

Occasional Contributor

Hi 

In my SharePoint site i work with several lists where I store basic data were always some date and time columns are used. I checked al the time settings after reading a lot of topics about this topic. All my settings which I found are set to regional time zone but SharePoint keeps using the pacific time zone. It drives me crazy because all data stored in SharePoint are always 9 hours out of sync when I work with the data in PowerApps, Power BI Excel and automate. Really annoying......
Is there a change that we can become a robust time zone settings in SharePoint? Is it on a roadmap?? 
Or do we have solutions which I didn't find until now. 

 

Regards from the Netherlands
Steven

2 Replies

@Steven van der Bles 

I am having similar issue.

Let me knokw if you found the answer to this.

Thank you!

@rdfwt If it's the same problem I have been having, I believe it is due to the GA release of "Microsoft Lists: offline mode". I found that recently some people noticed a list datetime column was reporting the "wrong" date/time. Checking all the regional settings in the list, site, onedrive, office365 and on the local machine all reported the correct timezone but the list just wouldn't render it correctly. I found that clearing the cache and cookies for the browser made it appear correctly the first time you browsed to the list but from then on, the "This list is in sync" tick would appear next to the name and the wrong timezone would be applied. 

 

I haven't found a way to keep the feature enabled and fix the datetime columns so I resulted to disabling Offline Client Availability on the list with the problem, rather than the whole site. Go to List Settings > Advanced Settings and set Offline Client Availability to "No".