Jan 12 2022 08:09 AM
Jan 12 2022 08:09 AM
I am fairly new to SharePoint and wanted to create a Dynamic List as an index (for navigation) to all the SharePoint sites (we have about 5000 sites). Is this something SharePoint supports, and if so how do I accomplish this? If there is a better way to accomplish this please let me know. Thank you in advance! Paul
Jan 14 2022 04:55 AM - edited Jan 14 2022 05:06 AMSolution
This is such a common scenario and even in SharePoint Online this is not properly supported.
I am afraid the short answer is no.
As an administrator you can access a list in the SharePoint admin center site named "DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS
Another approach is to use graph api. See link in above mentioned post.
You can also use PowerShell to generate a list with sites. This provides a snapshot of the sites in time and requires special permissions. You can also run the PowerShell script using task manager (e.g., daily) and publish the results to a SharePoint list or page.
Another approach is to execute a search query and only request site collections and site using contentclass STS_Site and STS_Web. The search result list is security trimmed so users will only see sites they have read access to. You need to cater for duplicates and pagination. Plus you need to show the results in a decent way (e.g. indent subsite and show below the actual site collection).
We developed a solution where the challenges were even more complex. On-premise SharePoint, strict performance requirements, stale search index required additional validation checks, complex permission setup resulting in false positives which needed to be detected, need to exclude certain sites, .. It can be done though: see example
Summary: OOTB this is not possible. you will need to invest time/resources to address this.
Paul | SLIM Applications
Jan 14 2022 02:00 PM
Thanks for your detailed response and examples Paul. Clearly, this requirement is more advanced than a normal User can achieve.