web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Excel filter style of ...
Power Apps
Answered

Excel filter style of independent dropdown(or combobox)

(0) ShareShare
ReportReport
Posted on by 38

Hello Microsoft Community,

 

I am creating my app via the below link's advice but the app does not show any item on the each dropdown.

 

https://powerusers.microsoft.com/t5/Building-Power-Apps/Excel-filter-style-of-independent-dropdown-or-combobox/m-p/2062870#M515798

 

I tried to change the SharePoint List column to Text value but still not working.

Can anyone help with this?

Categories:
  • Verified answer
    SolTeferi Profile Picture
    on at

    Hi @caligame ,

     

    Please try the following on the items property of each of the dropdowns/comboboxes. This will filter out each dropdown/combobox based on the other two. It will show all items if nothing is selected on the other two:

    Filter( YourdataSource, (Type= YourOtherComboBox1.Selected.Type Or IsBlank(YourOtherComboBox1.Selected)) && (color = YourOtherComboBox2.Selected.color Or IsBlank(YourOtherComboBox2.Selected)) )

    For the other two dropdowns/comboboxes, you may need to change the "Type and Color" to "Car and Color" and "Car and Type". Make sure the spellings of the column names exactly match yours.

  • SolTeferi Profile Picture
    on at

    Hi @caligame ,

     

    The previous solution I gave you is fine. But, to make sure you don't see any possible circular reference error, please consider using the following. Below I provided the complete solution for all comboboxes. Just make sure you replace the datasource and the column names (car, Type and color) with the exact names as per your datasource. You don't have to change varCombo1, varCombo2, varCombo3. These are just variable names used to help avoid circular reference errors.

     

    On the items property of combo 1:

    Filter(YourDataSource,(Type=varCombo2 Or IsBlank(varCombo2)) && (color=varCombo3 Or IsBlank(varCombo3) ))

     

    On the items property of combo 2:

    Filter(YourDataSource,(car=varCombo1 Or IsBlank(varCombo1)) && (color=varCombo3 Or IsBlank(varCombo3)) )

     

    On the items property of combo 3:

    Filter(YourDataSource,(Type=varCombo2 Or IsBlank(varCombo2)) && (car=varCombo1 Or IsBlank(varCombo1) ))

     

    On the OnChange property of combo 1:

    If(!IsBlank(Self.Selected), UpdateContext({varCombo1:Self.Selected.car}), UpdateContext({varCombo1:Blank()}))

     

    On the OnChange property of combo 2:

    If(!IsBlank(Self.Selected), UpdateContext({varCombo2:Self.Selected.Type}), UpdateContext({varCombo2:Blank()}))

     

    On the OnChange property of combo 3:

    If(!IsBlank(Self.Selected), UpdateContext({varCombo3:Self.Selected.color}), UpdateContext({varCombo3:Blank()}))

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard