Announcements
I'm a newbie and developing a Canvas Powerapps on a SharePoint. I have a Search box that is searching a DataTable (My SharePoint list items), I want to have a Filter option that when the Drop="less than" what is entered in the Text Input box, it will then filter the Search results. I had a slider, but want to use the Dropdown/Textbox combo instead. Is there someplace that has examples of Sort(Search(Filter on the Dropdown/texbox combo?
Thanks
Kim
Try
Filter (Search(Datasource,Searchbox.Text,"ColumnForTheSearch"),ColumnInDropdwn=DropdownName.Selected.Value)
------------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.
Thank you for your reply, I think I need an IF statement, maybe something like this
Search (Filter(DataSource,ListField(
IF dropdown = "Under" < InputTextBox
ELSE dropdown = "Above" > InputTextBox), inputSearchBox.Text,"Title")
Does that make sense?
Did you try the formula I gave. Are filtering a Gallery? With dropdown you don't need ant if statement. Whatever you select in the dropdown will automatically be filtered.
The dropdown is either Under or Over and then there is a input text box for the value and separate search box for the other fields.
This is what my Search Form so far:
Hi @kmw1130 :
Do you want to change the filter rule according to the choice of dropdown?
I suggest to judge the result of dropdown first, and then filter.
Please try this code:
Switch(Dropdown.SelectedText.Value, "Under", Search (Filter(DataSource,ListField< InputTextBox), inputSearchBox.Text,"Title") "Above", Search (Filter(DataSource,ListField> InputTextBox), inputSearchBox.Text,"Title") )
I think this link will help you a lot:
If and Switch functions in Power Apps
Best Regards,
Bof
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 350 Super User 2026 Season 2
M Bilal Khan 318
Mohsin Ali 220
