Getting a specific value in a multivalued property

[Olaf]

You could use a loop creating a PSCustomObject to combine the results of two different but related queries with each other.
The current thread next to yours has an example of the approach …

PowerShell script to delete Azure guest accounts with "UserState" in "pendingAcceptance" for over 6 months

I don’t have access to an Azure Tenant at the moment … so it is untested … Get-AzureAdUser -All $true -Filter "usertype eq 'guest'" | Where-Object -Property Userstate -EQ -Value 'PendingAcceptance' | ForEach-Object { $ADUserExtension = Get-AzureADUserExtension -ObjectId $_.ObjectId [PSCustomObject]@{ UserPrincipalName = $_.UserPrincipalName UserState = $_.UserState UserType = $_.UserType CreationType = $_.CreationType Mail…