Jul 14 2020 06:19 AM
Hello
I want to run a script that reads a csv and updates peoplepicker.
My code looks like:
$delimitercsv = "|" $filePath = "File.csv" $CSVData = Import-CSV -path $filepath -Delimiter $delimitercsv
$costcenter = "costcenter"
$userid = "User ID"
$useremailowner = "Owner"
$websitedirectory = Get-SPWeb -identity "website" $list = $websitedirectory.Lists["Site Directory"]
#Iterate through each row in the CSV and update the Owner Email
$items = $list.Items
foreach($item in $items | get-member -MemberType ‘NoteProperty’ | Select-Object -ExpandProperty ‘Name’) { $userid = $item['User ID'] $useridtest = $userid -replace ".*#" [Microsoft.SharePoint.SPUser]$useremail = $CSVData | Where-Object {$_.UsID -eq $userid} | % UsID $item[$useremailowner] = domain\$userid $item.Update(); }
Unfortunately it does not work.
Do you have any idea?
Regards and big thanks
JFM_12