Clone a SharePoint List Item with Power Automate
In case you want to update a list in SharePoint Online, in which the item to be inserted only differs, from what is already there, in just one field it would be much more effective if it were possible to copy the existing item and thus create a copy that we can change.
Currently, there is no simple way to duplicate or clone an item in a list using Microsoft SharePoint, so we would have to manually insert all the fields of the item we wanted to change.
In this article we will be able to create a workflow, through Power Automate so that, in just a few steps, it is possible to duplicate items and make the task of updating data and maintaining history, simpler.
1. Access Power Automate and create an “Instant flow”
2 – Define a name for Flow and choose “For a selected item” as “Trigger”
3 – Select the List name where you want to be able to clone an item
4 – Click on “New step” and in the menu that appears, search for “Get item” in the Sharepoint connector
5 – Insert the data from the list where we want to get all the information about an item and place triggerBody()?[‘entity’]?[‘ID’] in the Id field.
6 – Click on “New step” and search for “Create item” in the Sharepoint connector
7 – Insert the data from the list where we want to create the item (in this case it is the same). All content to be inserted comes dynamically from the “Get item” connector
8 – Save and test
After publishing it you will see the Flow in the list, as shown below
To clone an item, simply:
1 – Select the item to copy, click on “Automate”, wait a few seconds, our flow will appear and just click
2 – On the right side, a permission request will appear to connect to Sharepoint and then to execute the flow
When updating the page we can see the item created from the selected one and now we can change the copy with the most recent data
3 – For the identification of the versions, an expression was used that verifies the selected version and creates the next version to be changed and thus be able to have a history of changes.
Want us to help you with your Microsoft 365 projects? Please contact us.