Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Make a drop down work like the "Search" functionality

My Client wants the app to work like Excel,

e.g. when you filter an Excel spreadsheet, you get a series of drop-down's.

They don't like/want the "Search" functionality (Depsite it being better!).

So what I want is to add a dropdown (actually in the end a series of drop downs) near the search bit of the screen like this (see the picture).

I thought I could put in the OnChange, and OnSelect events similar syntax to the BrowseGallery1 , like this:

SortByColumns(Search('[dbo].[KAPMT_MAIN_VIEW_2]',Dropdown5.Selected.APPLICATION, "APPLICATION"),"MANUFACTURINGCENTRE", If(SortDescending1, Descending, Ascending))


But it doesn't work.

I tried to make a "Filter" as well, but "Filter" doesn't seem to like an SQL "View" as a datasource.

Any ideas?

Level: Powered On

Re: Make a drop down work like the "Search" functionality

Anyone have any ideas?

All I basically want to do is make it "work Like Excel".

I've got a DropDown5 with the right selection in.

Filter doesnt work, it does nothing.

Neither does Search even with the same code from the BrowseGallery1.

I've tried a seperate button as well.
And hard coding the search (or filter) value.

Eventually I get rid of the ridicolous error messages; but nothing on the screen ever gets searched or filtered.

It just stays there; giving no clue is to why it doesn't work.

Here's some other example code:

Filter('[dbo].[KAPMT_MAIN_VIEW_2]',Dropdown5.Selected.Value in BrowseGallery1.Selected.APPLICATION,true)

Filter('[dbo].[KAPMT_MAIN_VIEW_2]',Dropdown5.Selected.Value in Label6,true)


Search('[dbo].[KAPMT_MAIN_VIEW_2]', Dropdown5.Selected.Value, "APPLICATION")

I've tried in a button, and on the "OnChange" event of the dropdown, and on the "OnSelected" of the drop down.

None of it doesn't anything - it simply gets ignored completely.

It should be sooooooooooooooo simple.

Helpful resources


PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round


Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 182 members 5,196 guests
Please welcome our newest community members: