Find all Sites with skybow Modern Forms Add-In installed

This article describes how to find all SharePoint Online site collections — and optionally all subsites — in your tenant where the skybow Modern Forms Add-In has been installed.

As your tenant grows over time, it can become difficult to track on which sites the Add-In has been deployed — especially when multiple administrators or project teams are involved. This script gives you a full, auditable inventory of every installation across your tenant, including subsites.

The provided PnP PowerShell script iterates through all site collections and — when the -IncludeSubsites switch is used — all subsites within them. It checks whether skybow Modern Forms PRO is installed, optionally checks for the mFormsStoreLibrary document library (used by the Forms Designer), and exports the results to a timestamped CSV file.

Table of Contents

• Scenario
• Prerequisites
• How the Script Works
• Step-by-Step Guide
• The Complete Script
• Result
• Additional Hints & Special Cases

Scenario

• You are a SharePoint administrator managing a Microsoft 365 tenant.
• The skybow Modern Forms PRO Add-In has been installed on various SharePoint sites and subsites over time by different administrators or project teams.
• You now want to:
• Get a complete overview of all site collections and subsites where the Add-In is currently installed.
• Identify which installed version is running on each site or subsite.
• Optionally detect whether the mFormsStoreLibrary document library (used by the Forms Designer) exists on each web.
• Export the findings to a CSV file for documentation or governance purposes.

Prerequisites

• SharePoint Administrator or Global Administrator rights on your Microsoft 365 tenant.
• PnP PowerShell module installed. Install or update it by running:
  Install-Module PnP.PowerShell -Scope CurrentUser -Force
