Microsoft Lists - How to duplicate a record?

Copper Contributor

Hi, all. I'd like to duplicate a record (or row) in Microsoft Lists. Is there a way to do this? Thanks for any help provided.

9 Replies

@slocpc 

If you have a view with all fields then you can

 

  • edit the date in grid view
  • mark the whole row you want to copy
  • press CTRL-C
  • Click on "Add a new Item"
  • press CTRL-V
  • exit grid view

Best Regards,
Sven

@SvenSieverding This doesn't work, it just pastes all the content into the first field.

@Marcus_Pohl 

You need to select the whole row, including the field with the selection circle to paste the data into

copypaste.png

Best Regards,
Sven

@Marcus_Pohl It is possible using edit in grid view. Follow these steps: 

ganeshsanap_0-1677830912465.gif


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Hi Sven - your original written instructions say to do another step "Click on "Add a new Item"" which is what was making your solution not work.

@Marcus_Pohl

Hi Marcus I need to do the same think however I dont appear to have the 'add new item' option , if you press the Green bow new item it opens up the form, any ideas how to add the option link as highlighted please? 

jaynefrancesjtpk_0-1689173493868.png

 

@jaynefrancesjtpk "Add new item" link is not available in normal list view. It is visible in Grid view (quick edit view) only.

 

You can switch to grid view using Edit in grid view option at the top of list: 

ganeshsanap_0-1689244712953.png


Please consider giving a Like if my post helped you in any way.

You can do this with a simple flow in Power Automate and a JSON-formatted button to trigger the flow. You'd need get item then create item actions.