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.