Unexpected token '}' in expression or statement

Question

I want to grant permission to document library using following script

But

Unexpected token '}' in expression or statement error have been occured no

#Config Variables
$CSVFile = "C:\Users\\Downloads\Test.csv"

#Get the data from CSV file
$CSVFile = Import-CSV $CSVFilePath
   
#Read CSV file and Grant Permission to the Folder
ForEach($Row in $CSVFile)
{
    $SiteURL=$Row.SiteURL
    #Connect to the site
    Connect-PnPOnline -Url $SiteURL -Interactive
 
        Try {
            #Get the user
            $Users = $Row.user

            ForEach($User in $Users)
            {
                #Grant Permission to the Folder
                Set-PnPList -Identity $Row.library -BreakRoleInheritance -CopyRoleAssignments
                Set-PnPListPermission -Identity $Row.library -AddRole $Row.permission -User $User
               Set-PnPListPermission -Identity $Row.library -AddRole $Row.permission -User $User
            }
        }
        Catch {
            Write-host "Error: $($_.Exception.Message)" -foregroundcolor Red
        }
    }
}
Catch {
    write-host "Error: $($_.Exception.Message)" -foregroundcolor Red
}

Answer 1

You just have one too many closing brackets. You may be getting misled by the indentation.

#Config Variables
$CSVFile = "C:\Users\\Downloads\Test.csv"

#Get the data from CSV file
$CSVFile = Import-CSV $CSVFilePath
   
#Read CSV file and Grant Permission to the Folder
ForEach($Row in $CSVFile)
{
    $SiteURL=$Row.SiteURL
    #Connect to the site
    Connect-PnPOnline -Url $SiteURL -Interactive
 
    Try {
        #Get the user
        $Users = $Row.user

        ForEach($User in $Users)
        {
            #Grant Permission to the Folder
            Set-PnPList -Identity $Row.library -BreakRoleInheritance -CopyRoleAssignments
            Set-PnPListPermission -Identity $Row.library -AddRole $Row.permission -User $User
            Set-PnPListPermission -Identity $Row.library -AddRole $Row.permission -User $User
        }
    }
    Catch {
        Write-host "Error: $($_.Exception.Message)" -foregroundcolor Red
    }
}
Catch {
    write-host "Error: $($_.Exception.Message)" -foregroundcolor Red
}

Answer 2

@MotoX80 is correct regarding the extra closing bracket. But even when that problem is resolved, you still have a "Catch" block in the last three lines that has no matching "Try":

Catch {
    Write-Host "Error: $($_.Exception.Message)" -ForegroundColor Red
}

Answer 3

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
            
     }
}   

---

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.

Answer 4

1.Create a csv file as following picture show.

2.Please run below PNP PowerShell.

 $filePath = "C:\pnp.csv"

 $csv = Import-Csv $filePath

 ForEach($Row in $csv)
 {
     Connect-PnPOnline -Url $Row.SiteURL -Interactive
     Set-PnPList -Identity $Row.library -BreakRoleInheritance -CopyRoleAssignments
     Set-PnPListPermission -Identity $Row.library -AddRole $Row.permission -User $Row.user

 }   

---

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.

Answer 5

According to the screenshot you provide, PowerShell contains some mistakes. Please following below steps.

1.Create a csv file as following picture show.

2.Run following PowerShell by using site collection admin account.

 $filePath = "C:\pnp.csv"

 $csv = Import-Csv $filePath

 ForEach($Row in $csv)
 {
     Connect-PnPOnline -Url $Row.SiteURL -Interactive
     Set-PnPList -Identity $Row.library -BreakRoleInheritance -CopyRoleAssignments
     Set-PnPListPermission -Identity $Row.library -AddRole $Row.Permission -User $Row.user

 }

---

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.