Site directory in SharePoint Online

[kevingeorget]

Hi SharePoint Users,

I have a new tenant created in O365 with more than 50 site collections and growing in SharePoint.

For the new users logging in new, what is the best way to display a site directory they can be redirected to show them the list of site collections available to them based on access/permissions.

I have used this option, but this doesn't display the entire site collections even after updating the search query-

https://blogs.technet.microsoft.com/anneste/2017/06/15/how-to-create-a-site-directory-for-sharepoint...

Another option is to make use of the below site page-

/_layouts/15/sharepoint.aspx

but this just shows our favorites marked sites and recent sites.

Any other options?

Regards,

kevingeorget

[#2]

Hi @kevingeorget, you have a possible solution of linking in a URL like this:

https://www.office.com/search/sites?auth=2&home=1

This will give you a list of all sites in your tenancy which your user has access to. This is simply using the search page without providing a keyword query. You could add this URL as a custom tile on your App Launcher so that your users can navigate straight to it (as per my screenshot)

Cheap, cheerful, but should tick at least some of your boxes.

[#3]

Use content search web part to query and show all sites. This will show all sites that a user has access to. You can modify the display template to modify the view, show site details etc.

[#4]

thanks @Vikram V for the reply.

In fact i tried with the search query web part. But i'm unable to filter out the results. There are many personal and blog sites coming up in the results and not all sites getting populated.

Below is the query text i'm using-

(contentclass:”STS_Site” OR contentclass:”STS_Web” site: "https://tenant.sharepoint.com/sites/REU*")
{SearchBoxQuery}

i want site collections starting with REU*

[#5]

thanks @Matt Weston . This is brilliant.

Only thing i wish is if i could filter out some results like

https://www.office.com/search/sites?auth=2&home=1&sites=https://tenant.sharepoint.com/sites/REU

[#6 · Accepted solution]

You can still use KQL in your search query, so for example if I did this:

https://www.office.com/search/sites?auth=2&home=1&q=NOT+Title:Flow

It will give me all of my sites where Flow is not included in the title. The query will however appear in the search box so could be wiped out, it really depends on how important it is that users don't see that site in search.

[#7]

Try the following Query text -

contentclass:STS_Site OR contentclass:STS_Web SPSiteURL:REU

[#8]

Thank you @Matty Vasquez,

This kind of works for me. But i like the solution provided by @Matt Weston more. It suits my requirement better.

Thanks again.

[#9]

On the results page  https://www.office.com/search/sites?auth=2&home=

is it possible in the query string to specify sort ascending or descending on a property such as Title?