Duplicate selected SharePoint list item

[LostInTheFlood]

Hi smart people,

I would like to duplicate selected items (entire row(s)) in a SharePoint online list.

I managed to duplicate all entries with "get item" and " create item" but I'd like to only duplicate selected.

Any ideas?

Br

[abm]

Hi @LostInTheFlood 

Open your list in SharePoint. Click Automate > Power Automate > Create Flow

Then create the flow trigger as

Once the flow is created go back to your SharePoint list. Select the item you want to duplicate then click Automate > Power Automate > Select the flow you created earlier.

Thanks

[LostInTheFlood]

Hi

 Thank you @abm . I tried but was not successful in writing back to the list. I tried writing with " create item" but my columns were not to be found in dynamic content. I tried "id" and it wrote back a "1".

I'm a super novice when it comes to this.

Do you have the possibility to explain all steps?

Br

[abm · Accepted solution]

Hi @LostInTheFlood 

After the first step you need the Get item to retrieve all the details from the selected item. Please see below.

[LostInTheFlood]

Awsome, worked like a charm @abm 

[Anonymous]

how do you trigger this workflow ? if apply to sharepoint list, i wanted to select a row and use this to copy, how do i do it?

[LostInTheFlood]

Select the row you want to duplicate and click the arrow where it says "Automate". You should see your flows connected to the list there. 

[Anonymous]

if i have a column which have 2 or more items, it will copy into 2 or more rows, how do i just copy 1 row but have the same number of items in the column?

[abm]

Hi @Anonymous 

Not sure I understood what you meant by. Could you please post this as a new thread? Also explain with some detailed examples.

Thanks

[Anonymous]

Hi, may i know how u grant access to users who are not creator for this workflow as they cant see it from Automate > Power Automate 

.

[JoanaVB]

Hello, Thank you for this solution. It works fine but I was not able to duplicate the fields that where choices or Lookup to other lists with dinamic content from the Get Item action, only options I choose for those fields. Best Regards, Joana

[JoanaVB]

That also happened to you on your "open point w" field. You can choose yes or no but not copy what was on the item you selected to copy.

[BobOxford]

This looks great. The only issue i am running into is that it doesn't seem to recognize a SharePoint "Events list" as a valid list in the site. Is there something else I need to do, or are "Events lists" just not supported?

Thank you!

[Tina_Trupanion]

I was trying to use this exact flow and I can get it to work if I remove a few of my columns, but I want to create a true clone of every column.  I keep getting the below error: 

"The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: The API operation does not allow writing a value for parameter 'item/field_2[0]/Id'. This parameter is read only."

I am not sure what it means.  I've noticed by removing and allowing some columns, the issue is with the "Choice" columns I have set up.  But again, I do want the data from those columns also copied.  Is there a way around this?

[SidrahAshraf]

Hello Joana,

You can do this for choice, person and lookup columns as well. For choice column. Lets suppose you have a choice column named status. What you would do just before create item, initialize variable. S is the name, select string and in value choose status value (colored green). Now in the create item click the status value tab and choose enter custom value then select the variable. Same works for person column. And for lookup just select lookup value id. It will duplicate the exact data. 

[RobElliott]

@Tina_Trupanion it means that you are trying to add an ID to the new item that you want to create. You can't do that as SharePoint always allocates the ID.