logo
search
Permission & Access Issues

How to Show All SharePoint Hub Sites and Manage Site Retention

Huma Ashraf ChHuma Ashraf Ch Oct 10, 2026 869 views

Question details

The user needs to display all SharePoint hub-associated project sites, including those viewers do not have permission to access, and wants to understand how to automatically close or delete sites using retention policies.

How to Show All SharePoint Hub Sites and Manage Site Retention
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Managing project status visibility and lifecycle policies for SharePoint hub sites.
Observed behavior
The default Sites web part hides hub-associated sites if the viewer lacks permission. Additionally, Microsoft Purview retention policies delete content but do not automatically close or delete the entire SharePoint site.
Before you start

Ensure you have SharePoint Administrator privileges to configure site policies, and verify that the Site Closure and Site Policy features are enabled in your tenant's site collection settings.

Solution 1Recommended

Use a SharePoint List or Quick Links for a Complete Site Directory

Since the default Sites web part is security-trimmed (hiding sites without access), creating a centralized directory using a List or Quick Links ensures all project sites remain visible.

SharePoint automatically limits visibility based on individual user permissions. To present a unified directory of active and closed projects, a manual or custom approach is necessary.

1
Create a Central Project List

Navigate to your main SharePoint Hub site, click on 'New' in the top menu, and select 'List' to create a centralized project directory.

2
Add Tracking Metadata

Add custom metadata columns to your list, such as 'Project Status' (Active/Closed), 'Site Link', and 'Project Manager', to accurately track both active and closed projects.

3
Configure Quick Links Web Part

Alternatively, edit your hub site homepage, add a 'Quick Links' web part, and manually paste the URLs of all associated sites you want displayed.

4
Publish the Directory

Click 'Republish' on the page. All users can now see the complete directory of project sites, bypassing the default security-trimming limitation.

Use a SharePoint List or Quick Links for a Complete Site Directory
Security Trimming Limits: The default Sites web part automatically hides sites based on user permissions. A manual list, Quick Links, or a custom SPFx web part is strictly required to bypass this behavior.
Free Microsoft Office alternative

Manage Your Project Documents Seamlessly with WPS Office

While SharePoint handles site hosting and complex tenant access, WPS Office is an excellent lightweight alternative for creating, editing, and collaborating on the actual project documents. It offers a familiar interface and high compatibility with standard document formats, making project management easier and more cost-effective.

Highly compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight installation with a user-friendly, familiar interface.Free core features for robust document creation and team collaboration.Seamless file sharing and easy integration across desktop and mobile devices.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I see all associated sites in the SharePoint Sites web part?

The SharePoint Sites web part uses 'security trimming.' This means it only displays sites to which you have been granted owner, member, or visitor permissions. It automatically hides any sites you lack permissions to view.

Do SharePoint retention policies automatically delete the entire site?

No, Microsoft Purview retention policies only retain or delete the content (files, list items) within the site. To delete the site container itself, you must configure a Site Closure and Deletion policy.

Why am I missing the Site Policies option in SharePoint Site Settings?

The 'Site Policies' link only appears if the 'Site Closure and Deletion' feature is activated at the site collection level. You may need a tenant administrator to enable this feature in Site Collection Administration.