Duplicate a row in Microsoft List

Question

In Microsoft 365 > Teams> Microsoft List, can you duplicate a row that had been previously populated? Just to minimise the work to fill in [+New] reinsert information. I'll like to only do a few tweaks.

Answer 1

Hi M L 80,

Thanks for posting in the community. We are happy to help you.

From your situation, we need to do some tests first and research on our side, we'll appreciate it if you can understand that it will take some time to give you more effective suggestions according to the test results. We will update our reply as soon as possible.

Thanks for your understanding and cooperation.

Sincerely,

Sophia | Microsoft Community Moderator

Answer 2

Dear M L,

Good day!!

I understand your concern and to my knowledge, there is no direct feature in the Microsoft Lists or SharePoint Online to automate the duplication of row but there is one quick process, where you can simply copy the data of the raw and paste it, please follow the below steps:

Go to the List> Edit in grid view> Double-click and drag your mouse to select the data in the row> Add New item> Paste the data> Exit Grid view.

If either it doesn’t work how you are expecting or you are looking only automate process, then I suggest you to give a shot by posting your concern in the Microsoft Power Automate Community - Power Platform Community to get the detailed help from the experts.

Apologies for redirecting you to different community as the members in the category posted focus on the users with the SharePoint Online out of the box concerns and have limited knowledge on the customization of Power Automate flow, so to get the fast and better assistance, we have redirected you in the correct path.

Appreciate your patience and understanding. Have a great day!!

Best Regards,
Sophia

Answer 3

Thanks Sophia for your respond.

I managed to get to "Double-click and drag your mouse to select the data in the row" do I need to copy, is there a step missing before create [+New]? as I create [+New] the form is blank. Also, when I copy, it only paste on the first cell.

No issues at all if there's no solution.

Thanks again

May :)

Answer 4

Dear May,

Thanks for writing back with us and apologies if the steps provided above are not clear. I tried to repro the steps and recorded the video, so you can get the clear shot on the steps performing at my end:

If this doesn’t help, please give a shot by posting your concern in the Power Automate community where the experts will provide the detailed flow that meets your requirement.

Appreciate your patience with us and have a great weekend ahead!!

Best Regards,

Sophia