We need to insert a bulk data from MS Excel into SharePoint lists. We committed this using Powershell. Almost everything straightforward, until we found a stoper with People columns.
From Excel people info are comming something like:
Claire@mycompany.com, but SharePoint requires a valid
If I tried this: (it fails)
$item["MyPerson"] = $excelRow.MyPerson # this not works because is an Email.
I need something like:
$userValue = FindUserValueByEmail -email $excelRow.MyPerson $item["MyPerson"] = $useValue