Forum Discussion
Import CSV for bulk upload (instead complete 1 by 1 forms)
Hi there,
We have a SharePoint page which show items that people need to manually add through a form. The form requieres almost 30 fields all of them mandatory and almost all of them have m...
you can try below sample pnp powershell script for bulk upload List item using csv and this script support multi value option
Connect-PnPOnline -Url https://m365x.sharepoint.com/sites/testsite
$path = "C:\Users\importlistitem1.csv"
$csvs = Import-Csv $path
foreach($values in $csvs )
{
Add-PnPListItem -List "testlist" -ContentType $values.ContentType -Values @{"Title" = $values.Title; "Multichoice"= $values.Multichoice.split(",") ; "Singleline" = $values.Singleline ; "User" = $values.User ; "Date" = $values.Date ; "Number" = $values.Number }
}