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

$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

$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