How to Filter Power Apps Gallery By Multiple Dropdowns?

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.

Example:

• 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
Category	Choice
Month	Choice
Amount	Number
Budget	Choice

• 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
)

Where,

1. ‘Monthly Budget Expenses’ = SharePoint Online List
2. 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
)

Where,

1. drp_Month.Selected.Value = Power Apps 1st Dropdown Control Name
2. drp_Category.Selected.Value = Power Apps 2nd Dropdown Control Name
3. 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.

Conclusion

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