Get-Microsoft365GroupDetails.ps1

#requires -modules "PnP.PowerShell"

Connect-PnPOnline `
            -Url         "https://$env:O365_TENANT-admin.sharepoint.com" `
            -ClientId    $env:O365_CLIENTID `
            -Thumbprint  $env:O365_THUMBPRINT `
            -Tenant      $env:O365_TENANTID `
            -ErrorAction Stop

$unifiedGroups = Get-PnPMicrosoft365Group

$publicUnifiedGroups = $unifiedGroups | Where-Object -Property Visibility -eq "public"

$results = foreach( $unifiedGroup in $publicUnifiedGroups )
{
    # this method avoids a access token expiration issue
    $unifiedGroupDetail = Get-PnPMicrosoft365Group -Identity $unifiedGroup.GroupId -IncludeSiteUrl -IncludeOwners

    [PSCustomObject] @{
        GroupName                 = $unifiedGroup.DisplayName
        GroupId                   = $unifiedGroup.Id
        CreatedDateTime           = $unifiedGroup.CreatedDateTime
        GroupOwnerEmails          = $unifiedGroupDetail.Owners.Email -join ";"
        SiteUrl                   = $unifiedGroupDetail.SiteUrl
        IsMicrosoftTeamsConnected = $unifiedGroup.HasTeam
        IsVivaEngageConnected     = $unifiedGroup.CreationOptions -contains "YammerProvisioning"
    }
}

$timestamp = Get-Date -Format FileDateTime

$results | Export-Csv -Path "PublicM365Groups_$timestamp.csv" -NoTypeInformation