• A registered Entra ID App Registration (formerly Azure AD) with the required SharePoint permissions, and its Client ID (Application ID) at hand.
• Access to your SharePoint Admin Center URL (e.g. https://contoso-admin.sharepoint.com).
• Sufficient permissions to connect to every site collection and subsite in the tenant (Global Admin or SharePoint Admin recommended).

IMPORTANT: The -ClientId parameter is required when using -Interactive authentication with modern PnP PowerShell. You must provide the Client ID of your own Entra ID App Registration, or use the well-known PnP Management Shell Client ID: 31359c7f-bd7e-475c-86db-fdb8c937548e. The PnP Management Shell app must be consented in your tenant first — see PnP PowerShell Authentication documentation for details.

How the Script Works

1. Connects to your SharePoint Admin Center using interactive browser login with the provided -ClientId.
2. Retrieves all site collections in the tenant, excluding system/service sites (e.g. app catalog, search center, redirect sites).
3. Checks each site collection for a valid installation of skybow Modern Forms PRO.
4. When -IncludeSubsites is used, recursively retrieves all subsites within each site collection using Get-PnPSubWeb -Recurse and checks each one individually.
5. Optionally checks for the existence of the mFormsStoreLibrary document library on each web when -CheckScriptFolders is used.
6. Collects all results — including a Web Type column distinguishing site collections from subsites — and exports them to a timestamped CSV file.

Step-by-Step Guide

Back to top

The Complete Script

Copy the full script below and save it as FindskybowModernFormsInstallations.ps1:

#----------------------------------------------------------
# Find all Sites with skybow Modern Forms Add-In installed
# Optionally includes subsites and checks for mFormsStoreLibrary
#
# Author  : skybow Support
# Requires: PnP PowerShell module (Install-Module PnP.PowerShell)
#
# Usage (basic):
#   .\FindskybowModernFormsInstallations.ps1 `
#       -AdminCenterURL "https://contoso-admin.sharepoint.com" `
#       -ClientId       "31359c7f-bd7e-475c-86db-fdb8c937548e"
#
# Usage (include subsites):
#   .\FindskybowModernFormsInstallations.ps1 `
#       -AdminCenterURL "https://contoso-admin.sharepoint.com" `
#       -ClientId       "31359c7f-bd7e-475c-86db-fdb8c937548e" `
#       -IncludeSubsites
#
# Usage (full):
#   .\FindskybowModernFormsInstallations.ps1 `
#       -AdminCenterURL "https://contoso-admin.sharepoint.com" `
#       -ClientId       "31359c7f-bd7e-475c-86db-fdb8c937548e" `
#       -IncludeSubsites `
#       -CheckScriptFolders
#----------------------------------------------------------

param(
    [Parameter(Mandatory = $true)]
    [string]$AdminCenterURL,
    # e.g. https://contoso-admin.sharepoint.com

    [Parameter(Mandatory = $true)]
    [string]$ClientId,
    # Client ID of your Entra ID App Registration
    # PnP Management Shell default: 31359c7f-bd7e-475c-86db-fdb8c937548e

    [Parameter(Mandatory = $false)]
    [switch]$IncludeSubsites,
    # If set, also scans all subsites within each site collection

    [Parameter(Mandatory = $false)]
    [switch]$CheckScriptFolders
    # If set, also checks each web for the mFormsStoreLibrary document library
)

$AppName       = "skybow Modern Forms PRO"
$ScriptLibrary = "mFormsStoreLibrary"

$dateTime   = (Get-Date).ToString("yyyy-MM-dd_HHmmss")
$outputFile = ".\skybow_ModernForms_Inventory_$dateTime.csv"

$results = [System.Collections.Generic.List[PSObject]]::new()

#----------------------------------------------------------
# Helper function: Check a single web for the app
#----------------------------------------------------------
function Invoke-WebAppCheck {
    param(
        [string]$WebUrl,
        [string]$WebTitle,
        [string]$WebType,           # "Site Collection" or "Subsite"
        [string]$ParentSiteUrl,     # Empty for site collections
        [bool]  $IsHubSite,
        [string]$HubSiteId
    )

    try {
        Connect-PnPOnline -Url $WebUrl -Interactive -ClientId $ClientId
        $webConnection = Get-PnPConnection

        # Check if skybow Modern Forms PRO is installed on this web
        $installedApp = Get-PnPApp -Connection $webConnection |
                        Where-Object { $_.Title -eq $AppName -and $null -ne $_.InstalledVersion }

        if ($installedApp) {
            Write-Host "  [FOUND] [$WebType] $WebUrl  |  Version: $($installedApp.InstalledVersion)" `
                       -ForegroundColor Green

            # Optional: Check for mFormsStoreLibrary
            $scriptFolderExists = "Not checked"
            if ($CheckScriptFolders) {
                try {
                    $lib = Get-PnPList -Identity $ScriptLibrary `
                                       -Connection $webConnection `
                                       -ErrorAction SilentlyContinue
                    $scriptFolderExists = if ($lib) { "Yes" } else { "No" }
                }
                catch {
                    $scriptFolderExists = "Error checking"
                }
            }

            $row = [PSCustomObject]@{
                "Web Type"           = $WebType
                "Site URL"           = $WebUrl
                "Site Title"         = $WebTitle
                "Parent Site URL"    = $ParentSiteUrl
                "App Installed"      = "Yes"
                "Installed Version"  = $installedApp.InstalledVersion
                "mFormsStoreLibrary" = $scriptFolderExists
                "Is Hub Site"        = $IsHubSite
                "Hub Site Id"        = $HubSiteId
            }
            $script:results.Add($row)
        }
    }
    catch {
        Write-Warning "  [ERROR] Could not process [$WebType] $WebUrl : $($_.Exception.Message)"
    }
}

#----------------------------------------------------------
# Step 1: Connect to SharePoint Admin Center
#----------------------------------------------------------
Write-Host "`nConnecting to SharePoint Admin Center: $AdminCenterURL" -ForegroundColor Cyan
Connect-PnPOnline -Url $AdminCenterURL -Interactive -ClientId $ClientId
$adminConnection = Get-PnPConnection

#----------------------------------------------------------
# Step 2: Retrieve all relevant site collections
#----------------------------------------------------------
Write-Host "Retrieving all site collections (excluding system sites)..." -ForegroundColor Cyan

$excludedTemplates = @(
    "PWA#0", "SRCHCEN#0", "REDIRECTSITE#0", "SPSMSITEHOST#0",
    "APPCATALOG#0", "POINTPUBLISHINGHUB#0", "POINTPUBLISHINGTOPIC#0",
    "EDISC#0", "STS#-1"
)

$sites = Get-PnPTenantSite -Detailed -Connection $adminConnection |
         Where-Object { $excludedTemplates -notcontains $_.Template }

Write-Host "Found $($sites.Count) site collection(s) to scan.`n" -ForegroundColor Cyan
$counter = 0

#----------------------------------------------------------
# Step 3: Iterate through each site collection
#----------------------------------------------------------
foreach ($site in $sites) {
    $counter++
    Write-Progress -Activity "Scanning for '$AppName'" `
                   -Status "$counter / $($sites.Count) — $($site.Url)" `
                   -PercentComplete (($counter / $sites.Count) * 100)

    # --- Check the site collection itself ---
    Invoke-WebAppCheck `
        -WebUrl       $site.Url `
        -WebTitle     $site.Title `
        -WebType      "Site Collection" `
        -ParentSiteUrl "" `
        -IsHubSite    $site.IsHubSite `
        -HubSiteId    $site.HubSiteId

    # --- Optionally check all subsites ---
    if ($IncludeSubsites) {
        try {
            Connect-PnPOnline -Url $site.Url -Interactive -ClientId $ClientId
            $siteConnection = Get-PnPConnection

            $subwebs = Get-PnPSubWeb -Recurse -Connection $siteConnection

            if ($subwebs.Count -gt 0) {
                Write-Host "    Found $($subwebs.Count) subsite(s) under $($site.Url)" `
                           -ForegroundColor DarkCyan

                foreach ($subweb in $subwebs) {
                    Invoke-WebAppCheck `
                        -WebUrl        $subweb.Url `
                        -WebTitle      $subweb.Title `
                        -WebType       "Subsite" `
                        -ParentSiteUrl $site.Url `
                        -IsHubSite     $false `
                        -HubSiteId     ""
                }
            }
        }
        catch {
            Write-Warning "  [ERROR] Could not retrieve subsites for $($site.Url): $($_.Exception.Message)"
        }
    }
}

Write-Progress -Activity "Scanning for '$AppName'" -Completed

#----------------------------------------------------------
# Step 4: Export results to CSV
#----------------------------------------------------------
if ($results.Count -gt 0) {
    $results | Export-Csv -Path $outputFile -NoTypeInformation -Force -Encoding UTF8
    Write-Host "`n  Scan complete. Found $($results.Count) web(s) with '$AppName' installed." `
               -ForegroundColor Green
    Write-Host "   Results saved to: $outputFile" -ForegroundColor Cyan
}
else {
    Write-Host "`n  No sites or subsites found with '$AppName' installed." -ForegroundColor Yellow
}

Result: Full Installation Inventory Available

• You have a complete list of all SharePoint site collections — and subsites if -IncludeSubsites was used — where skybow Modern Forms PRO is currently installed.
• The Web Type column clearly distinguishes between Site Collection and Subsite entries in the CSV.
• The installed version number per web is captured — helping you identify outdated installations that may need an update.
• If -CheckScriptFolders was used, you also know which webs have the mFormsStoreLibrary provisioned by the Forms Designer.
• The CSV export can be used for governance reports, license audits, or planning tenant-wide updates.

Additional Hints & Special Cases

Back to top