Combo-Box works only with IsSearchable = False

[Anonymous]

Hi Folks,

I my combo-box of Audience (Role)- the items property is dependent on another control (Audience (Function) and a SharePoint list as shown in the items property formula below:

The issue is that the value field works only when the IsSearchable property is set to false. 

Whenever i select True, it doesn't show any dropdown values to select from.

Kindly suggest!

[WarrenBelz]

Hi @Anonymous ,

The Search function in a combo box is subject to Delegation limits, so if you have more than your (500-2,000) limit in items displayed, it will not work and will show the warning you are seeing. Is this the case with yours?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Anonymous]

Hi @WarrenBelz 

Thanks for trying to help.

Actually, the list has 50 items only and with dependence (field Audience (Function) on cascading dropdowns- it would never exceed 10 items at max at once.

[WarrenBelz]

Thanks @Anonymous ,

I see the issue now I have zoomed in on your error (it helps to also post your code in Text). You have an in filter in the Items, which is not Delegable. If the list is always that small (under your Delegation limit), try this

With(
   {
      wAudience:
      Sort(
         Audience_List,
         Audience
      )
   },
   ShowColumns(
      Filter(
         wAudience,
         'Audience (Title)' in DataCard37_3.SelectedItems
      ),
      "Audience"
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Anonymous]

@WarrenBelz The alternate formula worked. However, as soon as i put "True" in IsSearchable property- I see the following 2 errors related to this new formula

And the 2nd error is below-

With my earlier formula, i was not getting these errors- but just the delegation warning.
However, none works with the search functionality- Kindly suggest

[Anonymous]

Hi @RandyHayes, can you please check this. 

[RandyHayes]

@Anonymous 

What is the SearchItems property of your combobox?  You can set it directly or through the "edit" fields part of the Combobox control properties.

[Anonymous]

@RandyHayes I think you meant SearchField property, highlighted below:-

[RandyHayes]

@Anonymous 

Oh no!!  Sorry for delay.  I thought I had hit reply earlier but it was still open in a tab with the below message.  Did you get past the problem or are you still having it?

//original message below//

Yes, I meant SearchFields in this case, but really (without thinking about it) I first meant SearchItems as that was where the error was - but that is not a property you can get to.

So is this a case of a combobox gone wild?  They sometimes have issues and you need to remove and add them back - sometimes as easy as a cut and undo.  Have you tried anything like that?

[WarrenBelz]

HI @Anonymous ,

Happy to leave you with @RandyHayes , but you might give me a chance to respond (I am in timezone UTC + 10)