cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

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

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

Accepted Solutions

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:

choicetypesearch.gif

 

Best Regards.

Yumia

View solution in original post

6 REPLIES 6
Community Support
Community Support

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.

ComboBoxSearch.gif

 

More information:

control-combo-box

 

Hope this could be helpful.

 

Best Regards.

Yumia

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

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:

choicetypesearch.gif

 

Best Regards.

Yumia

View solution in original post

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...

 

twister_0-1613724340187.png

 

Hi,

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

Helper II
Helper II

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

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (70,545)