Introduction
In this article, we will learn to create multiple copies of a SharePoint site page, rename and update its properties using Power Automate.
Use case: I had a requirement to create multiple pages with similar layout, and properties. I have implemented this requirement using Power Automate and an Excel sheet table for list of page title and page name.
In this demo, we will use the table below and the site page highlighted in the screenshot to create copies of the site pages.
Below are the steps to create a PowerAutomate flow for creating multiple copies of a SharePoint site page,
Step 1
Create a new instant cloud flow with the "For a selected file" trigger.
Step 2
Navigate to Site Pages library settings to find the library ID and configure the flow trigger action.
Click on “Enter custom value” and enter library id.
Step 3
Add "Get file properties" action and configure it using ID value from the previous step.
Step 4
Next, add the "List rows present in a table" action to get a list of page titles and names from the PagesTable of the sheet.
Step 5
Add "Apply to each" action to loop through list of table rows using value from the previous step.
Step 6
Add the "Copy file" action and configure as per below screenshot to create copy of the selected site page. You need to use Identifier property of the source page.
Step 7
Add the "Get file properties" action to get newly created site page in last step.
Step 8
Add the "Send an HTTP request to SharePoint" action to update page title and page name for current table row. Provide request body properties to update, we have used "FileLeafRef" property to rename SharePoint site page.
Step 9
Select a page and run the flow to create copies of the selected SharePoint page.
Output
Flow created 5 copies of the selected page(DemoPage) and renamed and updated the title in accordance with the Excel sheet table.
Conclusion
In this article, we learned to create multiple copies of a SharePoint page and rename it using SharePoint API request in Power Automate. You must use SharePoint API call to rename SharePoint page with 'FileLeafRef' property.
Thank you for reading.