How to Filter List Box in Power Apps? [With Examples]

In this Power Apps article, I will show you how to filter the list box in Power Apps. Additionally, we will discuss how to filter a gallery with multiple list boxes.

In addition, we will learn how to filter items from multiple list box selected values in Power Apps and filter a list box by text input with various examples.

Filter List Box in Power Apps

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

Example:

I have a SharePoint list [Power Platform Training] that has various columns like:

I created a Power Apps canvas app and added a List box and Gallery control. The List box is connected to a SharePoint list choice column [Course]. The gallery filters and displays the respective records whenever a user selects any value from the list box control.

Follow the below steps to achieve this:

• Sign in to your Power Apps with your valid Microsoft 365 credentials.
• Create a Blank canvas app -> On the Power Apps screen, insert a List box control -> Set its Items property to:

Choices('Power Platform Training'.Course)

Where,

1. Power Platform Training = SharePoint list name
2. Course = SharePoint list choice column name

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

Filter(
    'Power Platform Training',
    IsBlank(lst_Course.SelectedItems.Value) || IsEmpty(lst_Course.SelectedItems.Value) || Course.Value = lst_Course.Selected.Value
)

Where,

1. Power Platform Training = SharePoint list name
2. lst_Course = List box control name
3. Course = SharePoint list column name

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

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

Power Apps filter with multiple List boxes

This section will explain how to filter gallery control based on multiple List boxes.

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

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

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

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

Choices('Power Platform Training'.Course)

Where,

1. Power Platform Training = SharePoint list name
2. Course = SharePoint list choice column name

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

Distinct(
    'Power Platform Training',
    'Course Handled By'.DisplayName
)

Where,

1. Power Platform Training = SharePoint list name.
2. Course Handled By = SharePoint list person column name.

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

Filter(
    'Power Platform Training',
    (Len(lst_PowerPlatformCourse.Selected.Value) = 0 || Course.Value in lst_PowerPlatformCourse.SelectedItems.Value) && 
    (Len(lst_CourseHandledBy.Selected.Value) = 0 || 'Course Handled By'.DisplayName in lst_CourseHandledBy.SelectedItems.Value)
)

Where,

1. Power Platform Training = SharePoint list name
2. lst_PowerPlatformCourse = 1st List box control name
3. Course = SharePoint list choice column name
4. lst_CourseHandledBy = 2nd List box control name
5. Course Handled By = SharePoint list person column name.

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

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

Power Apps filter gallery by multi-select list box

I will show you how to filter a Power Apps gallery by a multi-select list box

The Power Apps screen has a List box control and a Gallery control. The List box is connected to the SharePoint list choice column [Course] above.

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

Follow the below steps to achieve this:

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

Choices('Power Platform Training'.Course)

Where,

1. Power Platform Training = SharePoint list name
2. Course = SharePoint list choice column name

• 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(
    'Power Platform Training',
    IsBlank(lst_MutipleSelectedCourse.SelectedItems.Value) || IsEmpty(lst_MutipleSelectedCourse.SelectedItems.Value) || Course in lst_MutipleSelectedCourse.SelectedItems
)

Where,

1. Power Platform Training = SharePoint list name
2. lst_MutipleSelectedCourse = Power Apps List box control name
3. Course = SharePoint list choice column name

• Save, Publish, and Preview the app. When the user selects multiple values from the list box control, the gallery filters and displays the records based on multiple selected values.

We can filter the Power Apps gallery based on the multiple selected items from the List box control.

How to filter items from selected multiple List Box values

Here, I will show you how to filter items from selected multiple List Box values

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

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

I have added a list box and a data table to my Power Apps screen. The List box is connected to a SharePoint list column [Eligiblity Provided].

Whenever a user selects multiple values from the List box control, the data table should filter based on a SharePoint list of records with multiple values and display the relevant records.

To achieve it, follow the below steps:

• On the Power Apps screen, insert a List 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

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

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

Where,

1. Loan Approval = SharePoint list name
2. lst_Eligibility = List 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 List box control, the gallery will filter and display the relevant records based on multiple selected values.

We can filter the Power Apps gallery items from selected multiple List Box values.

Power Apps Filter List Box by Text Input

This section will show you how to filter the Power Apps list box by text input control.

Example:

I created a Power Apps canvas app and added a Text input, a List box, and a Gallery control. The list box control contains the items from the above SharePoint list choice column [Course].

Whenever the user provides the list box value in the text input control, based on that, the list box will select the value, and the gallery will filter and display the record based on the selected value of a list box.

Follow the below steps to achieve this:

• On the Power Apps screen, insert a Text input control as shown below:

• Insert a List box control -> Set its Items property to:

Choices('Power Platform Training'.Course)

Where,

1. Power Platform Training = SharePoint list name
2. Course = SharePoint list choice column name

• Select the List box control -> Set its Default property to:

txt_Course.Text

Where,

1. txt_Course = Text input control name

• Insert a Gallery control -> Set its Items property to:

Filter(
    'Power Platform Training',
    IsBlank(lst_Course.SelectedItems.Value) || IsEmpty(lst_Course.SelectedItems.Value) || Course.Value = lst_Course.Selected.Value
)

Where,

1. Power Platform Training = SharePoint list name
2. lst_Course = List box control name
3. Course = SharePoint list column name

• Save, Publish, and Preview the app. When the user provides the list box value in the text input control, based on that, the list box will select the value, and the gallery will filter and display the record based on the selected value of a list box.

We can filter the Power Apps List box by text input.

Conclusion

I hope this tutorial helped you learn how to filter a list box in Power Apps, filter a gallery by Power Apps list box, filter items based on multiple list boxes in Power Apps, and more.

Also, you may like some more Power Apps tutorials:

• Filter Power Apps Gallery By Year
• Filter Power Apps Collection With Search Text Input
• Power Apps Export Import Control
• Set Or Get Selected Value From Power Apps List Box
• Filter Power Apps Collection By Person

Preeti Sahu

Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.