Filter gallery by multiple drop downs.

(0) Share

Report

Posted on by EMA03356

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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

SimnaJ 205 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
EMA03356 221 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
SimnaJ 205 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
EMA03356 221 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

SimnaJ 205 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
EMA03356 221 on at

Like (0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No