How to export from shift (teams) the member email addresses in addition to name

Quinque Xavier 1 Reputation point
2020-06-05T09:47:58.197+00:00

In export I only have the name of the member, I also want to have his login, email ..
Thank you

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,550 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Sharon Zhao-MSFT 25,081 Reputation points Microsoft Vendor
    2020-06-08T02:51:20+00:00

    Hi QuinqueXavier-3419,

    When you create a schedule in Shifts, the members are consistent with the team which you chosen.

    You can export the members’ properties of each team by the following script. To run this script, you need to have installed SharePoint Online PnP module. You can get this from here.

    function Export-TeamsList  
    {    
         param (    
               $ExportPath  
               )    
        process{  
                    Connect-PnPOnline -Scopes "Group.Read.All","User.ReadBasic.All"  
                    $accesstoken =Get-PnPAccessToken  
                    $MTeams = Invoke-RestMethod -Headers @{Authorization = "Bearer $accesstoken"} -Uri  "https://graph.microsoft.com/beta/groups?`$filter=resourceProvisioningOptions/any(c:c+eq+`'Team`')" -Method Get  
                    $TeamsList = @()  
                    $i=1  
                    do  
                    {  
                        foreach($value in $MTeams.value)  
                        {  
             
                                Write-Progress -Activity "Get All Teams" -status "Found Team $i"                  
                        
                                $id= $value.id  
                                Try  
                                {  
                                    $team = Invoke-RestMethod -Headers @{Authorization = "Bearer $accesstoken"} -Uri https://graph.microsoft.com/beta/Groups/$id/channels -Method Get  
                                      
                                }  
                                Catch  
                                {  
                                     
                                }                   
                      
                                $Owner = Invoke-RestMethod -Headers @{Authorization = "Bearer $accesstoken"} -Uri https://graph.microsoft.com/v1.0/Groups/$id/owners -Method Get  
                                $Members = Invoke-RestMethod -Headers @{Authorization = "Bearer $accesstoken"} -Uri https://graph.microsoft.com/v1.0/Groups/$id/Members -Method Get  
                                $Teams = "" | Select "TeamsName","Owners","MembersCount","Members","MembersEmail"  
                                $Teams.TeamsName = $value.displayname  
                                $Teams.Owners = $Owner.value.displayName -join ";"  
                                $Teams.MembersCount = $Members.value.userPrincipalName.count  
                                $Teams.Members = $Members.value.displayName -join ";"  
                                $Teams.MembersEmail = $Members.value.mail -join ";"  
                                $TeamsList+= $Teams  
                                $teamaccesstype=$null  
                                $errorMessage =$null  
                                $Teams=$null  
                                $team =$null  
                                $i++  
                        }  
                        if ($MTeams.'@odata.nextLink' -eq $null )  
                        {  
                            break  
                        }  
                        else  
                        {  
                            $MTeams = Invoke-RestMethod -Headers @{Authorization = "Bearer $accesstoken"} -Uri $MTeams.'@odata.nextLink' -Method Get  
                        }  
                    }while($true);  
                    $TeamsList.count  
                    $TeamsList  
                    $TeamsList | Export-csv $ExportPath -NoTypeInformation  
                }  
    }  
    Export-TeamsList -ExportPath "C:\temp\teamswithmembers.csv"  
    
    0 comments No comments