In this article, we will cover the basics of performing bulk operations in Microsoft 365 with PowerShell. We will cover how to bulk add users and modify attributes, including user properties and group membership.

Bulk Adding Users

Adding a single user to Microsoft 365 can be done through the admin portal, but when it comes to adding multiple users, PowerShell is a more efficient and time-saving method. Here are the steps to add multiple users using PowerShell:

1. Connect to Microsoft 365: 

The first step is to connect to your Microsoft 365 account using PowerShell. To do this, open PowerShell and run the following command:

1. Connect-MsolService 

2. Create a CSV file: 

Next, you will need to create a CSV file with the user information you want to add. The CSV file should include the following headers:

1. UserPrincipalName, DisplayName, FirstName, LastName, Password, UsageLocation 

UserPrincipalName,DisplayName,FirstName,LastName,Password,UsageLocation john.doe@contoso.com,John Doe,John,Doe,Password123,US jane.doe@contoso.com,Jane Doe,Jane,Doe,Password123,US 

3. Import the CSV file: 

Once you have created the CSV file, you can import it into PowerShell using the following command:

1. $users = Import-Csv -Path C:\path\to\file.csv 

4. Create the users: 

Finally, you can create the users by running the following command:

1. foreach ($user in $users) { New-MsolUser -UserPrincipalName $user.UserPrincipalName -DisplayName $user.DisplayName -FirstName $user.FirstName -LastName $user.LastName -Password $user.Password -UsageLocation $user.UsageLocation } 

Bulk Modifying User Attributes

In addition to adding multiple users at once, PowerShell can also be used to modify attributes for multiple users. Here are the steps to modify user attributes using PowerShell:

1. Connect to Microsoft 365: 

As with adding users, the first step is to connect to your Microsoft 365 account using PowerShell.

2. Create a CSV file: 

Next, you will need to create a CSV file with the user information you want to modify. The CSV file should include the following headers:

UserPrincipalName, AttributeName, AttributeValue 

Here is an example of what the CSV file might look like:

UserPrincipalName,AttributeName,AttributeValue john.doe@contoso.com,Department,IT jane.doe@contoso.com,Department,HR 

3. Import the CSV file: 

Once you have created the CSV file, you can import it into PowerShell using the following command:

1. $users = Import-Csv -Path C:\path\to\file.csv 

4. Modify the attributes: 

Finally, you can modify the user attributes by running the following command:

1. foreach ($user in $users) { Set-MsolUser -UserPrincipalName $user.UserPrincipalName - $user.AttributeName $user.AttributeValue } 

Bulk Modifying Group Membership

Another common task in Microsoft 365 administration is managing group membership. PowerShell can be used to bulk modify group membership for multiple users. Here are the steps to modify group membership using PowerShell:

1. Connect to Microsoft 365: 

As with the previous examples, the first step is to connect to your Microsoft 365 account using PowerShell.

2. Create a CSV file: 

Next, you will need to create a CSV file with the user information and the groups you want to modify. The CSV file should include the following headers:

UserPrincipalName, GroupName, Action 

The Action column should contain either "Add" or "Remove" to indicate whether the user should be added to or removed from the group. Here is an example of what the CSV file might look like:

UserPrincipalName,GroupName,Action john.doe@contoso.com,IT Group,Add jane.doe@contoso.com,HR Group,Remove 

3. Import the CSV file: 

Once you have created the CSV file, you can import it into PowerShell using the following command:

4. Modify the group membership: 

Finally, you can modify the group membership by running the following command:

1. foreach ($membership in $memberships) { if ($membership.Action -eq "Add") { Add-MsolGroupMember -GroupObjectId (Get-MsolGroup -SearchString $membership.GroupName).ObjectId -GroupMemberObjectId (Get-MsolUser -UserPrincipalName $membership.UserPrincipalName).ObjectId } elseif ($membership.Action -eq "Remove") { Remove-MsolGroupMember -GroupObjectId (Get-MsolGroup -SearchString $membership.GroupName).ObjectId -GroupMemberObjectId (Get-MsolUser -UserPrincipalName $membership.UserPrincipalName).ObjectId } } 

Conclusion

In conclusion, PowerShell is a powerful tool that can be used to perform bulk operations in Microsoft 365. Whether you need to add multiple users, modify user attributes, or manage group membership, PowerShell can help you automate these tasks and save time. By following the steps outlined in this article, you can quickly and easily perform bulk operations in Microsoft 365 with PowerShell.