Powershell Script - Step 9 - Recommendation about microsoft-teams-apps-classroom-dropin HOT 2 OPEN

Install-Module -Name MicrosoftTeams -Repository PSGallery

Connect-MicrosoftTeams

$TeamList = @()

Write-Host ""

Foreach ($Team in Get-Team)
{       
$TeamGUID = $Team.GroupId.ToString()
$TeamName = $Team.DisplayName
$TeamList = $TeamList + [PSCustomObject]@{TeamName = $TeamName; TeamObjectID = $TeamGUID}
}

#######

Install-Module -Name MicrosoftTeams -Repository PSGallery -force

Connect-MicrosoftTeams

$AllTeamsInOrg = (Get-Team -Archived $false).GroupID

$TeamList = @()

Write-Output "This may take a little bit of time... Please sit back & relax!"

Write-Host ""



Foreach ($Team in $AllTeamsInOrg)
{ 
$TeamGUID = $Team.ToString() 
$TeamName = (Get-Team -GroupId $TeamGUID).DisplayName
$TeamList = $TeamList + [PSCustomObject]@{TeamName = $TeamName; TeamObjectID = $TeamGUID} 
}

$TestPath = test-path -path 'c:\temp'

if ($TestPath -ne $true) {New-Item -ItemType directory -Path 'c:\temp' | Out-Null

write-Host  'Creating directory to write file to c:\temp. Your file is uploaded as TeamsData.csv'}

else {Write-Host "Your file has been uploaded to c:\temp as 'TeamsData.csv'"}

$TeamList | export-csv c:\temp\TeamsData.csv -NoTypeInformation

Install-Module SharepointPNPPowershellOnline
Set-ExecutionPolicy Undefined  -Scope CurrentUser
Connect-MicrosoftTeams

$SiteUrl = "https://<replacewithyourdomain>/sites/ClassroomDrop-in"

$ListName = "Teams"

$CSVPath = "c:\temp\TeamsData.csv"

$CSVData = Import-CsV -Path $CSVPath

Connect-PnPOnline $SiteUrl -UseWebLogin

ForEach ($Row in $CSVData){
$ownerColl=Get-TeamUser -GroupId $($Row.TeamObjectID) -Role Owner
foreach($owner in $ownerColl){
Add-PnPListItem -List $ListName -Values @{"Teacher"= $owner.Name;
"Title" = $($Row.TeamName);
"TeamID" = $($Row.TeamObjectID);
};
}
}