Hi there, I have SharePoint 2013 on prem and am struggling with a way to do a list lookup across site collections.
Has anyone been able to successfully do this? We are open to a 3rd party tool, but would prefer to do this ourselves.
Thanks!
Why don’t you try using Managed Metadata for the List Items to Lookup on. Take the current lookup list, export it to a .csv file, remove the unwanted columns and import it into the Managed Metadata TermStore.
Then create a site column in each of the 6 Site Collections that point to the Termset. In your document library, add the site column to it.
Would that work?
