Microsoft Lists - How to duplicate a record?

[slocpc]

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.

[#2]

Me, too!

[#3]

@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

[#4]

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

[#5]

@Marcus_Pohl 

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



Best Regards,
Sven

[#6]

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

---

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

[#7]

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.

[#8]

@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? 

[#9]

@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: 

---

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

[#10]

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.

[#11]

@SvenSieverding 
Nope, doesn't work.  Pastes the value in the last column I copied into the first column of the new row.

Have you done this yourself?  

[#12]

@BluePetal 

What is frustrating is that this USED to work or rather, used to work intermittently.

Now it just doesn't work, period.

[#13]

Ugh.
Now it is working -- the telltale sign that you are on the right path will be that the row forms a dashed border when your Ctrl-C has taken hold.