SOLVED

Lookup List from Hub

%3CLINGO-SUB%20id%3D%22lingo-sub-1197886%22%20slang%3D%22en-US%22%3ELookup%20List%20from%20Hub%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1197886%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIs%20it%20possible%20to%20have%20a%20list%20that%20can%20be%20looked%20up%20from%20different%20sites%20associated%20with%20that%20Hub%3F%20I%20have%20an%20approvers%20list%20which%20is%20just%20an%20email%20address%20and%20password.%20I'd%20like%20all%20the%20sites%20associated%20with%20that%20Hub%20to%20be%20able%20to%20lookup%20that%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20I%20can%20it%20with%20metadata%20but%20if%20I%20enter%20an%20email%20address%20like%20%3CA%20href%3D%22mailto%3Ajoe.bloggs%40company.com%2C%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ejoe.bloggs%40company.com%2C%3C%2FA%3E%26nbsp%3Bit%20will%20return%20something%20like%26nbsp%3B%3CA%20href%3D%22mailto%3Ajoe.bloggs%40company.com%2C%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ejoe.bloggs%40company.com%3C%2FA%3E%7CGUID-0011-0111%20or%20similar%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1197886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1201380%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20List%20from%20Hub%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1201380%22%20slang%3D%22en-US%22%3EYou%20can't%20link%20across%20site%20collections%20for%20lookups.%20%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20could%20do%20something%20with%20a%20PowerApp%20form%20as%20it%20can%20have%20data%20sources%20in%20different%20sites%2C%20or%20custom%20code.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497570%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20List%20from%20Hub%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497570%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20new%20methods%20seem%20somewhat%20counter-productive.%26nbsp%3B%20Our%20SharePoint%20support%20team%20have%20migrated%20on-prem%20sites%20to%20online%2C%20like%20for%20like%2C%20mirroring%20the%20existing%20sub-site%20structures.%26nbsp%3B%20So%20now%20working%20units%20have%20a%20Team%20(with%20a%20SharePoint%20site)%20and%20a%20Teams%20classic%20SharePoint%20site.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EWe're%20trying%20to%20suggest%20%22hey..%20just%20use%20your%20Teams%20for%20SP%2C%20you%20don't%20need%20an%20SPO%20site%20as%20well%2C%22%20but%20issues%20like%20cross%20site%20lookups%20create%20road%20blocks%20for%20adoption.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EPreviously%2C%20the%20lists%20could%20be%20displayed%20for%20the%20width%20of%20the%20page.%26nbsp%3B%20Is%20the%20only%20suggestion%20to%20create%20a%20powerapp%20which%20cross%20references%20two%20sources%2C%20to%20insert%20into%20a%20page%20and%20display%20the%20required%20information%3F%26nbsp%3B%20I%20can%20see%20people%20shrinking%20back%20from%20doing%20this%20and%20reverting%20to%20classic%20SharePoint%20with%20sub-sites.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Regular Contributor

Hi all,


Is it possible to have a list that can be looked up from different sites associated with that Hub? I have an approvers list which is just an email address and password. I'd like all the sites associated with that Hub to be able to lookup that list?

 

I think I can it with metadata but if I enter an email address like joe.bloggs@company.com, it will return something like joe.bloggs@company.com|GUID-0011-0111 or similar? 

 

2 Replies
Highlighted
Best Response confirmed by David Gorman (Regular Contributor)
Solution
You can't link across site collections for lookups.

You could do something with a PowerApp form as it can have data sources in different sites, or custom code.
Highlighted

The new methods seem somewhat counter-productive.  Our SharePoint support team have migrated on-prem sites to online, like for like, mirroring the existing sub-site structures.  So now working units have a Team (with a SharePoint site) and a Teams classic SharePoint site. 

We're trying to suggest "hey.. just use your Teams for SP, you don't need an SPO site as well," but issues like cross site lookups create road blocks for adoption.  


Previously, the lists could be displayed for the width of the page.  Is the only suggestion to create a powerapp which cross references two sources, to insert into a page and display the required information?  I can see people shrinking back from doing this and reverting to classic SharePoint with sub-sites.