Unanswered

how to allow combobox multiple selection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,
I am a new intern in my company, and I was asked to make changes to one of their already existing apps on Power Apps. I don't have much experience and their app is already very complete so it's hard for me to understand all the logic. Thank you in advance for your help.
I need to modify the existing filters so that they can allow multiple selection. One of the filters is for example "Investment Reason" and the values are "01 Capacity", "02 Productivity", "03 Quality", "04 New Products"...
In the "SelectMultiple" parameter I changed it to 'true', and I can actually select multiple criteria. But when I select for example Capacity and Productivity, Productivity overwrites Capacity and I only have results with Productivity. What can I do to have both criteria?
For information :
- we use SharePoint tables
- the Items of the combobox are values: ["01 Capacity", "02 Productivity", "03 Quality", "04 New Products",...]
- DisplayFields / searchFields = ["Value"]
- The results are displayed in a gallery and Gallery.Items = RequestsCollection (collection in which is listed the "Investment_Objectif" table whose values are "01 Capacity", "02 Productivity", "03 Quality", "04 New Products". ..)

Capture d’écran 2022-08-01 à 09.46.09.png

Capture d’écran 2022-08-01 à 09.46.31.png

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Could you please share the formula that is there on Items property of the gallery.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I don't know how to explain correctly, so I will show you :

The gallery items category is actually a collection. In the collection, we find the category 'investment_objective' then when we click on the table, the investment category appears such as productivity
RusselThomas 4,014 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,
Coming into an app someone else built is never easy - doing it without much experience is even harder, as every answer to a question usually results in 100 other questions - so I'll try answer your question as completely as I can. If your current question is answered but you have more questions, it's usually best to post them as new so others can find them and benefit from the answers as well.

So, three things;
First, on the combo itself is a property "SelectMultiple" - set this to true to allow multiple selections.
Secondly - if this was previously set to false, this meant any references to the selected combo item may have been using Combobox.Selected - by making it true you are turning the result into a table of selected records instead of a single record - meaning you may have to go and change references to the combo as a result of changing this.
Third - it seems like the combos were used to filter the gallery - meaning the gallery filter function will need to change in order to adapt to a multi-select option on the combos. Combination filtering is complicated, even for people with experience. There are a lot of factors to consider and the nature of the filter plays a big part. The first question is - are these filters subsequent? Meaning, are they applied, in order, to the current results - i.e. do you filter by combo1 first, then apply the filter of combo2 to combo1's results - or do you apply the combo1 and combo2's filters to the data at the same time?
So, your formulae may change depending on your intended experience, but essentially if you look at what is there currently you need to adapt it for multi-select. Obviously I don't know what you have currently, but as an example the logic could be applied as follows;
Let's say your current gallery Items: property had a filter like this;
Filter(RequestsCollection, Capacity=CapacityCombo.Selected.Value, Productivity=ProductivityCombo.Selected.Value, ....and so on )
if you change your combos, then your gallery filter might look like this;
Filter(RequestsCollection, Capacity in CapacityCombo.SelectedItems.Value, Productivity in ProductivityCombo.SelectedItems.Value, ....and so on )
again, how this will look will depend a lot on a) what's there already and b) what experience you're trying to create.
Hope this helps,
RT
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hey @RusselThomas,
Thank you for taking the time to answer me, I'm starting to understand a little better. However, here is my problem: the thing is that the Items of my gallery is just RequestsCollection and meets several criteria: factories, budget, investment reason... so I don't see how I can modify the gallery without everything disturb. Especially since the filters only apply to the categories reason for investment, factories and sub-programs. I hope you understand my problem... I posted just above the screenshots of my controls and collection, and I put an image of how my gallery is laid out for you to see.
thanks again,
Emilie