Power Apps Combo Box Filter Gallery [With Real Examples]

Did you have a requirement to filter a gallery based on a Combo box control in Power Apps? Keep reading: In this Power Apps tutorial, I will explain “Power Apps Combo Box Filter Gallery.”

Moreover, I will show you how to filter a Power Apps gallery based on the combo box selected value.

Also, we will see how to use multiple combo box controls to filter gallery with a simple scenario and many more like:

1. Power Apps filter gallery based on combo box multiple selected items.
2. Power Apps filter gallery using a combo box that allows multiple selections.

Power Apps Combo box filter gallery

Let’s see how to filter a Power Apps gallery based on the combo box with a simple scenario:

I have a SharePoint Online list [Loan Approval], that has various columns like:

Column Name	Data Type
Name	It is a default title column, I just renamed it as “Name”
Country	Lookup
Loan Type	Choice [“Car Loan”, “Home Loan”, “Gold Loan”]
Loan Applied Date	Date and time
Approved or Not	Yes/No
Loan Handled By	Person or group
Eligibility Provided	Choice [“Passport”, “Utility Bill”, “Voter registration card”]

On my Power Apps screen, I have added a Combo box control and a Gallery control. The combo box is connected to a SharePoint list column [Country]. Whenever a user selects any value from the combo box control, the gallery filters and displays the respective records.

Follow the below steps to achieve this:

• Create a Blank canvas app -> Connect to the SharePoint Online list -> Once you connect, it will appear under the Data section as shown below:

• On the Power Apps screen, insert a Combo box control -> Set its Items property to:

Distinct('Loan Approval',Country.Value)

Where,

1. Loan Approval = SharePoint list name
2. Country = SharePoint list column name

• Now, we want to display the SharePoint list records based on the combo box selected value. For that, insert a Gallery control -> Set its Items property to:

Filter(
    'Loan Approval',
    IsBlank(cmb_Country.SelectedItems.Value) || IsEmpty(cmb_Country.SelectedItems.Value) || Country.Value = cmb_Country.Selected.Value
)

Where,

1. Loan Approval = SharePoint list name
2. cmb_Country = Combo box control name
3. Country = SharePoint list column name

• Once your app is ready, just Save, Publish, and Preview the app. When the user selects any value from the combo box control, the gallery will filter and display all records based on the combo box selected value.

This is how to filter a gallery control based on the combo box selected value in Power Apps.

Power Apps filter gallery with multiple Combo box

In this section, I will explain how to gallery control based on multiple combo box values.

My Power Apps screen has two Combo box controls and a Gallery control. The first combo box is connected to the SharePoint list choice column. Then, the other combo box is connected to the same above SharePoint list person column [Loan Handled By].

Whenever a user selects a value from both combo box controls, the gallery control filters and displays only the data that matches both the selected items from the combo box controls, as shown below:

To work around this, follow the below-mentioned steps:

• On the Power Apps screen, insert a First Combo box control -> Set its Items property to:

Distinct('Loan Approval','Loan Type'.Value)

Where,

1. Loan Approval = SharePoint list name
2. Loan Type = SharePoint list choice column name

• Next, insert the second Combo box control -> Set its Items property to:

Distinct('Loan Approval','Loan Handled By')

Where,

1. Loan Approval = SharePoint list name
2. Loan Handled By = SharePoint list person column name

• Now, we want to display the SharePoint list records based on both combo box selected values. For that, insert a Gallery control -> Set its Items property to:

Filter(
    'Loan Approval',
    (cmb_LoanType.Selected.Value in 'Loan Type'.Value && cmb_LoanHandledBy.Selected.Value in 'Loan Handled By')
)

Where,

1. Loan Approval = SharePoint list name
2. cmb_Loan Type = 1st Combo box control name
3. Loan Type = SharePoint list choice column name
4. cmb_LoanHandledBy = 2nd Combo box control name
5. Loan Handled By = SharePoint list person column name

