cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dhruvp29
Regular Visitor

Not able to search with second word of the choices with Combo box Search

I have a choice field column in SharePoint List, which I am showing in the form using Combo box with allow Search equals true.

Consider we have below three choices.

1. Contoso Microsoft

2. Read Write

 

If I search with word "Conto" then Contoso Microsoft appears but if I search with 2nd word "Microsoft" then the search result is not appearing.

 

Default Scenario: 

dhruvp29_0-1635397601145.png

 

Searched for Contoso

dhruvp29_1-1635397644416.png

 

Searched for Microsoft

dhruvp29_2-1635397684628.png

 

Is there any way we can enable the searching for the 2nd word as well? 

 

I tried to built custom combo box using search function but it works only with Text fields and not with choice fields.

 

I am open to other custom control ideas as well. 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @dhruvp29,

Do you want to search choices based on any strings within?

Could you please share a bit more about your scenario?

 

Set the Items property of the Combo Box as below

Filter(Choices(Tracking.TestChoice),ComboBox1.SearchText in Value)

vqiaqimsft_0-1635407111117.png

 

Best Regards,
Qi

View solution in original post

4 REPLIES 4
vermaaman
Resolver I
Resolver I

@dhruvp29 Better to create a custom combobox using Gallery and TextInput and apply your own custom filter.

Hi @vermaaman , Already tried that but getting syntax error as I am working with Choice Field and not the Text field. Tried to implement custom combo box using Text Input, Gallery and Search function. But Search function is not accepting the choice field.

vermaaman
Resolver I
Resolver I

@dhruvp29 did you try getting the choice field date in a collection and convert into text then use for search ? probably try using Text() to convert ?

Hi @dhruvp29,

Do you want to search choices based on any strings within?

Could you please share a bit more about your scenario?

 

Set the Items property of the Combo Box as below

Filter(Choices(Tracking.TestChoice),ComboBox1.SearchText in Value)

vqiaqimsft_0-1635407111117.png

 

Best Regards,
Qi

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,633)