Nov 10 2020 03:11 AM
Nov 10 2020 03:11 AM
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
Aug 03 2021 05:04 PM
I am having similar issue.
Let me knokw if you found the answer to this.
Oct 25 2021 10:16 PM
@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".
Nov 11 2022 04:56 AM
Dec 01 2022 01:49 AM
Dec 01 2022 08:32 AM
@CK6218 you are completely incorrect. The new Microsoft Feedback Portal which replaced UserVoice has been live for a year and is here. All the suggestions from the UserVoice sites were moved across to the new platform.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
May 17 2023 06:52 PM
Oct 28 2023 10:14 PM
I am having the same problem. I am trying to learn how to convert an excel sheet to list to calendar view. The excel file I will eventually be using (which is updated daily) gave me problems when I tried to create a list from it so I decided to start with a very simple excel file to see if I could actually perform this process. That worked fine, except the times in the excel file (I'm in US central) change to US Pacific time when the list is created. Sharepoint regional time is set to US Central. Excel has no date/time format which includes time zone. I'm not worried about people creating events, ultimately I will be copying the excel file from email attachment daily (automating that is a distant dream right now). Not using Power BI or automated workflows or anything.