cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StuCundy
Post Patron
Post Patron

Dropdown list needs filtering

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User III
Super User III

Hi @StuCundy ,

Firstly make the Default of your Search Text box "" (two quotes).

Other than that you were pretty close (I assume this is a gallery) for the Items property

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

 

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

26 REPLIES 26
WarrenBelz
Super User III
Super User III

Hi @StuCundy ,

Firstly make the Default of your Search Text box "" (two quotes).

Other than that you were pretty close (I assume this is a gallery) for the Items property

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

 

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

eka24
Super User III
Super User III

One approach is to use a combobox, that allows you to search. So on the Items of the Combobox put the Datasource: SCHOOLS.Title

 

If you want to filter a Gallery that is linked to the Dropdown or Combobox, you try:

Filter(Schools,Title=Combobox1.Selected.Title)

 

If you want whatever you select to Appear on a form, then:
On the Form Item put: Gallery1.Selected

Then on the Gallery1 put: Schools

So whatever you select in the Gallery appears on the form

 

 

A screenshot will help it it still does not work

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

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.

 

Hi @WarrenBelz and @eka24 

Thank you for your suggestions.  I will try them all.  This dropdown is in a customized form direct from a Sharepoint list.  In powerapps but not an App.  does that change things?

Hi @StuCundy ,

I am assuming you are going to put a gallery on this from anther list?

If so - it does not matter it is a SharePoint generated form

hi @WarrenBelz 

no plan to put in a gallery.... i just replaced the input with a dropdown and took the title of the other list as a parent relationship.  Will I create issues by doing this?

OK @StuCundy ,

I seem to have the wrong track here - are you simply wanting to see the search items in the combo box when the user starts typing? Simply turn on "Allow Searching" in the settings. You will need a combo box for this if you currently have a drop-down.

ComboSearching.png

 

 

 

 

 

 

 

 

 

 

 

 

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 

Because there are so many schools I only get some of the list in the dropdown.  A school starting with T doesn't appear, I guess to do the fact that powerapps only gets the first 500 items.  So I thought if I have a way to set the letter to start the search then I will be able to select my target.

If there are repetitions in the school names, you could use distinct:
Distinct(Schools,Title)

This will ensure one school at a time.

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

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.

Thanks @StuCundy ,

Go into your App Settings > Advanced Settings and increase the limit to 2000. It should pick up to this limit.

 

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_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (3,325)