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

[v-xiaochen-msft · Accepted solution]

Hi @kej ,

PowerApps is static so you cannot use the value of dropdown to refer to the column name.

Please try this

If ( varSearch && dropdown.Selected.Value="value1", 
Search(DataSource,txtSearch.Text, "Column1"), 
varSearch && dropdown.Selected.Value="value2", 
Search(DataSource,txtSearch.Text, "Column2"), 
...,
DataSource) 

Best Regards,

Wearsky

[turnerj3 · Accepted solution]

Unfortunately, powerapps won't let you call a column without hardcoding by text.

You could set up a multiple If statement for each dropdown value like:

If(dropdown.SelectedText.Value="Category", Search(DataSource, txtSearch.Text, "Category"),dropdown.SelectedText.Value="Column2", Search(DataSource, txtSearch.Text, "Column2"))

[kej]

would have selected this answer but when I tried, dropdown no longer accepts .Selected.Value, now its SelectedText.Value

[kej]

thank you! do you have any clue on my question number 2?

[turnerj3]

No problem, what is your gallery items code now?

[kej]

its like what you Stated,

If( varSearch && drpColumnHeaders.SelectedText.Value = "Category",
   Search(DataSource, txtSearch.Text, "Category"),
   .....
   DataSource)

One more problem that I encountered is I am having a formula error with one of my column type which is a choice. It says wrong column type. Expects text type, however all this formulas are identical only with this column did not work.

[turnerj3]

Try setting varSearch false immediately after setting it true and see if the search completes. 
For the choice column try using “column”.value

[kej]

"ColumnName".value did not work. I deleted it first in my gallery items to check the varSearch. Setting it to false immediately after did not work too. But the gallery items are working I just had to remove my choice column at the moment. 

And delagation warning which I will try to figure out soon too.

[turnerj3]

I think the problem with varSearch is that anytime you set it false it is going to wipe the gallery because the IF depends on it.

You could use a button to set it false.

Not real sure about the choice column at the moment.