Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
May 14th | Power Platform Community AMA: Power Apps Edition
News and Announcements icon
Community site session details

Community site session details

Session Id : SaBNS0a7m3WQqAHKFBqneu
Power Platform Community / Forums / Power Automate - Building Flows / Duplicate any sharepoi...
Power Automate - Building Flows
Suggested answer

Duplicate any sharepoint list

Like (1) ShareShare
ReportReport
Posted on 24 Sep 2024 13:51:18 by RA-24091346-0 4
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
  • RA-24091346-0 Profile Picture
    RA-24091346-0 4 on 24 Sep 2024 at 16:45:14
    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 Profile Picture
    S-Venkadesh 636 Super User 2025 Season 1 on 24 Sep 2024 at 14:16:38
    Duplicate any sharepoint list
     

    Method 1: Manually Create List and Copy Items

    1. 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
    2. 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:

    For copying items between lists:

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!
May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 97

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans