ComboBox: Filter for multiple specific choices

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey everybody,

I have a ComboBox (2nd) with several choices. I want to filter these choices if another the selection of the ComboBox (1st) equals "No"
If "No" is selected in the 1st ComboBox I want to filter three exact choices in the 2nd ComboBox so the user can choose from these.

I managed to filter for one exact choice with:

If(
 DataCardValue6.Selected.Value = "Nein",
 Filter(
 Choices(musterkunden_anrufen_app.Gründe),
 Value = "Falsche Rufnummer"
 )

Is there a way to achieve this?

By the way the Item of my ComboBox is my sharepoint list "musterkunden_anrufen_app" with the column called "Gründe" (engl.: "reasons"). The latter is a choice column that allows multiple selections.

Happy for any suggestions. Thanks in advance

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Ok, I found a solution. To filter for several exact choices I used this:
If( DataCardValue6.Selected.Value = "Nein", Filter( Choices(musterkunden_anrufen_app.Gründe), Value = "Falsche Rufnummer" || Value = "Aufgelegt" || Value = "Nicht erreicht" )
Just place || inbetween your choices that you want to filter.