Export all PowerApps details and its Role assignments from Tenant in CSV format

#Modules for PowerApps Powershell Commands
Install-Module -Name Microsoft.PowerApps.Administration.PowerShell
Install-Module -Name Microsoft.PowerApps.PowerShell -AllowClobber

#PowerApps Connection
Add-PowerAppsAccount

$currentTime=$(get-date).ToString("yyyyMMddHHmmss");    
$outputFilePath="D:\SP\repos\PowerAppsInventory-"+$currentTime+".csv"    
$resultColl=@()   

write-host -ForegroundColor Magenta "Getting all the PowerApp Details..."  
   
# Get all the PowerApps  
$apps=Get-AdminPowerApp 
foreach($app in $apps)  
{  
   
   foreach($user in Get-PowerAppRoleAssignment -Appname $app.Appname)
   { 
    $result = New-Object PSObject
    $result | Add-Member -MemberType NoteProperty -name "AppName" -value $app.AppName -Force
    $result | Add-Member -MemberType NoteProperty -name "DisplayName" -value $app.DisplayName  -Force
    $result | Add-Member -MemberType NoteProperty -name "PrincipalDisplayName" -value $user.PrincipalDisplayName-Force
    $result | Add-Member -MemberType NoteProperty -name "PrincipalEmail" -value $user.PrincipalEmail-Force
    $result | Add-Member -MemberType NoteProperty -name "RoleType" -value $user.RoleType-Force
    $result | Add-Member -MemberType NoteProperty -name "Environment" -value $app.EnvironmentName -Force
    $result | Add-Member -MemberType NoteProperty -Name "CreatedTime" -value $app.CreatedTime  -Force
    $result | Add-Member -MemberType NoteProperty -Name "LastModifiedTime" -value $app.LastModifiedTime  -Force

    # Getting more details about the app
   #  displayName, description, appUris, createdTime, lastModifiedTime, sharedGroupsCount, sharedUsersCount, appOpenProtocolUri, appOpenUri, appPlayUri, appPlayEmbeddedUri, appPlayTeamsUri, connectionReferences, userAppMetadata, isFeaturedApp, bypassConsent, isHeroApp, environment, almMode, performanceOptimizationEnabled, unauthenticatedWebPackageHint, canConsumeAppPass, enableModernRuntimeMode, executionRestrictions, appPlanClassification, usesPremiumApi, usesOnlyGrandfatheredPremiumApis, usesCustomApi, usesOnPremiseGateway, usesPcfExternalServiceUsage, isCustomizable, chatPaneCopilotEnabled, draftingCopilotEnabled

   $propertyNames = @(
    "displayName",
    "description",
    "appUris",
    "createdTime",
    "lastModifiedTime",
    "sharedGroupsCount",
    "sharedUsersCount",
    "appOpenProtocolUri",
    "appOpenUri",
    "appPlayUri",
    "appPlayEmbeddedUri",
    "appPlayTeamsUri",
    "connectionReferences",
    "userAppMetadata",
    "isFeaturedApp",
    "bypassConsent",
    "isHeroApp",
    "environment",
    "almMode",
    "performanceOptimizationEnabled",
    "unauthenticatedWebPackageHint",
    "canConsumeAppPass",
    "enableModernRuntimeMode",
    "executionRestrictions",
    "appPlanClassification",
    "usesPremiumApi",
    "usesOnlyGrandfatheredPremiumApis",
    "usesCustomApi",
    "usesOnPremiseGateway",
    "usesPcfExternalServiceUsage",
    "isCustomizable",
    "chatPaneCopilotEnabled",
    "draftingCopilotEnabled"
)

# You can now use $propertyNames as an array of these properties
 foreach($appProp in $app | select -ExpandProperty Internal | select -ExpandProperty Properties)
    {
      foreach($propName in $propertyNames){
         $result | Add-Member -MemberType NoteProperty -name $propName -value $appProp.$propName -Force
      }
    }

    $resultColl += $result 
   }
}  

#Export the result Array to CSV file  
$resultColl | Export-Csv $outputFilePath -NoTypeInformation 

write-host -ForegroundColor Magenta "Successful!!"