Unanswered

Search within an If function

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm having some trouble searching a data table by various text inputs depending on certain circumstances. For example, I want to search the table by 'SearchBar1'.Text when a button is pushed, but by 'SearchBar2'.Text when the button is turned off. The following formula mirrors that in my app:

If( filterbuttonpressed,
Search('Table1', 'Search Bar1'.Text, "column1"),
Search('Table1', 'Search Bar2'.Text, "column1", "column2", "column3", "column4", "column5"))
)

I'm not getting an error with this code, but when filterbuttonpressed = true, I get no results when searching text through Search Bar 1 (and there should be records corresponding to my search text).

Does the search function not work within an If function?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

How do you turn a button off in PowerApps? If you have a checkbox instead, make the Items property of the data table: If(Checkbox1.Value, Search('Table1', 'Search Bar1'.Text, "column1"),

If( Checkbox1.Value, Search(Table1,'Search Bar1'.Text,'column1'), Search( 'Table1','Search Bar2'.Text,"column1", "column2", "column3", "column4", "column5" ) )

The same formula would hold for a Toggle control, just substitute Toggle1.Value for Checkbox1.Value in the above formula.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Appreciate the above. However, "filterbuttonpressed" is just a variable that is toggled on and off when the filter button is pressed (OnSelect = UpdateContext({filterbuttonpressed: !filterbuttonpressed}). Regardless, I've modified the formula a bit to incorporate additional filter fields, but I'm not having much luck:

If ( filterbuttonpressed ,
Filter ('Table1', StartsWith("column1", 'SearchBar2'.Text) || StartsWith("column2", 'SearchBar3'.Text) || StartsWith("column3", 'SearchBar4'.Text)),
Search ('Table1', 'SearchBar1'.Text, "column1", "column2", "column3", "column4", "column5")
)

Was this reply helpful? Yes No