Set-PnPListItem - Multiple User Field

Question

Hey Folks,&nbsp;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.&nbsp;Wondering if anyone knows how I could easily convert this to a string or if there's a workaround?&nbsp;Thanks!

thomas berman · Answer

What exactly are you trying to do with the Where-Object? Are you basically looking to remove an email address that matches "$currentmanager" from that array before adding it to the List Item?&nbsp;Try this:&nbsp;$newlistofmanagers = @()
    foreach ($manager in $salesmanagers)
    {
        if ($manager -ne $currentmanager)
        {
      $newlistofmanagers += $manager                }
    }Set-PnPListItem -List $customerlistID -Identity $ListItem.ID -Values @{"SalesManager" = $newlistofmanagers}&nbsp;&nbsp;

thomas berman · Answer

Hi Blair,&nbsp;An array of email addresses is definitely supported.&nbsp;I just tested this out passing in an array of email address strings and it worked fine. Here's the exact syntax:&nbsp;$users = "user@contoso.com", "user2@contoso.com"Connect-PnPOnline -Url https://contoso.sharepoint.com&nbsp;Set-PnPListItem -List "test1" -Identity 1 -Values @{"TestPeopleMulti"=$users}&nbsp;This updated the user-multi field with both users.&nbsp;

blair24 · Answer

Hi Thomas,Yeah I've done it before, my script below is still causing an error:&nbsp;&nbsp;&nbsp;&nbsp; $salesmangers = $ListItem.SalesManager.Email&nbsp;&nbsp;&nbsp; $salesmangers += $newmanager&nbsp;&nbsp;&nbsp; $newlistofmanagers = $salesmangers | Where-Object { $_ –ne $currentmanger }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set-PnPListItem -List $customerlistID -Identity $ListItem.ID -Values @{"SalesManager" = $newlistofmanagers}&nbsp;&nbsp;

thomas berman · Answer

What error are you getting and where is it failing?&nbsp;Also, to access that field, try&nbsp;$salesmangers = $ListItem.FieldValues.SalesManager.Email

blair24 · Answer

Error is:&nbsp;Set-PnPListItem : The specified user&nbsp; could not be found.&nbsp;Line:&nbsp;Set-PnPListItem -List $customerlistID -Identity $ListItem.ID -Values @{"SalesManager" = $newlistofmanagers} &nbsp;Swapping to FieldValues.SalesManager.Email made no difference either.

Forum Discussion

Set-PnPListItem - Multiple User Field

Share

Resources