Get All Apps From The App Catalog And Export It To CSV

Summary

This script shows how to get all apps from the app catalog and Export to CSV.

Implementation

Open Windows PowerShell ISE
Create a new file
Write a script as below,
First, we will connect to a SharePoint Admin tenant.
- then we fetch all apps from the app catalog.
- And then we will export it to CSV with some required properties.

PnP PowerShell
CLI for Microsoft 365


$adminSiteURL = "https://domain-admin.sharepoint.com/"
$username = "chandani@domain.onmicrosoft.com"
$password = "********"
$secureStringPwd = $password | ConvertTo-SecureString -AsPlainText -Force 
$creds = New-Object System.Management.Automation.PSCredential -ArgumentList $username, $secureStringPwd
$basePath = "E:\Contribution\PnP-Scripts\GetAllApps"
$dateTime = "{0:MM_dd_yy}_{0:HH_mm_ss}" -f (Get-Date)
$csvPath = $basePath + "\apps" + $dateTime + ".csv"

Function Login() {
    [cmdletbinding()]
    param([parameter(Mandatory = $true, ValueFromPipeline = $true)] $creds)
 
    #connect to O365 admin site
    Write-Host "Connecting to Tenant Admin Site '$($adminSiteURL)'" -f Yellow 
  
    Connect-PnPOnline -Url $adminSiteURL -Credentials $Creds
    Write-Host "Connection Successfull" -f Green 
}


Function ExportAllApps {

    Write-Host "Getting apps..." -f Yellow 
    $AllApps = Get-PnPApp 
    Write-Host "Successfully fetched all apps" -f Green

    Write-Host "Exporting..." -f Yellow
    $AllApps | Export-Csv -Path $csvPath -NoTypeInformation -Append   
    Write-Host "Exported successfully" -f Green
}

Function StartProcessing {
    Login($creds);
    ExportAllApps
}

StartProcessing

Check out the PnP PowerShell to learn more at: https://aka.ms/pnp/powershell

The way you login into PnP PowerShell has changed please read PnP Management Shell EntraID app is deleted : what should I do ?

$basePath = "C:\workspace\a_Local\cli_sample"
$dateTime = "{0:MM_dd_yy}_{0:HH_mm_ss}" -f (Get-Date)
$csvPath = $basePath + "\apps" + $dateTime + ".csv"

Function Login
{
    #connect to O365 admin site
    Write-Host "Connecting to Tenant" -f Yellow 
  
    $m365Status = m365 status
    if ($m365Status -match "Logged Out") {
        m365 login
    }
}


Function ExportAllApps
{
    Write-Host "Getting apps..." -f Yellow 
    $AllApps = m365 spo app list
    $AllApps = $AllApps | ConvertFrom-Json
    Write-Host "Successfully fetched all apps" -f Green

    Write-Host "Exporting..." -f Yellow
    $AllApps | select-object ID,AppCatalogVersion,CanUpgrade,Deployed,InstalledVersion,IsClientSideSolution,Title | Export-Csv -Path $csvPath -NoTypeInformation -Append   
    Write-Host "Exported successfully" -f Green
}

Function StartProcessing {
    Login
    ExportAllApps
}

StartProcessing

Check out the CLI for Microsoft 365 to learn more at: https://aka.ms/cli-m365

Important changes coming to the way you login into CLI for Microsoft 365 (effective 9th September 2024) see Changes in PnP Management Shell registration in Microsoft 365

Contributors

Author(s)
Chandani Prajapati
Adam Wójcik

Disclaimer

THESE SAMPLES ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.