Filter Dropdown by a textinput

[Gazbeer]

Hi,

Can anyone help me with this one please? I am trying to filter a drop down by what it matches in my data source and a text input.

ie, in the text box you type 'apple', the drop down needs to show all the results with apple from my data source column.

If you see the image, the user types into the text boxes below, that then uses 'Concatenate' to create 1 line, Can the drop down show all items with the matching line from a SharePoint list?

Thank you for any help

Gary

[TJO]

@Gazbeer Howdy...some input, just an example:

If(
   textboxSearch.Text = "",
   yourDataTable,
   Filter(
      yourDataTable,
      Or(
         textboxSearch.Text in Column1,
         textboxSearch.Text in Column2,
         textboxSearch.Text in Column3
      )
   )
)

[Gazbeer]

Hi,

Thank you for your reply, I am getting a delegation warning when trying your formula, I may have it in wrong lol!?

Could you have a look.

Thank you . Gaz

If(
SearchShift.Text = "",
'A.S Ranger 1 Handover',
Filter(
'A.S Ranger 1 Handover',
Or(SearchShift.Text in 'Shift Reference')
)
)

[TJO]

@Gazbeer You could try to put your data source into a collection and filter that collection:

ClearCollect(
   colMyDataSource, 
   MyDataSource
)

[WarrenBelz · Accepted solution]

@Gazbeer ,

The Delegation warning is the in statement. If you have more than 2,000 records, you need to consider something else (a collection will only work initially up the the Delegation limit you have set). 

So your choices are -

Use StartsWith() - completely Delegable on any number of records, but only searches the starting characters of the field.

Filter(
   'A.S Ranger 1 Handover',
   If(
      IsBlank(SearchShift.Text),
      true,
      StartsWith('Shift Reference',SearchShift.Text)
   )
)

If you will always have less than 2,000 records and want to get rid of the Delegation warning - set your limit to this and

With(
   {wRanger:'A.S Ranger 1 Handover'},
   Filter(
      wRanger,
      If(
         IsBlank(SearchShift.Text),
         true,
         SearchShift.Text in 'Shift Reference'
      )
   )
)

Do a big collection - I have done a couple of blogs on this - Delegation and the With() Statement - there may be something in there that will suit your requirements.

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.

[WarrenBelz]

Hi @Gazbeer ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.