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


Power Automate Community User Group Member Badge

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


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,343)