Duplicate any sharepoint list

(1) Share

Report

Posted on by RA-24091346-0

How can I save as a list in SharePoint so that the list is fully transferred with the data that is there? I wanted to build a flow that imports data from a specified list. I know how to manually copy data from one list to another by flow, but to make it easier to use, I would like to build a flow that, after starting, asks which list to import data from and to which to put date. The problem I have is that I wanna duplicate excistind list, in this list I got a lookup column, so I can't do it using Excel.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

S-Venkadesh 927 Moderator on at

Like (1)

Report
Hi RA-24091346-0,

Method 1: Manually Create List and Copy Items

Create a New List from the Existing List Manually. https://support.microsoft.com/en-us/office/create-a-new-list-based-on-the-columns-in-another-list-49666e8c-8c48-414f-8e5e-dc0e232acd27

Copy Items from the Source List to the Target List using Power Automate. Copy items between two SharePoint lists via Flow

Method 2: Automate List Creation and Data Copying

If you'd like to automate both the creation of a new list and the copying of data, you can build a flow in Power Automate by referring to the following articles:

Create a new SharePoint list from an existing one using Power Automate

Provision a SharePoint Online list using another list as a template

For copying items between lists:

Copy items between two SharePoint lists via Flow

I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No
RA-24091346-0 4 on at

Like (0)

Report

Thank you very much for your answer. However, I have a question: how to do the flow will give the user posibility to dynamically selects the names of the lists? What I mean is that the flow works in such a way that the user does have to know how to use Power Automate, but dynamically has the ability to indicate the lists from which the data is copy and to which it is copied.

Was this reply helpful? Yes No