Select All for a Multi-select combobox field in Power Apps with Filter values

Like (0) Share

Report

Posted on 9 Nov 2022 01:44:41 by dalgi24

I have a combo box that displays a list of values filtered by another combo box.

I want that when the user checks a box all default values are selected but considering the filter.
Currently the Choices statement works in the DefaultSelectedItems property but I need the values to be filtered

Can somebody help me please?

Thank you!

Categories:

Using Apps Using Formulas

All responses (4)

Answers (1)

dalgi24 12 on 10 Nov 2022 at 19:30:57

Like (0)

Report

Re: Select All for a Multi-select combobox field in Power Apps with Filter values

Thank you very much v-qiaqi-msft!

the formula works for me... Only now when saving the information is not stored, modify the update property with the same instruction
Verified answer

v-qiaqi@microsoft.com on 10 Nov 2022 at 01:43:58

Like (0)

Report
Re: Select All for a Multi-select combobox field in Power Apps with Filter values

Hi @dalgi24，

Hope you could try the formula I provided and check if it works on your side.

Just replace the Option column with the column you want to populate the Combo Box with:

ForAll(Sort(Filter(Usuarios,'Tipo de Usuario'.Value=Dropdown1.Selected.Value);'Nombre({Name})'),Option)
dalgi24 12 on 09 Nov 2022 at 13:46:13

Like (0)

Report

Re: Select All for a Multi-select combobox field in Power Apps with Filter values

Hi v-qiaqi-msft,

What I want is that the same thing that I have in the Item property works for the DefaultSelectedItems property, I need them to appear selected but with the filter applied.

Best Regards
v-qiaqi@microsoft.com on 09 Nov 2022 at 03:22:57

Like (0)

Report
Re: Select All for a Multi-select combobox field in Power Apps with Filter values

Hi @dalgi24,

Do you want to filter the items from Choices() function based on the Sort() function?

Modify as below:

ForAll(Sort(Filter(Usuarios,'Tipo de Usuario'.Value=Dropdown1.Selected.Value);'Nombre({Name})'),Option)

In addition, I have found that you have different data source to populate the Combo Box in the DefaultSelectedItems property, however the data source should be the same one between the Items property and DefaultSelectedItems property.