I was trying to copy the specific records in a list from one site and want to create a new list in another site with selected records.
Hi Sudhakar,
You don’t have an OOTB way to do this. Best way is to create the new list and move items using power shell or csom by filtering the data you need. The dirty way is to move the list as a whole using template(again you need to see the template size restrictions here) & delete the unwanted items in new list. You could also try using tools like ShareGate (trial should suffice you)
To copy the required record from one site to another is not so difficult you have to just use an app called Apple iPad Support through which you can copy any data from one to another site.
Hi Sudhakar,
If you are having a lookup field, for it to work fine, you need to maintain the list IDs intact in source and destination. Does your site 2 has the master list (where your list looks up to) with the same list ID?
Sudhakar,
when you say first 1500 records, do you mean the you know the id’s would be 1-1500?  If yes you can run a powershell to bulk delete items. Refer below link for bulk deleting items https://www.mavention.nl/blogs/delete-items-batch-sharepoint-list-powershell-script/
HI Chanakya,
I have copied all the items in the list from site1 to site2 list. In a site1 list, I have lookup fields with some data. After completing of copying to a site2 list, there was a missing data of lookup fields. There is no data in the lookup fields, its empty. How do I overcome this missing data in lookup fields in a site2 list?
Hi, sudhakar,Â
Is it a one-time copy operation or copying items on a regular basis? Also, are you copying on another site in the same SharePoint farm or server version?Â
Hi Fred,
Its one time copy and I want to copy to another site in same Sharepoint.
Not going to be easy due to the following: 1) selective items 2) copying into another site.
You can use the PowerShell script to remove the items as suggested after you’ve copied the entire list into the new site, or copy specific items first via workflow into the same site before re-creating the list to the other site.
Hi Chanakya,
Thank you for your response,
For Example, I had 2000 records in my site1 list and I copied all to the site2 list using the template. Now I required only last 500 records in my site2 list, Is there any way to delete first 1500 records from a site2 list at a time?
Thanks,
Sudhakar