Create Site Script and Site Template Using Power Automate in SharePoint

Introduction

Many times, the Site is already created, and we need to apply configuration in the existing site to achieve some level of consistency. How can we achieve it?

To achieve, this kind of implementation, use site template and site scripts to automate provisioning to the existing modern site or create a new site using site templates which is available in your organization tenant.

In the previous version of SharePoint, Site templates were known as site designs.

Site templates are a set of configurations that need to apply on a particular site and Site Scripts are JSON files that include an order list that needs to be executed while we apply it on a Specific SharePoint Site.

Learning Objectives

1. Create JSON file for Site Scripts
2. Create Power automate
3. Create Site Script using REST Call in Power Automate
4. Create Site Template using REST Call in Power Automate
5. Output

Prerequisite

1. M365 environment
2. Power automate access requires a license
3. SharePoint Admin Access
4. Permission
   1. SharePoint Administrator
   2. Site Collection Administrator

Let's get started.

Create JSON file for Site Scripts

You need to create JSON files in specific formats to implement SharePoint artifacts in SharePoint Site.

Available Action includes.

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/site-design-script-actions.schema.json",
  "actions": [
    {
      "verb": "applyTheme",
      "themeName": "Contoso Explorers"
    },
    {
      "verb": "createSPList",
      "listName": "Customer Tracking",
      "templateType": 100,
      "subactions": [
        {
          "verb": "setDescription",
          "description": "List of Customers and Orders"
        }
      ]
    },
    {
        "verb": "setRegionalSettings",
  		"timeZone": 2,
  		"locale": 1050,
        "sortOrder": 0,
  		"hourFormat": "12"
	}
  ],
  "version": 1
}

 

Each action identifies by its "verbName" property and inside auction property, you need to configure the things that you want to apply while creating the site or on an existing site.

 

Create Power automate

Go to https://portal.office.com and click on Power automate.

Click on “New Flow” and Select “Instant Cloud Flow”

Select “Manually Trigger Flow” and Add Name “Create-SiteTemplate-Flow”

Click on Create Button.

 

Create Site Script using REST Call in Power Automate

Initialize variable in power automat to store JSON config.

Select “Send an HTTP request to SharePoint” from the list of actions.

 

Parameters

Site Address - You can select any site Address either it's root or not
Method - post
Url - /_api/Microsoft.SharePoint.Utilities.WebTemplateExtensions.SiteScriptUtility.CreateSiteScript(Title='<Site Script Title Name>')

Headers

 

{
  "Content-Type\n": "application/json;charset=utf-8",
  "accept": "application/json;odata.metadata=minimal",
  "odata-version": "4.0"
}

 

 

Body

@{variables('SiteScript')} // Reference of variable that we Initialized before this action.
Get Create Script ID and store it in Variable

Create Site Template using REST Call in Power Automate

Parameters

Site Address - You can select any site Address either it's root or not
Method - post
Url - /_api/Microsoft.SharePoint.Utilities.WebTemplateExtensions.SiteScriptUtility.CreateSiteDesign

 

Headers

{
  "Content-Type\n": "application/json;charset=utf-8",
  "accept": "application/json;odata.metadata=minimal",
  "odata-version": "4.0"
}

Body

{
    "info": {
        "Title": "<Site Template Title>",
        "Description": "<Site Template Description>",
        "SiteScriptIds": ["@{variables('ScriptID')}"],
        "WebTemplate": "64"
    }
}

The flow looks like as below

Output

Click on the “gear” Icon in SharePoint Site.

Click on “Apply a site template”.

 

Posted at https://sl.advdat.com/3h8VbTv