About Document library permission using csv

Question

I want to ask if there is any way to grant permission on Document library using CSV?

I want to grant permission on document library using following CSV

I could not find any way i tried following csv with

following script but now work well

Can anyone tell me the correct way to grant permission on document library using csv format?

#Config Variables
$SiteURL = "https://domain.sharepoint.com/sites/Amy12345/"
$ListNames ="library 1","library 2","library 3"

$filePath = "C:\Users\spadmin\Desktop\pnp.csv" 

$csv = Import-CSV $filePath
 
#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -Interactive  

ForEach ($ListName in $ListNames){
    #Break Permission Inheritance of the List
    Set-PnPList -Identity $ListName -BreakRoleInheritance -CopyRoleAssignments
 
    #Grant permission on Library to User
    ForEach($Row in $csv) {
        Set-PnPListPermission -Identity $ListName -AddRole $Row.permission -User $Row.user
    }
}

Answer 1

1.Create a csv file as following picture show.

2.Please run below PNP PowerShell.

$SiteURL = "https://tenant.sharepoint.com/sites/emilytestcom"
$CSVFile = "C:\pnp.csv"

Connect-PnPOnline -Url $SiteURL -Interactive
 
$CSVData = Import-CSV $CSVFile

ForEach($Row in $CSVData)
{
     #Get the user
     $Users = $Row.user

     ForEach($User in $Users)
     {     
           Set-PnPList -Identity $Row.library -BreakRoleInheritance -CopyRoleAssignments
           Set-PnPListPermission -Identity $Row.library -AddRole $Row.permission -User $User
            
     }
   
}

Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.