Forum Discussion
wadooda
Jun 06, 2023Copper Contributor
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!
1 Reply
Sort By
- SvenSieverdingBronze Contributor
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