Unanswered

Using a combobox to filter and then text input box to search a single gallery

(0) Share

Report

Posted on by Dougblitz

Using Excel online (where my table is located) I would like to filter by using a combo box for one particular column (Week_Commencing) and then filter by text using a text input box for multiple columns (Haulier, Collection_Delivery, Due_Date Etc) and if no selection in combo box still be able to filter using only the text input box, if this is possible.

This is how im filtering gallery with the textbox but i have no idea what and how to add the additional augments/Logic to fulfil what i have outlined above.

Filter(
Table2,
Or(
TextInput1.Text in Haulier,
TextInput1.Text in Collection_Delivery,
TextInput1.Text in Due_Date
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (2)

Report
Hi @Dougblitz ,

Please note that .Value may be different (a field name) depending on the Items of the Combo Box

Filter( Table2, ( Len(ComboBoxName.Selected.Value) = 0 || Week_Commencing = ComboBoxName.Selected.Value ) && ( TextInput1.Text in Haulier || TextInput1.Text in Collection_Delivery || TextInput1.Text in Due_Date ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

Dougblitz on at

Like (0)

Report

Hi there

Many thanks for your help, its done the trick.
Much Appreciated.

Was this reply helpful? Yes No