Answered

How i can add additional combobox to my gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, i have two TextSearchboxes and i want add extra combobox to search for information from it.

This is my code:

If(
 !IsBlank(TextSearchBox1.Text) && IsBlank(TextSearchBox2.Text),
 Search(
 Shortages,
 TextSearchBox1.Text,
 "crd55_item"
 ),
 IsBlank(TextSearchBox1.Text) && !IsBlank(TextSearchBox2.Text),
 Search(
 Shortages,
 TextSearchBox2.Text,
 "crd55_mco"
 ),
 !IsBlank(TextSearchBox1.Text) && !IsBlank(TextSearchBox2.Text),
 Search(
 Search(
 Shortages,
 TextSearchBox1.Text,
 "crd55_mco"
 ),
 TextSearchBox2.Text,
 "crd55_item"
 ),
 Shortages
)

how can i do it?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,117 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try the below where xxxx is the valid output of the combo box

Filter( Shortages, ( IsBlank(TextSearchBox1.Text) || TextSearchBox1.Text in crd55_mco ) && ( IsBlank(TextSearchBox2.Text) || TextSearchBox2.Text in crd55_item ) && ( IsBlank(YourComboBox.Selected.xxxx) || YourOtherField = ComboBox.Selected.xxxx ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz i have error. In my combobox i have to values to select "Otwarte" and "Zamknięte".

Filter( Shortages, ( IsBlank(TextSearchBox1.Text) || TextSearchBox1.Text in crd55_mco ) && ( IsBlank(TextSearchBox2.Text) || TextSearchBox2.Text in crd55_item ) && ( IsBlank(ComboBox1.Selected.Value) || Status = ComboBox1.Selected.Value ) )
It works for me 🙂

Was this reply helpful? Yes No