Upload excel Document items to Sharepoint list using PnP PowerShell
Actually, I am able to upload Excel items to the SharePoint list using PnPPowershell, only the date, and lookup columns I am not able to upload.
please help on this, actually, the code is:
$SiteUrl = "https://SiteName"
$ListName = "Contacts"
$CSVPath = "Folder Path"
#Get he CSV file contents
$CSVData = Import-CsV -Path $CSVPath
#Connect to site
Connect-PnPOnline $SiteUrl
#Iterate through each Row in the CSV and import data to SharePoint Online List
ForEach ($Row in $CSVData)
{
Write-Host "Adding Contact $($Row.FirstName)"
$NewDate = (Get-Date).tostring("yyyyMMdd")
#$NewDate = [datetime]::parseexact($NewDate,'dd/MM/yyyy HH:mm',$null)
# [datetime]::parseexact($NewDate, 'dd-MMM-yy', $null).ToString('yyyy-MM-dd')
#Add List Items - Map with Internal Names of the Fields!
Add-PnPListItem -List $ListName -Values @{"FirstName" = $($Row.FirstName);
"LastName" = $($Row.LastName);
"Department"=$($Row.Department);
"Mobile" = $($Row.Mobile);
"Person" = $($Row.Person);
"MultilineText"=$($Row.MultilineText);
"Choice" = $($Row.Choice);
"StartDate" = $($Row.StartDate);
};
}
Error: Add-PnPListItem : String was not recognized as a valid DateTime.