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.

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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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