How do I show a filtered view of a library from Site A on Site B in SharePoint Online?
Hi r/sharepoint,
I'm setting up a SharePoint intranet for a multi-country company. The architecture I want:
- **Site A (Main Site)** = one central Documents library holding ALL files from all countries. Each file is tagged with a Country column (Philippines, Ghana, India, Indonesia, Global)
- **Site B (Country Site)"* = a separate SharePoint site that shows ONLY the country-tagged files from the Main library
**The requirement:**
- One library, one source of truth
- Country site users only see CC=Country files
- Any edit made from the Country site should update the same file in Main instantly (no copies, no sync)
- If a Global file is edited in Main, India users see the update immediately
**What I've tried:**
Document library web part — can't connect to a library on a different site
Updating the nav link to point to the filtered view URL — SharePoint keeps reverting it
Creating a redirect page — works but feels like an extra step
**Questions:**
Is there a native way to embed a cross-site filtered library view on a different site's homepage?
Is there a better architecture for this use case that I'm missing?
We're on Microsoft 365 Business Standard. I have SharePoint Admin access.
Any help appreciated — been going back and forth on this for a while!