ComboBOX search function can only start with the first letter and cannot be retrieved randomly

(0) Share

Report

Posted on by Dennis_Qiang

According to the title ，how to set up random search for alternative fields in my combobox? Thank you ! B&R Dennis

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

v-yuxima-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Dennis_Qiang

Could you please share more details of your situation?

Could you please share one screenshot of your issue?

Do you mean you can only search by the first letter?

For example, if I input no matter the first letter or the middle or the last ones, there will be show the related items in the combobox.

More information:

control-combo-box

Hope this could be helpful.

Best Regards.

Yumia

Was this reply helpful? Yes No
Dennis_Qiang 96 on at

Like (0)

Report
Copy link

Link copied!

Hi Yumia, I can only search by the first letter. Attachments pic is my situation. The combo box data value is call from the "choice" option in my sharepoint list. If i search "1" which is the first letter in my choice items, it will work. but when i search randomly. It doesn't work. Can your help me solve this problems? Thank you! Best Regards Dennis

Was this reply helpful? Yes No
Verified answer

v-yuxima-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Dennis_Qiang

Could you please share more details of your datasource and column?

Could you please change your formula expression as this:

If(Len(ComboBoxName.SearchText)>0,Choices(DataSourceName.ChoicesColumnName))

For example:

Best Regards.

Yumia

Was this reply helpful? Yes No
twister 418 on at

Like (0)

Report
Copy link

Link copied!

hi, could you advise my formula? i have tried as your suggestion but still appear all row from customer_name column..seems like this formula not working to me...

Was this reply helpful? Yes No
Dennis_Qiang 96 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Len(ComBox1, SearchText)>0. Not ">3", is ">0". Please try.

Was this reply helpful? Yes No
twister 418 on at

Like (0)

Report
Copy link

Link copied!

same result, i put 3 because want to do search if user type atleast 4 character. is im doing wrong formula?

Was this reply helpful? Yes No
ntosto 6 on at

Like (1)

Report
Copy link

Link copied!

Hello @v-yuxima-msft it`s worked for me. My only problem now is that I lost the drop down option, can I have this also ?

Was this reply helpful? Yes No
marlson 11 on at

Like (0)

Report
Copy link

Link copied!
I changed the code to the following and it worked for me.
If(Len(ComboBoxName.SearchText)>=0,Choices(DataSourceName.ChoicesColumnName))

I also verified that the Search function is enabled.

Was this reply helpful? Yes No