Clone SharePoint List Item with Power Automate

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”

Create new power automate flow


2 – Define a name for Flow and choose “For a selected item” as “Trigger”

Clone List Item flow


3 – Select the List name where you want to be able to clone an item

Select site and list for flow


4 – Click on “New step” and in the menu that appears, search for “Get item” in the Sharepoint connector

Choose an action for the flow

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.

Get item to clone


6 – Click on “New step” and search for “Create item” in the Sharepoint connector

Create a cloned item

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

Mapping fields


8 – Save and test

Save flow

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

Run Clone List Item flow

2 – On the right side, a permission request will appear to connect to Sharepoint and then to execute the flow

Accept permissions to run 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

Example of cloned item with flow

Example of cloned item

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.

Another example of cloned SharePoint List Item with Power Automate flow

More Info

Want us to help you with your Microsoft 365 projects? Please contact us.