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?