Dropdown list needs filtering

(0) Share

Report

Posted on by StuCundy

377

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

Categories:

Building Power Apps

I have the same question (0)

All responses (26)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,420 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
StuCundy 377 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
WarrenBelz 155,420 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
StuCundy 377 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
WarrenBelz 155,420 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

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.

Was this reply helpful? Yes No
StuCundy 377 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
WarrenBelz 155,420 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
StuCundy 377 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No