1

Is there a method to take the contents of multiple multi-value person columns from SharePoint and convert it to one collection of individual values (one record per person) in PowerApps?

I believe I can leverage Split and Collect to achieve this, but am having trouble with the exact syntax to follow. Or does PowerApps automatically convert these columns to a table anyways and I'm overthinking it?

For testing, I have a form showing 3 multi-value person columns I want to pull info from and combine into a collection. On clicking a button the action below is taken and results are shown in a gallery whose datasource is this collection.

ClearCollect(Participants, 
{Name: Value(Approver_DataCard1.DisplayName)}, 
{Name: Value(Reviewers_DataCard1.DisplayName)}, 
{Name: Value(Informed_DataCard1.DisplayName)})

So far, no luck. It creates 3 blank records. Even if it did work am not sure how I would pull additional user information; email, organization, etc.

enter image description here

  • Can't seem to find a way to get comma delimited output. There has to be a way to extract this data. If I use a listview control instead of a datacard I can also view the names, but I can't extract. Everything only returns the first item in a multi-value control. – BDC604 Jun 2 '18 at 12:15
  • In what format do you have the data in the inputs? It's blurred and it's hard to tell. It does not look like a User Picker Data card. What are you using for inputting user names? – Denis Molodtsov Jun 2 '18 at 19:46
1

I've just managed to implement your example. Check it out:

OnSelect property of the Collect button:

Clear(Participants); 
Collect(Participants,DataCardValue19.SelectedItems);
Collect(Participants,DataCardValue20.SelectedItems)

Note: DataCardValue19 and DataCardValue20 correspond ot the "Reviewers" and "Informed" multiselect user pickers.

Items property of the ListBox:

Participants.DisplayName

enter image description here

enter image description here

  • 1
    Works perfectly! – BDC604 Jun 4 '18 at 0:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.