Create groups and assign permission level using powershell and reading csv

Question

Some of my groups were deleted due to some mistake, wanna create a new group and apply permission level on these groups. is there any way I can do these using PowerShell by reading a CSV file like

   groupName      permissions level  

   grp1           read 
   grp2           contribute 
   grp3           contributenodelete

      $groups = $site.RootWeb.sitegroups

      $COUNGRP= $groups.COUNT

      Write-Host $COUNGRP

      $mdate=  get-date -f yyyy/MM/dd-HHmm

      $csvfilename= "E:\PoCSolutions\spgroupsforcreation.csv"; 
      cls

Venkat Konjeti · Accepted Answer · 2017-06-16 15:37:34Z

1

I am using PnPPowerShell to create groups and permissions.

Here is my CSV

GroupName,PermissionLevel
Test1,Read
Test2,Contribute

Here is snippet to create groups from the CSV

cls

$cred = Get-Credential -UserName "<<username>>" -Message "Enter password"

Connect-PnPOnline -Url "<<site collection url>>" -Credentials $cred
$csvGroups = Import-Csv "C:\Temp\Groups.csv"

foreach($grp in $csvGroups) {
    Write-Host $grp.GroupName
    $newGroup = New-PnPGroup -Title $grp.GroupName
    $role = $grp.PermissionLevel

    Set-PnPGroup -AddRole -Title $newGroup.Title -Identity $newGroup.Id

}

Disconnect-PnPOnline

Here are the reference articles for additional information

How to create a SharePoint group

How to update a group with permissions

answered Jun 16, 2017 at 15:37

Venkat Konjeti

4,9791 gold badge11 silver badges19 bronze badges

I think this is meant for SPO, I am on on-prem. So whether MS has released the PnPPowerShell for on-prem? anyway, thanks for the sample code , i will try to build from your code.

samolpp2
– samolpp2

2017-06-16 15:49:16 +00:00
Commented Jun 16, 2017 at 15:49
1

Yes. There is a different version for On-premises which you can download from here. msdn.microsoft.com/en-us/pnp_powershell/pnp-powershell-overview

Venkat Konjeti
– Venkat Konjeti

2017-06-16 15:50:51 +00:00
Commented Jun 16, 2017 at 15:50

Add a comment |

Stack Exchange Network

Create groups and assign permission level using powershell and reading csv

1 Answer 1

Your Answer

Hot Network Questions

Create groups and assign permission level using powershell and reading csv

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions