Duplicate any sharepoint list

Like (1) Share

Report

Posted on 24 Sep 2024 13:51:18 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:

Business Process Flows

All responses (2)

Answers (0)

RA-24091346-0 4 on 24 Sep 2024 at 16:45:14

Like (0)

Report

Duplicate any sharepoint list

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.
Suggested answer

S-Venkadesh 636 Super User 2025 Season 1 on 24 Sep 2024 at 14:16:38

Like (1)

Report
Duplicate any sharepoint list

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