Start Power Automate with PnP provision from a site design

Creating a PnP provisioning template

Our plan is to start a Power Automate (Microsoft Flow) from site design and deploy a PnP provisioning template. In the example, we will create a SharePoint Modern page using PnP provision template and to reach the goal we need to prepare the PnP template.

There are 2 ways for creating a PnP template: you can write it manually and specify all the entities, or create the template in PowerShell. Please check out the following articles. We’re using an example from the first one in the list.

• How to create a SharePoint Modern page using PnP provision template .

• How to create a SharePoint list or library using PnP provisioning template .

• How to create a Modern SharePoint Team or Communication site using PnP provisioning template .

Create the PnP file, we’ll need it on the next steps.

Creating a flow

We’ll start our Flow when a specific site design is selected. Site design contains a site script which has a link to the created Power Automate (Microsoft Flow). We can notify the Micrsoft flow that the site design is applied using trigger When an HTTP request is received.

Then add this JSON to the request body

{
  "type": "object",
  "properties": {
      "webUrl": {
          "type": "string"
      },
      "parameters": {
          "type": "object",
          "properties": {
              "event": {
                  "type": "string"
              },
              "product": {
                  "type": "string"
              }
          }
      }
  }
  }

HTTP POST URL will be empty until you save the flow. We’ll need the URL when creating our site script.

Then we’ll use Plumsail and SharePoint actions to retrieve and provision the PnP template.

Adding the Plumsail action for the first time, you’ll be asked for a Connection name and Access Key.

You can type any name for the connection. For example, “Plumsail Actions”. Next create an API key on your Plumsail account page, copy, and paste it to the “Access Key” field.

The actions’ configuration is following:

As you can see we select WebURL value in SharePoint site URL field. It is a dynamic value and provides the newly created site URL. We pass the parameter to Plumsail action so it will know where to apply the PnP template.

On the next steps we need to start the Flow automatically once the site is created.

Creating a site design and site script

Site design is a container which includes one or more site scripts. You can either make the site script manually or use an online costructor. Let’s take this simple site script as an example:

{
  "$schema": "schema.json",
  "actions": [
  {
          "verb": "triggerFlow",
          "url": "https://prod-103.westeurope.logic.azure.com:443/workflows/650287c069f94a1899e124147ec30a3a/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=yyCX8RGjZNT61gvJ8euoGpCrNiRhELR8YULI2ptpBX0",
          "name": "Apply Template",
          "parameters": {
              "event":"",
              "product":""
          }
  }
  ],
  "bindata": {},
  "version": 1
}

the URL parameter I took from When HTTP request is received trigger

After that we need to add the site script to our site design using some PowerShell commands:

• Select the JSON again and copy it.

• Open PowerShell and enter the following commands to copy the script into a variable and create the site script:

$script = Get-Clipboard -Raw
Add-SPOSiteScript -Title "Apply PnP Provisioning Template" -Content $script
Get-SPOSiteScript

• Select the ID of the site script that you created and copy it.

• Use the following command to create the site design:

Add-SPOSiteDesign -Title "Site Design example" -SiteScripts [Paste the ID of the Site Script here] -WebTemplate "64"

You can find the detailed instruction and some other related to the subject things in the oficial Microsoft article.

Starting MS Flow from site design

The last step is when you select the site design it triggers the created flow and deploy the PnP template with modern page.

That is all! Using Site designs and Plumsail action Provision PnP template to sharepoint together significantly expands the possibilities and automates creating unique site structures.