Show Parent site Custom list in sub sites based on filter list column value

Question

Hi i have SharePoint 2019 Team Site modern on premise

Here i root site collection i have a Employees custom list with ID ,Employee Name, Country columns

Root Site Level1> Level 2 country site> Level 3 cities site

here in level 2 sub sites i want to display employees based on their country value

Example:

Country USA sub site home page only display USA employees

Country India sub site home page only display India employees

for above is there any out of the box way preferable

Answer 1

Hi @adil,

I would like to confirm your question to you, do you want to show the Employees custom list on the home page of the sub site, but the list is filtered to show only the employee information related to the country of the sub site.

Please correct me if I have misunderstood.

If I understand correctly, then unfortunately we can't show the parent site's lists on the sub sites. The reason for this is that the users who have access to the sub site do not necessarily have access to the parent site's lists. SharePoint does not allow the parent site's lists to be displayed in the sub sites for access security reasons.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @adil,

The only way to do this is to copy the Employees custom list from the top-level site into all the sub-sites and filter the copied Employees custom list by country in the sub-sites then display it on the page.

This is the exact step:

1. Save the List as a Template:
   • Go to the Employees custom list.
   • Click on List Settings.
   • Under Permissions and Management, click Save list as template.
   • Provide a name for the template and check the Include Content box if you want to include the list items.
   • Click OK to save the template.
2. Create a New List from the Template:
   • Go to Site Contents in the sub site.
   • Click New > App.
   • Find your created template and create a new list based on it.
3. Verify the List:
   • Ensure that the new list in the target site includes all the content from the original list.
4. Adding country filter to the list of sub-sites. Also create views for the filtered content.
5. Create a List Web part on the page to display the list. Remember to select the view you just created.
6. Verify the result in page:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.