• Save, Publish, and Preview the app. When the user selects a value from both combo box controls, the gallery will filter and display the data that satisfies both combo box selected items.

This is how to filter a gallery with multiple combo boxes in Power Apps.

Power Apps filter gallery based on Combo box multiple selected items

I will show you how to filter a Power Apps gallery based on the multiple selected items from the combo box control.

The Power Apps screen has a Combo box control and a Gallery control. The combo box is connected to the above SharePoint list choice column [Loan Type].

Whenever a user selects multiple values from the combo box controls, the gallery filters and displays the records based on the multiple selected values of the combo box controls.

Follow the below steps to achieve this:

• On the Power Apps screen, insert a Combo box control -> Set its Items property to:

Choices('Loan Approval'.'Loan Type')

Where,

1. Loan Approval = SharePoint list name
2. Loan Type = SharePoint list choice column name

• On the combo box properties pane, enable the toggle switch for Allow Multiple selection as shown below:

• Now, we want to display the SharePoint list records based on multiple combo box-selected values. For that, insert a Gallery control -> Set its Items property to:

Filter(
    'Loan Approval',
    IsBlank(cmb_MultipleLoanType.SelectedItems.Value) || IsEmpty(cmb_MultipleLoanType.SelectedItems.Value) || 'Loan Type' in cmb_MultipleLoanType.SelectedItems
)

Where,

1. Loan Approval = SharePoint list name
2. cmb_MutipleLoanType = Combo box control name
3. Loan Type= SharePoint list choice column name

• Save, Publish, and Preview the app. When the user selects multiple values from the combo box control, then the gallery will filter and display the records based on multiple selected values.

This is how we can filter the Power Apps gallery based on the multiple selected items from the combo box control.

Power Apps filter gallery using a combo box that allows multiple selections

Here, I will show you how to filter the Power Apps gallery using a combo box that allows multiple selections.

As per my above SharePoint list [Loan Approval], I have a choice column [Eligiblity Provided] that allows multiple values.

Now, In my Power Apps screen, there is a Combo box control that is connected to the above SharePoint list choice column [Eligiblity Provided].

Whenever a user selects multiple values from the combo box control, the gallery should filter based on a SharePoint list of records that have multiple values and display the relevant records.

To achieve it, follow the below steps:

• On the Power Apps screen, insert a Combo box control -> Set its Items property to:

Choices('Loan Approval'.'Eligibility Provided')

Where,

1. Loan Approval = SharePoint list name
2. Eligibility Provided = SharePoint list choice column name

• Now, we want to display the SharePoint list records based on multiple combo box-selected values. For that, insert a Gallery control -> Set its Items property to:

Filter(
    'Loan Approval',
    Concat(
        cmb_Eligibility.SelectedItems,
        Value,
        ","
    ) in Concat(
        'Eligibility Provided',
        Value,
        ","
    )
)

Where,

1. Loan Approval = SharePoint list name
2. cmb_Eligibility = Combo box control name
3. Eligibility Provided= SharePoint list choice column name

• Save, Publish, and Preview the app. When the user selects multiple values from the combo box control, then the gallery will filter and display the relevant records based on multiple selected values.

This is how we can filter the Power Apps gallery using a combo box that allows multiple selections.

Conclusion

I hope this tutorial provided complete information about the Power Apps Combo box filter gallery. We can use the Filter() function to achieve it.

In this Power Apps tutorial, we have learned how to filter a Power Apps gallery using a combo box selected value with a complete example.

Lastly, we will see how to use multiple combo box controls to filter gallery with a simple scenario and many more like:

1. Power Apps filter gallery based on Combo box multiple selected items
2. Power Apps filter gallery using a combo box that allows multiple selections

You may also like:

• Reset Combobox in Power Apps
• How to Populate Distinct Values in Power Apps Combo Box?
• Power Apps Combo Box Sort
• Power Apps check if a Combo box is empty