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!
I can export it to a .csv file and import what is needed!!!
Using managed metadata was abandoned because I was only considering manually entering the data. Importing makes this possible.
Thank you! I knew the SharePoint Community would think of everything I didn’t.
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?
I would recommend using search for this. The Content Search Web Part would allow you to aggregate documents from those site collections. Either managed metadata columns or using the content type hub would provide the option for sharing metadata across those site collections to allow search to be refined.
Thank you for your response. I have a list that has more than 1000 processes that sits on a site collection, but that actual process documents will live across 6 site collections. I want to use a list lookup column to be able to input one metadata field from that list and then pull a few other fields into the metadata. This will help keep the metadata fields that need filled out by a process owner to a minimum and also ensure I can maintain control over the process info across the site collections.
I’ve thought about managed metadata, but it would be a lot of data to manually enter in the ECH.
Ess
Could you elaborate on what you mean by “list lookup?” Search and managed metadata are able to be utilized across site collections, but they don’t provide a lookup column experience if that’s what you’re after. For that, you would need to develop something custom. I am unsure what 3rd party tools exist for something like this. Maybe others have advice on those.
