Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Update SharePoint Site Settings with Power Automate

(1) ShareShare
ReportReport
Posted on by
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!

  • Expiscornovus Profile Picture
    Expiscornovus 31,139 on at
    Re: Update SharePoint Site Settings with Power Automate

    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

  • JennC Profile Picture
    JennC on at
    Re: Update SharePoint Site Settings with Power Automate

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

  • Expiscornovus Profile Picture
    Expiscornovus 31,139 on at
    Re: Update SharePoint Site Settings with Power Automate

    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

     

  • JennC Profile Picture
    JennC on at
    Re: Update SharePoint Site Settings with Power Automate

    @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?

  • Expiscornovus Profile Picture
    Expiscornovus 31,139 on at
    Re: Update SharePoint Site Settings with Power Automate

    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?

     

    lcid_createsite.png

  • JennC Profile Picture
    JennC on at
    Re: Update SharePoint Site Settings with Power Automate

    @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

     

    1. Create Modern SharePoint Sites using REST | Microsoft Docs
    2. Power Automate: Automate the Provisioning of SharePoint Sites - TechNet Articles - United States (English) - TechNet Wiki (microsoft.com)
    3. [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
  • Expiscornovus Profile Picture
    Expiscornovus 31,139 on at
    Re: Update SharePoint Site Settings with Power Automate

    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.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard