Sunday, June 5, 2016

SharePoint Online: PowerShell to Add User to Group

Requirement: Add user to group in SharePoint online using PowerShell.

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

Solution: SharePoint Online PowerShell to add user to group
To add an individual user to SharePoint online site collection group using PowerShell, use Add-SPOUser cmdlet from SharePoint online management shell. Here is an example:

Step 1: Enter the connection Credentials for SharePoint Online Admin Center
$Credential = Get-credential
This prompts for 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 user to group.
Add-SPOUser -Site "https://Crescent.sharepoint.com/sites/Sales" -Group "Sales Members" -LoginName salaudeen@Crescent.com
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.
 
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? Here is how to add multiple users to groups in SharePoint online from a CSV file.

Step 1: Create a CSV file and fill in according to your requirements
sharepoint online powershell add user to group

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 = "SPAdmin@Crescent.com"
$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

#Import Users from CSV File to the Site colection
Import-Csv $CSVFile | ForEach-Object { Add-SPOUser -Site $_.SiteURL -Group $_.GroupName -LoginName $_.UserAccount}

You can also use CSOM PowerShell to add user to group. Here is how: SharePoint Online PowerShell to add user to group



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!


You might also like:

Related Posts Plugin for WordPress, Blogger...