Skip to main content

I'm building a New Responsive Form in SharePoint Online. I need to combine multiple people picker controls (one user each) into one single people picker list column. The combined column does not need to be visible on the form. I can do it in a workflow, but I would have to replicate the same "Set Field" Action in multiple places.  So, I'd rather have the form handle it.

 

I've tried several different variations of this basic approach:

  • Create a text variable from the individual "People picker" controls, then use a rule to set the connected multi- people picker from the Text variable. This works when there are only two fields filled, but when the third is added, the second one gets lost.
  • Create a text variable from the individual "People picker" controls, then use a rule to set a Text control connected to the "Person or Group" column. I've tried multiple userid formats, semicolon in between, comma, space.  I can't find a combination where this will save directly to the Person or Group column.

 

Hopefully I just haven't found the right combination to make this work. Thanks for any solutions or suggestions of other options to try.

Hi @Jeremy_too 



 



Form: New Responsive Form



Platform: Forms for O365



 



1. Create a Form with 4 People Picker. (Note: Control name is same as Title).



People1-3 control is set to single selection. PeopleCombo is set to multiple selections





2. Create Rule to set value for PeopleCombo



If part omitted (the rule conditions up to you). Here is the Then part.







You need the ';#' to separate the entries. User1;#User2;#User3



 



Credit to @MillaZ for the following article



Setting People Picker default value for multiple e... - Nintex Community 



 



Cheers



 



 



 



 


Perfect, thank you @Garrett .  ';#'  was the missing piece.   I'm not sure why I wasn't able to find the original post from @MillaZ  .


Reply