Cross site lookup (of list) within tenant

Site Columns and Content Types: You can create site columns at the site collection level and use these columns in content types. Content types can then be associated with lists or libraries across different sites within the same site collection. To create site columns, follow these steps:
- Go to the root of your site collection.
- Click on "Settings" (gear icon) > "Site settings."
- Under "Web Designer Galleries," click on "Site columns."
- Create the site columns that you want to use for cross-site lookups.
- After creating the site columns, you can associate them with content types and then use these content types in lists or libraries across different sites.
Managed Metadata Service: SharePoint Online's Managed Metadata Service allows you to create a centralized taxonomy and term store that can be used across sites. You can use managed metadata columns in your lists and libraries to create cross-site lookups.
- Create a term set with the terms you need in the term store.
- Add managed metadata columns to your lists and libraries.
- Allow users to select terms from the centralized term set, providing consistency and a shared lookup experience.
Lookup Fields with SharePoint Designer: You can create lookup fields in SharePoint Designer that reference lists or libraries in other sites. However, SharePoint Designer is being phased out, so this may not be a long-term solution.
Power Apps and Power Automate: Microsoft Power Apps and Power Automate (formerly Flow) provide robust solutions for creating cross-site lookups. You can build custom forms and automate processes that involve data from various sites.
Third-Party Solutions: Consider third-party solutions or apps available in the SharePoint App Store that provide enhanced cross-site lookup functionality.

When implementing cross-site lookups, it's important to consider security and permissions. Ensure that users have the appropriate permissions to access the data from different sites.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Tahir Ansari2y ago
1. Site Columns and Content Types: You can create site columns at the site collection level and use these columns in content types. Content types can then be associated with lists or libraries across different sites within the same site collection. To create site columns, follow these steps:
  
  Go to the root of your site collection.
  
  Click on "Settings" (gear icon) > "Site settings."
  
  Under "Web Designer Galleries," click on "Site columns."
  
  Create the site columns that you want to use for cross-site lookups.
  
  After creating the site columns, you can associate them with content types and then use these content types in lists or libraries across different sites.
2. Managed Metadata Service: SharePoint Online's Managed Metadata Service allows you to create a centralized taxonomy and term store that can be used across sites. You can use managed metadata columns in your lists and libraries to create cross-site lookups.
  
  Create a term set with the terms you need in the term store.
  
  Add managed metadata columns to your lists and libraries.
  
  Allow users to select terms from the centralized term set, providing consistency and a shared lookup experience.
3. Lookup Fields with SharePoint Designer: You can create lookup fields in SharePoint Designer that reference lists or libraries in other sites. However, SharePoint Designer is being phased out, so this may not be a long-term solution.
4. Power Apps and Power Automate: Microsoft Power Apps and Power Automate (formerly Flow) provide robust solutions for creating cross-site lookups. You can build custom forms and automate processes that involve data from various sites.
5. Third-Party Solutions: Consider third-party solutions or apps available in the SharePoint App Store that provide enhanced cross-site lookup functionality.
When implementing cross-site lookups, it's important to consider security and permissions. Ensure that users have the appropriate permissions to access the data from different sites.
0