Forum Discussion
slocpc
Sep 16, 2021Copper Contributor
Microsoft Lists - How to duplicate a record?
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.
- ewen1Copper Contributor
This is NOT a fix, it's NOT a solution however it is a kludge* so I could copy and paste extensive rows
1. Open MS-Access
2. Connect to the list (External Data/New Data Source/From Online Services/SharePoint List...)
3. Open the linked table and copy and paste to your hearts content
4. Refresh the SharePoint List and the new record(s) are there
5. Wonder why this isn't available natively in SharePoint Lists and go for a well earned coffee.
* an ill-assorted collection of parts assembled to fulfill a particular purpose. - Rob_ElliottBronze ContributorYou 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.
- SvenSieverdingBronze Contributor
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- BluePetalCopper Contributor
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? - Marcus_PohlCopper Contributor
SvenSieverding This doesn't work, it just pastes all the content into the first field.
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
- jaknudsenBrass ContributorMe, too!