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 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.
