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

 

26 REPLIES 26

You can set the AllowEmptySelection to true

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

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.

@eka24 

I did try to set AllowEmpltySelection : true, however I need it to keep the selection otherwise it drops the School selection.  I think maybe my best option is to have a StartsWith option in search box.  If i type an S will it search for all titles starting with S throughout the sharepoint list or just in the first 500 or 2000 if I select that.

Thanks you @eka24 and @WarrenBelz 

With your help I managed to get the best solution for my senario.  In the end I added a searchbox within the card.  If the school selection does appear I can choose to search by starting letters.

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

 

Hi @eka24 

 

I am revisiting this as it was not giving me what I wanted and so I have headed down the ComboBox and Dropdown combination to get my result.  I think I have it but still need a little help if you don't mind.

 

So I have a choice column I am passing through a dropbox.  I see I cannot use a choice field as a primary or search field in the combo box so I set the screen OnVisible function to 

ClearCollect(ColHostOwner, {Result: "Any"});
Collect(ColHostOwner, Distinct(HOSTFAMILIES,Owner.Value))

owner being the divisions of host to make the smaller groups.

 

I then filter the ComboBox with

Filter(HOSTFAMILIES, Owner.Value = Dropdown3.Selected.Result)

which seems to work

 

Can you help me with the default on the dropdown box to retain the dropdown result... or does it not matter?

 

Retaining it in your situation may not be necessary. But if you want to retain the create a variable Onvisible of your screen:

Set(DroSelect,Dropdown3.Selected.Result)

Then use DropSelect on the Default of the dropdown or anywhere you want to use it.

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

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

 

I don't think I need to keep the dropdown values as I see the combobox value holds after selection.  You've bee a great help.

eka24
Super User III
Super User III

I guess once you have mark as a solution already, starting a new post will be better.

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

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.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (17,687)