Answered

Combobox Search - Single Letter Words

(0) Share

Report

Posted on by TesDA

611

I've created a ComboBox, which has a drop down and search functionality. The list I've used for the selections is to large for everything to fit in the drop down which is fine since the search can find everything. The list is technologies, this works fine with terms like ".Net". The issue comes with single letter technologies, like R. When you put R into the search box, every technology with r in the word comes up, and the list is so long that the language R never actually shows up in the drop down.

Any suggestions on how to put that kind of search in? Or ways to get around this issue with the limitations to data? Unfortunatly this is a list I cant shorten.

Image 3.jpg

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

wyotim 2,545 on at

Like (2)

Report
Copy link

Link copied!
The issue you are coming against is that Search looks for that string anywhere in the values being searched. I would suggest putting a radio button to select between a "contains"-type search and a "starts with"-type search. There are some examples here near the bottom of the page but here are the relevant examples:
// A "contains"-type search Search( Customers, SearchInput.Text, "Name" ) // A "starts with"-type search Filter( Customers, StartsWith( Name, SearchInput.Text ) )
This would require each of these statements to be in an If statement on the gallery Items property, with the radio control determining which one gets used.

Hope that helps but let me know if I can help out more. And props to R! Sadly I haven't used that since university.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @TesDA ,

Actually, the search functionality within ComboBox is not case-sensitive. So when you type one character within the Searchbox, the ComboBox would list all items which contains that character.

As an alternative solution, I agree with @wyotim 's thought almost. You could consider custom the Search functionality of the ComboBox control.

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the ComboBox to following formula:

Filter('20190325_case13', StartsWith(Title, ComboBox1.SearchText))

On your side, you should type:

Filter('YourDataSource', StartsWith(DisplayColumn, ComboBox1.SearchText))

Note: The DisplayColumn represents the column you want to display as Primary text within the ComboBox.

set the Primary text property of the ComboBox to your Displaycolumn as above screenshot.

Or

Filter('YourDataSource', ComboBox1.SearchText in DisplayColumn)

Above two formulas may cause a Delegation warning issue, it means that you could not delegate the data process to your data source, you could only process data locally. In default, you could only process 500 records locally at most, you could change the limit to maximum value -- 2000.

More details about changing the limits, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#changing-the-limit

If the amount of records you populated within the ComboBox is not more than 2000, you could ignore this warning issue. If the amount of records you populated within the ComboBox is more than 2000, please check the following the solution mentioned within the following thread (save your data source records into multiple collections in bulk, then merge the multiple collection into single one collection, then use the merged collection as data source within your ComboBox😞

https://powerusers.microsoft.com/t5/General-Discussion/Pulling-in-large-ish-SQL-tables/m-p/243777#M71518

Best regards,

Was this reply helpful? Yes No