Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Copy Multiple Rows in a SharePoint List

I'd like to duplicate a series of rows that are in a Sharepoint Task list.  Each row is one of about 50 different tasks that make up a  template of tasks that need to be done for each project.  


I can copy them from a separate list OR just replicate from within the task list – it makes no difference to me. I’d kick this off with a button probably. 


I can't seem to find instructions on how best to copy a large number of rows in order to create new rows -- can someone point me in the right direction to some already existing instructions.


Maybe even clues to the right terminology might help me out with my searches. 


Thanks so much! 


Community Support Team
Community Support Team

Re: Copy Multiple Rows in a SharePoint List

Hi @CindyZ,


Are you using the SharePoint default Tasks list?


Do you want to copy all the items in a list to another list?


For your scenario, please try to use the SharePoint - Get items action. Once the button is clicked, items in list A will be got, then save these items in list B.


Note: When using the default Tasks list, please enter the correct list name manually in the List name field.


Please take the following screenshot for a reference.



Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Copy Multiple Rows in a SharePoint List

Thanks so much for your time and advice.  I'll look forward to letting you know how it works!  

Helpful resources


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,496)