Not able to search based on a dropdown value.

[kej]

The dropdown contains all the column headers of my DataSource. I was able to display them all by creating a sharepoint list and manually adding the column headers there. 

My goal: is to be able to search by typing in the search box and then choose from the dropdown. I set a variable on the search button OnSelect property Set(varSource,true) so that I can give an If statement to my gallery items

My current gallery items formula that is working(hard coded for testing): 

If ( varSearch, Search(DataSource,txtSearch.Text, "Category"), DataSource) -> this formula currently works and able to search for "Category" column, knowing that this works probably I might have something wrong with my formula that is referencing the text value of the dropdown.

however when I change the gallery items formula to 

if (varSearch, Search(DataSource, txtSearch.Text, dropdown.SelectedText.Value),DataSource)

it gets a formula error.

Questions:

1)How can I search based on a dropdown value? 

2)Where should I change the value of varSearch to false, so that whenever I want to search for another I have to click the search button. Ive tried this formula in my gallery items properties
if (varSearch, Search(DataSource, txtSearch.Text, dropdown.SelectedText.Value),DataSource); Set(varSource,false) but I also get an error

[kej]

I solved my question number two, by putting the Set(varSearch,false) into my txtSearch onchange property.

[kej]

I think this has to be the solution for my question 2. having it on the onchange property of my txtSearch defeats the purpose of having to click the search button. I would have to add a "Clear" button. Thanks for this too! Now only problem is my choice column.

[turnerj3]

Check this out, looks like you could make this work leaving off the sort.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Search-a-SharePoint-quot-Choice-quot-column-...

 

[kej]

would like to share how I solved my question 2 with the help of @turnerj3 

I created a button named btnClear with the OnSelect property set to Set(VarSearch, false)

and then in my btnSearch, my onSelect property set to Set(VarSearch,true);Set(varSearchInput,txtSearch.Text)

changed my gallery items propery to 
If( varSearch && drpColumnHeaders.SelectedText.Value ="Category",
    Search(DataSource,varSearchInput,"Category"),
   .....,
DataSource)

so whenever you search anything it won't reset and you have to click either Search to search for another, or clear to show all in the gallery.

[kej]

could be but I tried, do you have any clue what's the use of Choice.Value? Doesn't seem to work when I've tried. 

[turnerj3]

I believe Choice is yourcolumn.value

[kej]

Managed to get this working with this formula

varSearch && drpColumnHeaders.SelectedText.Value ="Competency",
Search(AddColumns('DataSource',"TempCompetency",Competency.Value),varSearchInput,"TempCompetency")

reason why it was previously not working is because "Competency" column already existed. Add column creates a temporary column.

thanks a lot @turnerj3 

[turnerj3]

Good work @kej!