Import CSV to an existing SharePoint List

[CmdletBinding()]
param (
    [Parameter(Mandatory = $true)]
    [string]$Url,
    [Parameter(Mandatory = $true)]
    [string]$ListName,
    [Parameter(Mandatory = $true)]
    [string]$CsvFile
)
begin {
    Import-Module PnP.PowerShell
    Write-Output "Connecting to $Url"
    Connect-PnPOnline -Url $Url -Interactive
}
process {
    
    
    ## Powershell filter , it converts an array in a hashtable
    filter ArrayToHash {
        begin {
            $hash = @{} 
        }
        process { 
            $obj = $_ | Get-Member | Where-Object { $_.MemberType -eq 'NoteProperty' } | Select-object name
            foreach ($o in $obj) {
                $name = $o.Name
                $hash[$name] = $_."$name"
            }
     
        }
        end { return $hash }
    }
    Write-Output " Collect CSV data from $CsvFile"
    $rows = Import-Csv $CsvFile
    $totalRows = $rows.Length
    Write-Output " $CsvFile has $totalRows rows"
 
    Write-Output " Items will be added using batch mode"
    Write-Output " Initiate batch" 
    $batch = New-PnPBatch
    $ct=0
    $rows.ForEach({
            # convert hast
            $values = $_ | ArrayToHash
            Add-PnPListItem -List $ListName -Values $values -Batch  $batch
            Write-Output "  Item added ($ct/$totalRows)"  
            $ct++
        })
    Write-Output " Invoke batch" 
    Invoke-PnPBatch -Batch $batch
    Write-Output " Batch invoked"
}
end{
    Write-Output " Disconnecting"
    Disconnect-PnPOnline
    Write-Output "Disconnected from $Url"
    Write-Output "All done!"
}