SharePoint Online: How to show all sites a user has access to?

Requirement: Display a list of all SharePoint Online sites a user has access to.

How do I view all sites I have access to in SharePoint Online?

In SharePoint Online, you may have noticed that there’s no easy way to view all the sites you have access to. Although the SharePoint start page (https://YourDomain.sharepoint.com/_layouts/15/sharepoint.aspx) displays Frequent, Recent, and following sites, It may not give the complete list of all sites you have access. So, it may not be easier to get the site unless the user remembers the URL or bookmark it.

how to show all sites you have access to in sharepoint online

So, How to view all SharePoint Online sites I have access to? Well, there is a workaround!

Option #1: Use Search to List All the Sites You Have Access

Here is how to use the SharePoint search to get a list of all sites you have access to:

  1. Login to https://www.office.com >> In the App Launcher, click on “SharePoint” to get the SharePoint Online start page.
  2. On the search box, type “contentclass:STS_Site” and hit enter.
  3. Click on the “Sites” tab, and this will show all sites you have access to. sharepoint online view all sites i have access to

If you want to include subsites as well, use search query: contentclass:STS_Site OR contentclass:STS_Web

Add this link to “Featured Links” in SharePoint Home page: https://YourDomain.sharepoint.com/_layouts/15/sharepoint.aspx?q=contentclass%3ASTS_Site&v=%2Fsearch%2Fsites

Option #2: Create a Page to Show All Sites User has Access

Let’s create a page that shows all sites a user has access to. You can also use the Search results web part to achieve this functionality.

  1. Go to your SharePoint Site >> Create a new page >> Add a “Highlighted Content web part” web part to it.
  2. Set the Highlighted Content web part properties as below:
  3. Content: Source – All Sites, Type – Pages, Filter and sort: Content includes the words – STS_Sitesharepoint online list all sites a user has access to
  4. Set the Layout as “List” and Number of items to 100.sharepoint online get all sites user has access to

Save and publish the page. This page shows all sites a user has access to in SharePoint Online.

sharepoint online show all sites i have access to

Both methods use search to get all sites you have access to. The security trimming will be applied, and you’ll get sites only you have access.

Salaudeen Rajack

Salaudeen Rajack - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

One thought on “SharePoint Online: How to show all sites a user has access to?

  • Hi Salaudeen, thanks for sharing such great content. I follow your posts since a long time ago.
    Question, is it possible to do this from PowerShell or some API Call?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *