Modily site URL into csv for granting permission to document library

Question

I wan to run following script by modifying SiteURL in csv same as the following csv

How can I modify site URL into csv so I could use script smoothly

#Config Variables
$SiteURL = "https://tsubaki518.sharepoint.com/sites/allcompany"
$CSVFile = "C:\Document.csv"
 
Try {
    #Connect to PnP Online
    Connect-PnPOnline -Url $SiteURL -Interactive
 
    #Get the CSV file
    $CSVData = Import-CSV $CSVFile
  
    #Read CSV file and grant folder permissions
    ForEach($Row in $CSVData)
    {
        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
            }
        }
        Catch {
            Write-host "Error: $($_.Exception.Message)" -foregroundcolor Red
        }
    }
}
Catch {
    write-host "Error: $($_.Exception.Message)" -foregroundcolor Red
}

Answer 1

Hi @ネパリ サンデャ

We can try to get siteurl from $Row. Please refer to the following script

#Config Variables
$CSVFile = "C:\Document.csv"
 
Try {
    #Get the CSV file
    $CSVData = Import-CSV $CSVFile
  
    #Read CSV file and grant folder permissions
    ForEach($Row in $CSVData)
    {
        $SiteURL=$Row.SiteURL
        #Connect to PnP Online
        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
            }
        }
        Catch {
            Write-host "Error: $($_.Exception.Message)" -foregroundcolor Red
        }
    }
}
Catch {
    write-host "Error: $($_.Exception.Message)" -foregroundcolor Red
}

---

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 2

@ネパリ サンデャ

@JamaliSara

@jennyKim

Are you guys all taking the same class? You are all asking a question about what looks like the same script.

Maybe you want to get together and ask your teacher for help with Powershell basics. Or review each other's script to see what everyone else is doing.

https://learn.microsoft.com/en-us/answers/questions/1319847/unexpected-token-))-in-expression-or-statement

https://learn.microsoft.com/en-us/answers/questions/1320364/modily-site-url-into-csv-for-granting-permission-t

https://learn.microsoft.com/en-us/answers/questions/1320418/script-not-able-to-run-in-pnp-powershell-in-ps1-fo