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 / Filter gallery by mult...
Power Apps
Answered

Filter gallery by multiple drop downs.

(0) ShareShare
ReportReport
Posted on by 221

I would like to filter my gallery by 3 different dropdowns. 

 

Each of these dropdowns are connected to lists and are used as lookup fields in the gallery data. 

 

 

 

Categories:
I have the same question (0)
  • SimnaJ Profile Picture
    205 on at

    To filter a gallery by three different dropdowns, you can use the Filter function with the And operator to combine the three filter conditions. Here is an example formula that filters a gallery based on three dropdowns (named Dropdown1, Dropdown2, and Dropdown3), assuming that the Items property of the gallery is connected to a SharePoint list:
    Filter(MySharePointList,
    LookupField1.Value = Dropdown1.Selected.Value &&
    LookupField2.Value = Dropdown2.Selected.Value &&
    LookupField3.Value = Dropdown3.Selected.Value)
    Replace MySharePointList with the name of your SharePoint list and LookupField1, LookupField2, and LookupField3 with the names of the lookup fields in your list that correspond to the dropdowns.

    This formula filters the gallery to show only the items where the value in LookupField1 matches the selected value in Dropdown1, the value in LookupField2 matches the selected value in Dropdown2, and the value in LookupField3 matches the selected value in Dropdown3. The && operator is used to combine the conditions with an "and" logic.

    If you feel that my response has helped you, please consider giving it a thumbs up and please mark it as the solution. This will help other community members find the solution quickly if they have a similar issue in the future.

  • EMA03356 Profile Picture
    221 on at

    I currently have a search function used to find other text that isn't in the drop down. How would I go about combining them to use both? 

     

    If(SearchBox_1.Text="",LastN('Engineering Simulations',1000),Search('Engineering Simulations',SearchBox_1.Text,"CustomerName","InquiryNumber","ProductItem","PPM","CPM"))&&


    Filter(MySharePointList,
    'Platform List'.Value = Dropdown3_1.Selected.Value &&
    'Infeed Functions'.Value = Dropdown4_2.Selected.Value &&
    'Main Functions'.Value = Dropdown4_3.Selected.Value)

  • SimnaJ Profile Picture
    205 on at

    Here is an example formula that combines your existing formulas:

     

    Filter( If(SearchBox_1.Text="", LastN('Engineering Simulations', 1000), Search('Engineering Simulations', SearchBox_1.Text, "CustomerName", "InquiryNumber", "ProductItem", "PPM", "CPM")), 'Platform List'.Value = Dropdown3_1.Selected.Value && 'Infeed Functions'.Value = Dropdown4_2.Selected.Value && 'Main Functions'.Value = Dropdown4_3.Selected.Value )

     

    This formula first checks if the SearchBox_1 is empty or not. If it's empty, it displays the last 1000 items from the 'Engineering Simulations' SharePoint list. Otherwise, it filters the list based on the search criteria using the Search function.

     

    Then, the formula filters the same list based on the selected values in Dropdown3_1, Dropdown4_2, and Dropdown4_3 using the And operator. Replace 'Platform List', 'Infeed Functions', and 'Main Functions' with the actual names of the lookup fields in your SharePoint list.

     

    I hope this helps! If you find this answer helpful, please consider giving it a thumbs up and mark it as the solution.

  • EMA03356 Profile Picture
    221 on at

    My dropdowns default to options in the list. How can I make that cleared out to prevent it from picking something right away? 

  • Verified answer
    SimnaJ Profile Picture
    205 on at

    To prevent a default selection in a dropdown, you can set the Selected property to null or Blank(). Here's an example of how to set the default selection to null in PowerApps:

    Select the dropdown control that you want to modify.
    In the right-hand pane, find the "Selected" property under the "Advanced" section.
    Set the value of the "Selected" property to null.
    Alternatively, you can set the default selection to an empty string using the Blank() function. Here's how to do it:

    Select the dropdown control that you want to modify.
    In the right-hand pane, find the "Default" property under the "Data" section.
    Set the value of the "Default" property to Blank().
    Setting the default selection to null or Blank() will ensure that the dropdown does not have a default selection when the app is opened.

    If you feel that my response has helped you, please consider giving it a thumbs up and please mark it as the solution. This will help other community members find the solution quickly if they have a similar issue in the future.

  • EMA03356 Profile Picture
    221 on at

    This is not working on my end I get both of these errors. 

     

    EMA03356_0-1680726020636.png

    EMA03356_1-1680726048293.png

     

    My main gallery has three columns that are lookups from other lists. Those other lists are what I'm using in the dropdown. 

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard