Answered

Not able to search based on a dropdown value.

(0) Share

Report

Posted on by KevinGador

826 Moderator

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

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (2)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Verified answer

turnerj3 2,039 on at

Like (1)

Report
Copy link

Link copied!

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"))

Was this reply helpful? Yes No
KevinGador 826 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
KevinGador 826 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report
Copy link

Link copied!

No problem, what is your gallery items code now?

Was this reply helpful? Yes No
KevinGador 826 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
KevinGador 826 Moderator on at

Like (0)

Report
Copy link

Link copied!

"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.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
KevinGador 826 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No