Forum Discussion

Copper Contributor

Feb 15, 2019

Set-PnPListItem - Multiple User Field

Hey Folks, Trying to update a List item via PowerShell, the column is a multiple user field. The updated users are currently in an array of Email Addresses which is causing an error. Wonderi...

Iron Contributor

Feb 18, 2019

Hi Blair,

An array of email addresses is definitely supported.

I just tested this out passing in an array of email address strings and it worked fine. Here's the exact syntax:

$users = "user@contoso.com", "user2@contoso.com"

Connect-PnPOnline -Url https://contoso.sharepoint.com

Set-PnPListItem -List "test1" -Identity 1 -Values @{"TestPeopleMulti"=$users}

This updated the user-multi field with both users.

Blair24

Copper Contributor

Feb 18, 2019

Hi Thomas,

Yeah I've done it before, my script below is still causing an error:

    $salesmangers = $ListItem.SalesManager.Email
    $salesmangers += $newmanager
    $newlistofmanagers = $salesmangers | Where-Object { $_ –ne $currentmanger }

Set-PnPListItem -List $customerlistID -Identity $ListItem.ID -Values @{"SalesManager" = $newlistofmanagers}

Thomas Berman
Iron Contributor
Feb 18, 2019
What error are you getting and where is it failing?

Also, to access that field, try $salesmangers = $ListItem.FieldValues.SalesManager.Email
- Blair24
  Copper Contributor
  Feb 19, 2019
  Error is:
  Set-PnPListItem : The specified user could not be found.
  
  Line:
  Set-PnPListItem -List $customerlistID -Identity $ListItem.ID -Values @{"SalesManager" = $newlistofmanagers}
  
  Swapping to FieldValues.SalesManager.Email made no difference either.
  - Thomas Berman
    Iron Contributor
    Feb 19, 2019
    Try checking your $newlistofmanagers before passing it into Set-PnPListItem, and check $newmanager to make sure they look right.
    
    Something must be going wrong somewhere along the line of building that array, since an array of valid email addresses will work with that cmdlet no problem.