Answered

Combo Box SearchField If Statement Not Working?

(0) Share

Report

Posted on by bcampbell13

Can you use an If Statement in the SearchField of a Combo Box? I have a toggle and I would like the search field to be based of a field determined from the toggle.

For Context, our projects have both a real Name and a CodeName, I want a user to be able to choose which field it will search to find the project they want. The data source is SQL, both the fields are text fields and we have a lot of rows in the list so the search must be delegated to the server.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Combobox allows multiple search. If this will not disturb your objective, I suggest you remove the if function and go with;

["Column1","Column2"]

With this both columns could be searched

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
bcampbell13 58 on at

Like (0)

Report
Copy link

Link copied!

I can't use ["Column1","Column2"], because I'd like it to search one or the other.

The If statement does not seem to work, it will only ever search one of those fields.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @bcampbell13 :

I did a test, the function you mentioned really can not be achieved.I suggest you use a combination of controls to accomplish similar functions.For example:

1\My data source:

ClearCollect( TestCollection, {CodeNameClientName:"A",MatterClientName:"X"}, {CodeNameClientName:"B",MatterClientName:"Y"}, {CodeNameClientName:"C",MatterClientName:"Z"} )

2\Add a toggle control(SetMatter_SelevtBy_Toggle)

3\Add a text input control(TextInput1)

OnSelect

Set(visible,true) /*visible is my custom variable*/

4\Add an arrow icon

OnSelect

Set(visible,!visible)

5\Add a list box(ListBox1)

Items

Filter( TestCollection, If( SetMatter_SelevtBy_Toggle.Value, StartsWith( CodeNameClientName, TextInput1.Text ), StartsWith( MatterClientName, TextInput1.Text ) ) )

OnSelect

Collect(TheResult,ListBox1.SelectedItems) /*TheResult is my custom collection*/

6\Add a gallery(Gallery3)

Items

TheResult

7\Add a label control into this gallery

Text

ThisItem.CodeNameClientName

8\Add a "X" icon into this gallery

OnSelect

Remove(TheResult,ThisItem)

Best Regards,

Bof

Was this reply helpful? Yes No