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

Filter Dropdown by a textinput

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?

SSAudit.png

 

Thank you for any help

 

Gary

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

5 REPLIES 5
TJO
Resolver II
Resolver II

@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
      )
   )
)

 

 

 

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')
)
)

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

ClearCollect(
   colMyDataSource, 
   MyDataSource
)

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

View solution in original post

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,497)