Unanswered

Update SharePoint Site Settings with Power Automate

(1) Share

Report

Posted on by JennC

I'm new to Power Automate but I'm wondering if it's possible to build a flow to update the the following SharePoint site settings:

Site settings > Regional Settings > Time zone = (UTC + 10:00) Canberra, Melbourne, Sydney

Site settings > Regional Settings > Locale = English (Australia)

Site settings > Site Features > SharePoint Viewers = Active

Site collection features > Document ID Service = Active

I'm hoping maybe this can be done using the action 'Send an HTTP request to SharePoint' and someone might have a screenshot of how to go about building this flow? Thanks!

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

Expiscornovus 33,502 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @JennC,

As far as I can see you can collect the settings via the regionalSettings, but not update it. The documentation does mention a POST method, but it doesn't seem to work. It should be possible via CSOM or PowerShell, though.

Also in other threads people mentioned the same thing:

https://powerusers.microsoft.com/t5/Building-Flows/How-to-set-TimeZone-settings-for-a-SiteCollection/td-p/440219

I will have a look at the feature part of your question as well.

Was this reply helpful? Yes No
JennC on at

Like (0)

Report
Copy link

Link copied!
@Expiscornovus Thanks for the reply!

I've done a bit of reading (I'm lucky to understand about 50% of what I read on this topic) and I wondered, is it easier to provision a new modern Teams SharePoint site (group connected) using Power Automate and apply the desired settings at point of creation instead of trying to do it after?

I saw the Locale identifier (Lcid) included in the body of a Send an HTTP request to SharePoint action issuing a POST request to the URI _api/SPSiteManager/create

Create Modern SharePoint Sites using REST | Microsoft Docs
Power Automate: Automate the Provisioning of SharePoint Sites - TechNet Articles - United States (English) - TechNet Wiki (microsoft.com)
[Tutorial & Example] Create a SharePoint site using REST API (newbietechie.com) see Alternate method - Site Collection (at the bottom of the page)

The ultimate end goal would be a flow that can do all of the below (but I was initially just trying to focus on the later half which includes the Site Settings as opposed to the settings that are included in the SP Admin Centre):

Create a site > Team site (group connected)
Name
URL
Owner
Sharing > Only people in your organisation = Off
Manage additional admins (Site Collection Admin) > nominated M365 group
Hub > Associate with a hub > nominated hub site
Site settings > Regional Settings > Time zone = (UTC + 10:00) Canberra, Melbourne, Sydney
Site settings > Regional Settings > Locale = English (Australia)
Site settings > Site Features > SharePoint Viewers = Active
Site collection features > Document ID Service = Active

Was this reply helpful? Yes No
Expiscornovus 33,502 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @JennC,

Setting the Locale might work. I just tested it with Dutch (1043). That seems to work. Haven't been able to use English (Australia) though, that is 3081, correct?

Was this reply helpful? Yes No
JennC on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus sorry for the late reply, I didn't check my work emails over the weekend. Yup, 3081 is the locale according to Microsoft Locale ID Values | Microsoft Learn.

Is that flow creating a Communications site? Can it be modified to create a group-connected Teams site? Does the owner have to be an individual name or would a M365 group work?

Was this reply helpful? Yes No
Expiscornovus 33,502 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @JennC,

That SPSiteManager is for Communication sites and Non-group associated Team Sites. If you want to create a group-connected teams site you can use the Graph API:

https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/modern-experience-customizations-provisioning-sites#provision-a-modern-team-site-programmatically-via-sharepoint-online-rest-api

However, I have not seen that you are able to set the language of that when creating the object.

Maybe the best approach is to create a site design include a site script for regional settings and apply that design afterwards:

https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-json-schema#configure-regional-settings

Was this reply helpful? Yes No
JennC on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus does creating site designs/site scripts require Power Shell or can this be done exclusively with Power Automate?

Was this reply helpful? Yes No
Expiscornovus 33,502 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @JennC,

You can use the one you would prefer, they are both supported:

https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-overview#using-powershell-or-rest-to-work-with-site-templates-and-site-scripts

Was this reply helpful? Yes No