Forum Discussion

Luca VALENTINO's avatar
Luca VALENTINO
Copper Contributor
Mar 21, 2020

Create Teams from csv

I am trying to create Teams from a CSV file My Csv: Mail TeamsName TeamsDescription Type TypeTemplate Owners EV0123 EV - Prova Descrizione1 Private EDU_Class email@dom.it SN0123 ...
Administrator Teams
  • MariusPretorius's avatar
    MariusPretorius
    Steel Contributor
    Nov 25, 2020

    EDU_ictGeek Luca VALENTINO 

    I am successfully using the script from Create teams in Microsoft Teams through CSV using PowerShell | JiJi Technologies to create multiple teams, including the channels and adding members simultaneously, from a prepared CSV file.

    N.B. I made two small changes to the script.

    • Preparation:
      • I ran PowerShell in Admin mode 
      • I ensured that I had installed the current version of the MicrosoftTeams PowerShell module. I ran the following command in PowerShell (in admin mode) Install-Module -Name MicrosoftTeams -RequiredVersion 1.1.6
    • I made the two highlighted changes to script in the function Create-NewTeam: 
      • $group = New-Team -MailNickName $team.TeamsName -displayname $team.TeamsName -Template $team.TeamType
      • In the original script it uses -Alias instead of -MailNickName and -AccessType instead of -Template
    • My CSV file had the following headers and example content
      TeamsNameTeamTypeChannelNameOwnersMembers
      21Accounting11EDU_classChannel1; Channel2Teacher1@domain.comMember1@domain.com; member2@domain.com
    • The Team Type is important - you need that in an educational setting to create Class type teams.
    • RicMercene's avatar
      RicMercene
      Copper Contributor
      Apr 14, 2021

      MariusPretorius Luca VALENTINO EDU_ictGeek 

       

      Good day!

       

      I really need your help... please....

       

      I tried your codes but nothing happened....

       

      attached is my .csv file for reference and below (here) is my code...

       

      function Create-Channel
      {
      param (
      $ChannelName,$GroupId
      )
      Process
      {
      try
      {
      $teamchannels = $ChannelName -split ";"
      if($teamchannels)
      {
      for($i =0; $i -le ($teamchannels.count - 1) ; $i++)
      {
      New-TeamChannel -GroupId $GroupId -DisplayName

      $teamchannels[$i]
      }
      }
      }
      Catch
      {
      }
      }
      }

      function Add-Users
      {
      param(
      $Users,$GroupId,$CurrentUsername,$Role
      )
      Process
      {

      try{
      $teamusers = $Users -split ";"
      if($teamusers)
      {
      for($j =0; $j -le ($teamusers.count - 1) ; $j++)
      {
      if($teamusers[$j] -ne $CurrentUsername)
      {
      Add-TeamUser -GroupId $GroupId -User

      $teamusers[$j] -Role $Role
      }
      }
      }
      }
      Catch
      {
      }
      }
      }

      function Create-NewTeam
      {
      param (
      $ImportPath
      )
      Process
      {
      Import-Module MicrosoftTeams
      $cred = Get-Credential
      $username = $cred.UserName
      Connect-MicrosoftTeams -Credential $cred
      $teams = Import-Csv -Path $ImportPath
      foreach($team in $teams)
      {
      $getteam= get-team |where-object { $_.displayname -eq

      $team.TeamsName}
      If($getteam -eq $null)
      {
      Write-Host "Start creating the team: " $team.TeamsName
      $group = New-Team -DisplayName $team.TeamsName -

      displayname $team.TeamsName -Template $team.TeamType
      Write-Host "Creating channels..."
      Create-Channel -ChannelName $team.ChannelName -GroupId

      $group.GroupId
      Write-Host "Adding team members..."
      Add-Users -Users $team.Members -GroupId $group.GroupId -

      CurrentUsername $username -Role Member
      Write-Host "Adding team owners..."
      Add-Users -Users $team.Owners -GroupId $group.GroupId -

      CurrentUsername $username -Role Owner
      Write-Host "Completed creating the team: "

      $team.TeamsName
      $team=$null
      }
      }
      }
      }

      Create-NewTeam -ImportPath "C:\Users\Admin1234\Desktop\1.csv"

       

       

       

      Thank you very much. Best Regards.

      • MariusPretorius's avatar
        MariusPretorius
        Steel Contributor
        Apr 26, 2021

        RicMercene 

        It seems your code is missing a function name and opening curly bracket at the beginning and a closing curly bracket below your last line. Your code looks like this:

         

         

        function Create-Channel
        {
        .

        .

        .

        Create-NewTeam -ImportPath "C:\Users\Admin1234\Desktop\1.csv"

         

        It should read like this: (I'm only including the missing code)

         

        Function New-TeamsFromCSV
{
function Create-Channel
.
.
.
Create-NewTeam -ImportPath "C:\Users\Admin1234\Desktop\1.csv"
}

         

        Obviously, you have to take a few steps for your code to execute in PowerShell:

        • you need to use the PowerShell command line to import the module

         

         import-module TheModuleName.psm1

         

        •  I prefer to run PowerShell in Administrator mode to make sure I don't run into permissions problems
        • The name of the module you need to import is the (path and the )name of your .psm1 file
        • and call the function (run it) as shown below.

         

        New-TeamsFromCSV

         

        Because you are connecting to Teams Admin, you will be asked for your credentials. You need to be a Teams Administrator and provide that username/email address and password. Thereafter you will be flying!

    • EDU_ictGeek's avatar
      EDU_ictGeek
      Brass Contributor
      Jan 11, 2021

      MariusPretorius 

       

      Good afternoon, thank you for this, its really useful.  I will try to emulate to the letter.

       

      This is very kind,  thanks again.

  • Luca VALENTINO's avatar
    Luca VALENTINO
    Copper Contributor
    Apr 29, 2020

     I managed to create the class groups.
    Now I want to insert the members in the various groups but nothing

     

    #Connettere a Teams
#Connect-MicrosoftTeams
function Add-Users
{   
    param(   
             $ImportPath
             #,$CurrentUsername,$Role
          )   
    Process
    {
        Import-Module MicrosoftTeams
        $cred = Get-Credential
        $username = $cred.UserName
        Connect-MicrosoftTeams -Credential $cred
        #$teamusers = Import-Csv -Path $ImportPath 
        try{
                $teamusers = $Users -split ";" 
        Write-Host "Start add the users: " $Users
                if($teamusers)
                {
                    for($j =0; $j -le ($teamusers.count - 1) ; $j++)
                    {
                        if($teamusers[$j] -ne $CurrentUsername)
                        {
                            Add-TeamUser -GroupId $GroupName -User $teamusers[$j]
                        }
                    }
                }
            }
        Catch
            {
            }
        }
}
Add-Users -ImportPath "C:\PC\OFFICE 365\Gruppi_membri_team.csv"

Resources