Answered

Collect from Combobox into gallery

(0) Share

Report

Posted on by GS99

Hi,

So I am using a combobox with microsoft users as a data source, I then need to make a collection from those users but only collecting their name, location and email columns. I then have to use the collection as a data source for a gallery. I have done the above but when I select more than one person from the combobox it only puts one person in the gallery. I need to fill a new gallery item for every person selected. This is what I have done for the onselect property of the button:

Any help would be much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Prabhakar_S 735 Moderator on at

Like (0)

Report
Hi @GS99 ,

Please try this formula to display the multiple items selected in a combo box,

Concat(ComboBox1.SelectedItems, Value & " ")

Thanks!!!

If my response has been helpful in resolving your issue, I would suggest you consider clicking "Accept as solution" and "Give it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
GS99 6 on at

Like (0)

Report

Hi, I am able to fill the collection and gallery by simply using .SelectedItems, the issue is that my task is to only collect the 3 columns I mentioned. When I try to do that, I use selected.DisplayName... etc and it only shows one of the selected items rather than all of them. I understand I can use SelectedItems but thats not quite what my task is

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Hi @GS99,

You can loop through the selected items and use the Collect() function:

Clear(col_info); ForAll( ComboBox1.SelectedItems, Collect( col_info, {DisplayName: ThisRecord.DisplayName, City: ThisRecord.City, Mail: ThisRecord.Mail} ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
GS99 6 on at

Like (0)

Report

That makes sense.... Thank you!

Was this reply helpful? Yes No