Can I search based on a dropdown within a filter

(0) Share

Report

Posted on by jesenavaranjan

227

I want to filter my view in SQL, which is based on a search box and a dropdown with a column name

I can't get this to work, is this possible?

the attached picture explains my problem

within the dropbox, I have 'Name' 'Description' which are fields within my SQL view gallery

So if Name is selected, the user can search by name

If description is selected, the user can search by description

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

cwebb365 3,300 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I don't know if there is a better way to do it, but you could just use an IF on the gallery.

So IF(Dropdown.value = "Name", Filter(your filterto get name), Filter(your filter to get desc.))

If you need more you can nest if's, but that's the quick and easy way to get it now lol...

Was this reply helpful? Yes No
jesenavaranjan 227 on at

Like
a
(0)

Report
Copy link

Link copied!

If(FilterInput.Value="Name",Filter('[dbo].[tbMilestone]',Name=SearchInput.Text),'[dbo].[tbMilestone]')

Thank you! Is there anything wrong with my syntax above? and it's not working...

Was this reply helpful? Yes No
cwebb365 3,300 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah you need description in there too if you're searching for it.

If(FilterInput.Value="Name",Filter('[dbo].[tbMilestone]',Name=SearchInput.Text),Filter('[dbo].[tbMilestone]',Description=SearchInput.Text))

Was this reply helpful? Yes No
jesenavaranjan 227 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks

Actually I had to do: If(FilterInput.Selected.Value="Name",Filter('[dbo].[vwMilestone]',Name=SearchInput.Text),Filter('[dbo].[vwMilestone]',Description=SearchInput.Text))

Also if I want the search to no be strictly equal to, how do I handle that?
Like a %like% and ignoring cases?
Jese

Was this reply helpful? Yes No
Verified answer

cwebb365 3,300 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Since you have a SQL back end, luckily it makes it easier.

You can just do something in your filter like Filter('datasource', Description in Field.text)

Was this reply helpful? Yes No
jesenavaranjan 227 on at

Like
a
(0)

Report
Copy link

Link copied!

THANK YOU

Was this reply helpful? Yes No