How to get all existing SharePoint site collection app catalogs
I am Sergej and I am a Software Architect from Germany (AURUM GmbH). I have been developing on Microsoft technologies for more than 14 years, especially in SharePoint / Microsoft 365. With this blog, I want to share my knowledge with you and also improve my English skills. The posts are not only about SPFx (SharePoint Framework) but also about tips & tricks around the M365 world & developments of all kinds. The posts are about TypeScript, C#, Node.js, Vue.js, Visual Studio/ VS Code, Quasar, PowerShell, and much more. I hope you will find some interesting posts. I would also be happy if you follow me. Greetings from Germany Sergej / $€®¥09@
The launch of the app catalog at the site collection level was a very good decision and brings a lot of benefits. If you want to deploy an app catalog to a site collection, a tenant app catalog must exist. Then you can deploy a new app catalog to a site collection using the following PowerShell command:
Connect-SPOService -Url https://{tenant}-admin.sharepoint.com -Credential {admin-email-address}
Add-SPOSiteCollectionAppCatalog -Site https://{tenant}.sharepoint.com/{sitecollectionurl}
For an administrator, it is of course very interesting on which sites an app catalog already exists. Without having a specific request, I recently came across an interesting and hidden list that is located in the Tenant App Catalog.
The URL to this hidden list is /Lists/SiteCollectionAppCatalogs/. So e.g. https://{tenant}.sharepoint.com/{tenant-app-catalog-site}/Lists/SiteCollectionAppCatalogs/AllItems.aspx
The problem with this list is that it is not updated. That means deleted sites or sites where the URL has been changed are NOT updated/deleted in the list. Not well thought out by Microsoft.
I hope this information helps you as well.
