Update LocaleId and TimeZone with PnP

If you get an error while trying to update Regional Settings on your SharePoint Online Site, then PowerShell combination of PnP and CSOM are to the rescue.

The issue I got was that indexed columns were there. You can try to remove indexed columns and re-add them. But it is not the best solution. In my scenario, it was an indexed column that I couldn’t remove.

The reason why I use a combination of PnP and CSOM (Load, Update, ExecuteQuery), is that I have not found a way of updating RegionalSettings in PnP.

P.S.: When I was done with this update, I found a blog post that changing Sort Order to General could solve the issue. So the issue is not the locale, but the Sort Order.

comments from wordpress

Michal — 2019-12-03

Hi there, this SAVED my life after hours of searching for usable solution. Only PnP powershell with CSOM was able to change LocaleID of my existing sharepoint site for correct formula language in Excel online files. :) Thanks very much.

---

Michal — 2019-12-03

Hi there, this SAVED my life after hours of searching for usable solution. Only PnP powershell with CSOM was able to change LocaleID of my existing sharepoint site for correct formula language in Excel online files. :) Thanks very much.

• Uncategorized