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. Select “New Flow” and Select “Instant Cloud Flow” Select “Manually Trigger Flow” and Add Name “Create-SiteTemplate-Flow” Select 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.

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