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 to 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.
    how to add members to a sharepoint online group
  • In the Add users window, Enter the user’s email address or username and click on the “Share” button.
    share site with users in sharepoint online

The user will now be added to 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.

Prerequisites: You need to have SharePoint Online Management Shell installed in your client machine!

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:

add user to group in sharepoint online using powershell

This adds the given user to the group in SharePoint Online.

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 hundreds 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.

sharepoint online powershell add user to group

You can download the CSV template here:

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?

Salaudeen Rajack

Salaudeen Rajack - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

Leave a Reply

Your email address will not be published.