SharePoint Online: PowerShell to Add a User to Group
Requirement: Add user to a group in SharePoint Online using PowerShell
How to Add Members to a SharePoint Online Group?
One of the most common tasks that SharePoint administrators need to do is add new members to groups. This post will cover how to add users to groups in SharePoint Online. To provide access to your SharePoint Online site, you can add users to SharePoint Groups such as the default groups – Site Owners, Site Members, or Site Visitors. Here is how to add members to the SharePoint group:
- Log in to the SharePoint Online site which you wish to add members, as an administrator.
- On the site’s home page, click the Settings gear icon >> Choose Site permissions >> and then click on “Advanced Permissions Settings”. Alternatively, You can click on Settings >> Site Settings >> “Users and Permissions” link under “People and Groups” from anywhere else on the site.
- A list of SharePoint groups appears. Click on the name of the group >> Once the desired group has been chosen, click on the “New” button in the toolbar and then choose “Add Users” to add users to the group.
- In the Add users window, Enter the user’s email address or username and click on the “Share” button.
The user will now be added within the specified group!
SharePoint Online PowerShell to Add User to Group
Let’s see how to use PowerShell to add a user to a group in SharePoint Online. This can come in handy if you need to automate the process of adding users to groups, or if you just want to save yourself some time by not having to add users one by one manually.
To add an individual user to SharePoint Online site collection group using PowerShell, use the Add-SPOUser cmdlet from the SharePoint Online management shell. Here is a step-by-step guide on how to add users to a SharePoint Online group via PowerShell:
Step 1: Enter the connection Credentials for SharePoint Online Admin Center
$Credential = Get-credential
This prompts for the user name and password. Key-in your SharePoint Online Administrator credentials.
Step 2: Connect to SharePoint Online Service:
Connect-SPOService -url https://Crescent-admin.sharepoint.com -Credential $Credential
Step 3: Add User to SharePoint Online Site Group:
Once the connection is established successfully in the previous step, you can add a user to a group.
Add-SPOUser -Site "https://Crescent.sharepoint.com/sites/Sales" -Group "Sales Members" -LoginName [email protected]
The SharePoint Online Management Shell looks like this:
You can also use CSOM PowerShell to add users to a group. Here is how: SharePoint Online: Add user to a group using PowerShell CSOM
Bulk Add Users from a CSV File to SharePoint Online Group using PowerShell:
Now, the next question is, What if you want to add 100’s of users to a site collection? Well, adding multiple users to a SharePoint Online group is easy with PowerShell. In just a few lines of code, you can add as many users as you need and have them quickly added to the group to save time. Here is how to add multiple users to groups in SharePoint Online from a CSV file.
Step 1: Create a CSV file and fill it in according to your requirements
Step 2: Use this PowerShell script to Read from CSV and import users to SharePoint Group:
#Connection paramaters
$AdminURL = "https://Crescent-admin.sharepoint.com/"
$AdminName = "[email protected]"
$CSVFile="C:\UsersToAdd.csv"
#User Names Password to connect
$Password = Read-host -assecurestring "Enter Password for $AdminName"
$Credential = new-object -typename System.Management.Automation.PSCredential -argumentlist $AdminName, $Password
#Connect to SharePoint Online
Connect-SPOService -url $AdminURL -credential $Credential
#add multiple users to sharepoint online group powershell - Import Users from CSV
Import-Csv $CSVFile | ForEach-Object { Add-SPOUser -Site $_.SiteURL -Group $_.GroupName -LoginName $_.UserAccount}
To import users to group in bulk from an Excel file, use: Add users to group in SharePoint Online using PowerShell from Excel
PnP PowerShell to Bulk Add Multiple Users to Multiple Site’s Group in SharePoint Online:
Here is another case: How to add multiple users to multiple site collection’s Owners group? PowerShell makes it easy to add multiple users to a SharePoint Online group.
#Variables
$SiteURLs = "Sales","Intranet","Marketing"
$UserIDs = "[email protected]","[email protected]"
#Iterate through each site
ForEach($Site in $SiteURLs)
{
#Connect to SharePoint Online Site
Write-host "Connecting to Site: "$Site
Connect-PnPOnline -Url https://crescent.sharepoint.com/sites/$Site -Interactive
#Get the Associcated Owners group of the site
$Web = Get-PnPWeb
$Group = Get-PnPGroup -AssociatedOwnerGroup
#Add Each user to the Group
ForEach($User in $UserIDs)
{
Add-PnPGroupMember -LoginName $User -Identity $Group
Write-host -f Green "`tAdded $User to $($Group.Title)"
}
}
To add an external user to a group in SharePoint Online PowerShell, use: How to Add External User to SharePoint Online Group using PowerShell?