Dropdown list needs filtering

[StuCundy]

Hi there

I have a list of schools and I wish to select one on a student form.  This is on a customized form in powerapps.  What filter methods will work if I wish to start typing the school name in search box first?  I have tried this without success.

Filter(SCHOOLS, StartsWith(Title,SchoolSearchBox.Text, "Title"))

[StuCundy]

@eka24 

no repeating names but i could filter by type, with a dropdown i guess. i.e. secondary schools

[StuCundy]

@WarrenBelz 

i do have more than 2000 records so definitely need to filter in some form.

[WarrenBelz]

@StuCundy 

You have now hit the roadblock. Search statements in whatever form are simply not Delegable. If you can filter the choices in some other way to get under this number, then it will work, but otherwise, simply not possible in a Combo Box.

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.

[eka24]

In that Case you could have Two comboboxes to do a cascading dropdown based on the type to reduce the list based on secondary or another type.

So in the First Combo, when you pick secondary, only secondary school will show in the second combo.

Check this video:
https://youtu.be/URe94EYCSz8?t=6

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[WarrenBelz]

@StuCundy ,

Pretty much what @eka24 said

[StuCundy]

I can get the schooltypes using:  Distinct(SCHOOLS,SchoolType.Value). but when i enter the following in the 2nd dropdown I get an error 

[eka24]

Try:
Filter(SCHOOLS,SchoolType in Dropdown1.Selected.Result)

Is SchoolType a Choice column in your sharepoint?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[StuCundy]

@eka24 

Yes

[eka24]

What was the result of the formula I gave

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[StuCundy]

@eka24 

I managed to get this to work... Filter(SCHOOLS,SchoolType.Value=SchoolTypeDD.Selected.Result)

However when I edit the form the SchoolType dropbox defaults to the first entry in the values available and changes my school selection.  Is there a way to disregard the SchoolType once school has been selected?