Forum Discussion

wadooda's avatar
wadooda
Copper Contributor
Jun 06, 2023

Transfer data from a List to another List on a seperate Sharepoint site

Hi, I am trying to transfer data from a List in an old Sharepoint site to a new List in modern site. I have used the in-built create from existing list2 functionality in new site it just creates the column names and data types but i also want to transfer the Items inside the lists.

To transfer the items to the list, I have created this flow but I do not know why it does not transfer all of the items it just transfer 50% of the items. I have got more than 100 items in previous list.

Can someone please help me with this or may be suggest some other way to transfer data including attachments and lookup columns.

Thanks!

2016
admin
App
developer
Document Library
Lists
microsoft lists
mobile
Permissions
Responsive

1 Reply

  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor
    Jun 06, 2023

    Hi wadooda 

    try to expand the "Get Items" action and set the "Top Count" property to 9999.

    Best Regards,
    Sven

    PS: You can easily copy a list including content using PnP Powershell

    # Connect to source site
Connect-PnPOnline https://yourtenant.sharepoint.com/sites/yoursite -UseWebLogin
Get-PnPSiteTemplate -ListsToExtract <Listname> -Handlers Lists export.xml
Add-PnPDataRowsToSiteTemplate -List <Listname> -Path .\export.xml

# Connect to target site
Connect-PnPOnline https://yourtenant.sharepoint.com/sites/yourothersite -UseWebLogin
Invoke-PnPSiteTemplate .\export.xml




Resources