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

831 Moderator

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

SBax 1,348 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

futr_vision 831 Moderator on at

Like
a
(0)

Report
Copy link

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

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

Was this reply helpful? Yes No