How to Office 365 Teams Get-Team and Get-Teamuser results export to CSV file

Question

I wanna export to csv file like this format.

Team name | User name | Role
================================

But, Get-Teamuser cmdlet result is

Userid | User | Name | Role
===============================

What should I do?

Answer 1

You can use calculated expressions like below

get-teamuser |select @{
 Name = 'Team name';  Expression = {$_.name}},@{ Name = 'user name';  Expression = {$_.user +' '+$_.name}},role| export-csv -path c:\teamsdata.csv

Answer 2

The script will be as follows:

Connect-MicrosoftTeams

$output=@()
$teams = Import-Csv "C:\Get-Team Wise user details\Teams.csv" 

ForEach ($team in $teams) {
    $teamUsers = Get-TeamUser -GroupId $team.GroupId 

    ForEach ($teamUser in $teamUsers) {
        $userObj = New-Object PSObject 

        $userObj | Add-Member NoteProperty -Name "Team Display Name" -Value $team.DisplayName
        $userObj | Add-Member NoteProperty -Name "User Name" -Value $teamUser.Name
        $userObj | Add-Member NoteProperty -Name "User SMTP Address" -Value $teamUser.User
        $userObj | Add-Member NoteProperty -Name "User Role" -Value $teamUser.Role

        $output += $userObj
        Write-Output "$($team.DisplayName);$($teamUser.Name);$($teamUser.User);$($teamUser.Role)"
    }
}

$output | Export-csv -Path C:\BatchWiseUserDetails.csv -NoTypeInformation -Encoding UTF8

The import CSV need to have only one column called "GroupID"