SharePoint REST API call for Archive Site

Power Automate sends an HTTP request to an Azure Function.

Part 2:

Option 2: Use Microsoft 365 CLI with Power Automate

The Microsoft 365 CLI provides commands to manage SharePoint sites. You can use it to lock a site and integrate it with Power Automate.

Steps :

1. Install Microsoft 365 CLI : Install the CLI on your local machine or server where the script will run.

npm install -g @pnp/cli-microsoft365

1. CLI Command to Archive Site : Use the following command to set the site to read-only mode:

m365 spo site set --url https://.sharepoint.com/sites/ --lockstate ReadOnly

1. Integrate with Power Automate :

• Similar to Option 1, host the CLI command in an Azure Function or Runbook.
• Trigger the function via an HTTP request from Power Automate.

Option 3: Use Microsoft Graph API (Indirectly)

While Microsoft Graph API does not have a direct endpoint to archive a site, you can use it to retrieve site details and then combine it with PowerShell or CLI scripts.

1. Retrieve Site ID : Use the Microsoft Graph API to get the site ID:

GET https://graph.microsoft.com/v1.0/sites/.sharepoint.com:/sites/

1. Pass Site ID to Script : Pass the retrieved site ID to your PowerShell or CLI script to perform the archiving operation.

To archive a SharePoint site using the SharePoint REST API or Microsoft Graph API, you need to use the appropriate endpoint and permissions.

Solution Approach

Option 1: Use PowerShell with Power Automate

You can use PowerShell to archive a SharePoint site and trigger the script from Power Automate using an Azure Function or an HTTP-triggered automation.

Steps :

# Connect to SharePoint Online
Connect-SPOService -Url https://-admin.sharepoint.com

# Archive the site
Set-SPOSite -Identity https://.sharepoint.com/sites/ -LockState ReadOnly

• Replace with your tenant name.
• Replace with the name of the site you want to archive.
• The -LockState ReadOnly parameter makes the site read-only, effectively archiving it.

1. Integrate with Power Automate :

   • Host the PowerShell script in an Azure Function or an Azure Automation Runbook.
   • Create an HTTP-triggered function to execute the script.
   • Use the "HTTP" action in Power Automate to call the Azure Function.