I have copied a list from one site to another site. The list contains lookup fields with data in older site. After completing of a copy of the list from older site to new site, there was a missing data in lookup fields, How to recover this data or how to copy the list along with the lookup fields data?
Hi Sudhakar,
You need to move your master list (where you are looking up to) also but you need to maintain all the list id’s and the column id’s intact for things to work. If you cannot maintain the IDs then you are left out with only two options
- Have the master list created with the data in your destination site. Write a powershell or SSOM code to copy data from source to destination. You need to manually match the look up fields from source and destination and update the lookup column values.
- If you are doing this as an one time activity download ShareGate trial which you can use to do the migration. Trial is free for migration up to 5GB.Â