Connecting a lookup to a list on another sharepoint site

%3CLINGO-SUB%20id%3D%22lingo-sub-2165588%22%20slang%3D%22en-US%22%3EConnecting%20a%20lookup%20to%20a%20list%20on%20another%20sharepoint%20site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2165588%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20trying%20to%20get%20around%20the%20problem%20of%20having%20lists%20in%20different%20Sharepoint%20Online%20sites%20which%20have%20the%20same%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20was%20wondering%2C%20is%20it%20possible%20to%20create%20a%20list%20which%20has%20a%20lookup%20column%20which%20connects%20to%20another%20SharePoint%20list%20in%20a%20different%20Sharepoint%20site%20but%20still%20under%20the%20same%20tenant%3F%20I%20can%20only%20see%20a%20way%20of%20doing%20this%20with%20lists%20in%20the%20same%20SharePoint%20site.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20we%20have%20a%20HR%20site%20and%20and%20IT%20site%20and%20would%20like%20to%20create%20a%20list%20in%20one%20site%20which%20has%20a%20lookup%20column%20which%20points%20to%20a%20list%20in%20the%20other%20site.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2165588%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
Occasional Visitor

We are trying to get around the problem of having lists in different Sharepoint Online sites which have the same information.

 

So I was wondering, is it possible to create a list which has a lookup column which connects to another SharePoint list in a different Sharepoint site but still under the same tenant? I can only see a way of doing this with lists in the same SharePoint site.

 

For example, we have a HR site and and IT site and would like to create a list in one site which has a lookup column which points to a list in the other site.

0 Replies