Answered

How to make the search functionality, of a combo box, find matches starting with a first letter match and not any match?

(0) Share

Report

Posted on by futr_vision

821 Super User 2025 Season 1

Not sure if my question is worded correctly but I would like to get the combo box to search/filter matching the first letter I type with the first letter of the items in the combo box. For example, if I type "F", I want the combo box to be filtered to show 'Fish', 'Forks', 'Fountain' etc and not 'Fish', 'Forks', 'Fountain' plus 'Effort', 'Stuff', etc.. I just want the words that start with "F". Is there way to do this?

Categories:

General Questions

Connecting to Data

All responses (2)

Answers (2)

Verified answer

futr_vision 821 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to make the search functionality, of a combo box, find matches starting with a first letter match and not any match?

Thanks. This works with a little tweak. I needed to add in the column name.

Filter(DataSource, StartsWith(ColumnName, Self.SearchText))
Verified answer

SBax 1,348 on at

Like (1)

Report

Re: How to make the search functionality, of a combo box, find matches starting with a first letter match and not any match?

I think you could achieve this using startswith

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-startswith

Combine this with filter and it should give you what you need

Filter(data source, startswith(self.searchtext)) in the items property of your combo box