Answered

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

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
dalgi24 12 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No
dalgi24 12 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No