Filter List Box by Text Input

(0) Share

Report

Posted on by Skybluekid

262

Hi All,

I am stumped. I would like to Filter a List Box by Text Input Value. So, I have a list of Part Numbers in a list box and I have Text Input box. When a value is typed in the Input box, for example, 249, the List box will be filtered to show only the part numbers that contains 249. Then, an item is selected in the List box, it will filter a Data Table

Or is better of doing this?

Thanks in Advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

BCBuizer 22,720 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Skybluekid ,

What you describe is basically the same as what a comobobox does by default, so I suggest using a combobox with the IsSearchable property set to true.

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

Great thank you. How would you then use the selected Item to filter the data table?

Was this reply helpful? Yes No
BCBuizer 22,720 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Skybluekid ,

There are many way to do this, depending on how you exactly want it to work. An example for an exact match in the Title column of a list to be used for the Items property of a gallery:

Filter( DataSourceName, Title = ComboBox1.Selected.Value )

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

Hi @BCBuizer

I have tried this and it comes up with an error
Incompatible Types for comparison. These types cant be compared: Text:Error

This is the formula I am using:

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,720 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Skybluekid ,

You probably need to change .Value with the name of the column that you wish to filter by, in your case probably the column with the part numbers.

Was this reply helpful? Yes No