Check all SharePoint sites collections with App Catalog active

If you have SharePoint custom solutions, you can have then installed globally, on your Tenant App Catalog or on the site collection – Site App Catalog. Each time that you create the Site App Catalog, you will see that on the site collection but if you do this process for multiple sites, you may forget each one has that feature active. So today, we’ll use a PowerShell Command to extract this information and also provide the URL that you can access to verify the information on this hidden list.

tenant.sharepoint.com/sites/AppCatalogUrl/Lists/SiteCollectionAppCatalogs/AllItems.aspx

If you intend to have a PNP PowerShell report of this list, you can run the below code, you just need to correct the $loginUrl your own domain.

$loginUrl = "https://contoso.sharepoint.com/"
Connect-PnPOnline -Url $loginUrl -UseWebLogin
$appCatalog = Get-PnPTenantAppCatalogUrl
Connect-PnPOnline -Url $appCatalog -UseWebLogin

$items = Get-PnPListItem -List "Site Collection App Catalogs"
$count = 1
foreach($item in $items){
	Write-host $count "-" $item.FieldValues.Item("SiteCollectionUrl")
	$count = $count + 1 
}

Conclusion

With this, we can then identify which solutions are deployed on our SharePoint Online. You can then get a full report if you wish will a few enhancements on the PowerShell. If you intend to know how you can create a site App Catalog visit the following link.