Filter ComboBox Results

(2) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I have ComboBox_1.

The list in ComboBox_1 should be based on choices made in three other ComboBoxes.

I have tried to write a formula that returns results that ONLY associate with the three fields in the formula.

I am getting a list in the CombBox but it is all Complex Names in the SPList rather than ONLY those that
apply to the choices made.

What am I missing?

ComboBox_1 DefaultSelectedItems -
        Filter(
            col_Event_Data_Collection,
            Title = CNE_Attraction_Name_ComboBox.Selected.Value &&
            Show_Name = Show_Name_ComboBox.Selected.Show_Names &&
            Venue_Name = Venue_Name_ComboBox.Selected.Venue_Name 
        ,
        Complex_Name
    )

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,360 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Phineas

I do not understand what you have written here. Why do you have a , (comma) and then Complex_Name. I am surprised you don't get an error in the syntax.

Filter( col_Event_Data_Collection, Title = CNE_Attraction_Name_ComboBox.Selected.Value && Show_Name = Show_Name_ComboBox.Selected.Show_Names && Venue_Name = Venue_Name_ComboBox.Selected.Venue_Name , Complex_Name )

If you had written

Filter(
col_Event_Data_Collection,
Title = CNE_Attraction_Name_ComboBox.Selected.Value &&
Show_Name = Show_Name_ComboBox.Selected.Show_Names &&
Venue_Name = Venue_Name_ComboBox.Selected.Venue_Name

)

I would have understood it. Something is missing

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 4,983 Super User 2025 Season 2 on at

Like (0)

Report
@Phineas,

Hi, I have doubt in the property which you are being mapping

(for e.g., Show_Name is mapped to Selected.Show_Names and Venue_Name as Selected.Venue_Name however Title  as Selected.Value whether this also needs to replaced as Selected.Title) can you please check on this.

Filter(Table*, Formula1 [, *Formula2*, ... ] )

This is the syntax, I doubt that filter query which you written seems to be incorrect.

Filter(

  col_Event_Data_Collection,

Title = CNE_Attraction_Name_ComboBox.Selected.Value &&

Show_Name = Show_Name_ComboBox.Selected.Show_Names &&

Venue_Name = Venue_Name_ComboBox.Selected.Venue_Name

  ,

Complex_Name

  )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No