Have you ever worked with the Power Apps filter gallery by multiple dropdowns? No worries!
This Microsoft Power Apps tutorial helps you learn about how to filter Power Apps gallery by multiple dropdowns with various examples.
Also, we will discuss how to add multiple dropdown controls in the Power Apps and how to filter a Power Apps gallery by multiple dropdowns.
How to Filter Power Apps Gallery By Multiple Dropdowns
Here, I will show you how to filter a Power Apps gallery by multiple dropdowns.
- I have a SharePoint Online List named “Monthly Budget Expenses“. This list contains the below fields.
|Column Name||Data Type|
|Item||This is a default single line of text, I just renamed it to “Item”|
|Description||Multiple lines of text|
- In Power Apps, there are three Dropdown controls and a Gallery control. This gallery displays each record from the SharePoint Online list based on three dropdowns selected values.
Refer to the below screenshot:
To achieve the above example, follow the below-mentioned steps. Such as:
- Open the Power Apps with your respective Microsoft credentials -> Create Power Apps Canvas app -> Connect the SharePoint list, i.e., [Training Courses Demos] to the app. Once you connect, it will look like the screenshot below.
- Insert three Dropdown controls, i.e., [drp_Month, drp_Category, and drp_Budget] and set its Items properties as:
Items = Distinct( 'Monthly Budget Expenses', //For Month Value Month.Value ) Items = Distinct( 'Monthly Budget Expenses', // For Category Value Category.Value ) Items = Distinct( 'Monthly Budget Expenses', // For Budget Value Budget.Value )
- ‘Monthly Budget Expenses’ = SharePoint Online List
- Month, Category, Budget = SharePoint Choice Fields
- Next, insert a Gallery control and set its Items property to the code below.
Items = Filter( 'Monthly Budget Expenses', Month.Value = drp_Month.Selected.Value, Category.Value = drp_Category.Selected.Value, Budget.Value = drp_Budget.Selected.Value )
- drp_Month.Selected.Value = Power Apps 1st Dropdown Control Name
- drp_Category.Selected.Value = Power Apps 2nd Dropdown Control Name
- drp_Budget.Selected.Value = Power Apps 3rd Dropdown Control Name
- Save, Publish, and Preview the app. The gallery will display the filtered records, i.e., [September Month Records] based on the three selected dropdown values as in the screenshot below.
This is how to filter a Power Apps gallery by multiple dropdowns.
From this Microsoft Power Apps tutorial, we learned all about the Power Apps filter gallery by multiple dropdowns.
Here, we discussed how to add multiple dropdown controls in the Power Apps and how to filter a Power Apps gallery by multiple dropdowns.
Also, you may like some more Power Apps tutorials:
- Power Apps Filter Gallery By Date
- Power Apps Filter Gallery By Week
- Power Apps Filter Gallery By Year
- Power Apps Filter Gallery By Month
- Bind Power Apps Dropdown Control From SharePoint Yes No Column
- Bind Power Apps Dropdown Items From Collection
Preeti Sahu is an expert in Power Apps and has more than 6 years of experience working with SharePoint and the Power Platform. As a Power Platform expert for Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages, she is currently employed with TSinfo Technologies. She is the author of the book Microsoft Power Platform A Deep Dive. She also made a big technical contribution to SharePointDotNet.com in the form of articles on the Power Platform. She enjoys traveling and spending time with her family in her spare time.