Filter and search with two Input Text boxes

(0) Share

Report

Posted on by AB-18111337-0

Hi everyone,

We're having trouble combining different searches for different columns.

We have three columns (Title, Supplier and a combobox Status which is a lookupfield) which we need to get filtered/searched by combining all three, if possible.

It worked for two columns (title and status combobox) by using the following formula:

Search(

Filter(

VRT_WS_Artikels;

IsBlank(ComboBox3.Selected) || IsEmpty(ComboBox3.Selected) || Categorie.Value = ComboBox3.Selected.Result

);

Txt_Zoeken_Title.Text;

"Title"

)

However we can't seem to correctly add the search for 'Supplier', which is also just a single line of text field... We'd like to search the same way as for "Title", but we can't seem to combine them.

Thanks in advance!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AB_,

You can search through multiple columns by adding additional columns at the end of the Search formula:
Search( Filter( VRT_WS_Artikels; IsBlank(ComboBox3.Selected) || IsEmpty(ComboBox3.Selected) || Categorie.Value = ComboBox3.Selected.Result ); Txt_Zoeken_Title.Text; "Title"; "Supplier" )

Is there any specific error you are receiving when trying the formula above?

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
AB-18111337-0 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Laurens,

This works when using the same textinputfield, but in this case we have three columns which need to filter the gallery (so title, categorie (the combobox) and supplier).

We’re trying to filter the linked gallery with those three columns. So searching in the column ‘title’ with a textinputfield and filtering the column ‘categorie’ with the combobox works, but we can’t seem to add searching in the column ‘supplier’ with another textinputfield (called Txt_Zoeken_Supplier) in this case.

We thought that just adding ‘or Txt_Zoeken_Supplier.text;”Supplier”’ might do the trick, but unfortunately it doesn’t :(.
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AB_,

In that case you would need an additional Search() formula enclosing the current one. Each Search() can accept multiple columns but only one text input:

Search( Search( Filter( VRT_WS_Artikels; IsBlank(ComboBox3.Selected) || IsEmpty(ComboBox3.Selected) || Categorie.Value = ComboBox3.Selected.Result ); Txt_Zoeken_Title.Text; "Title" ); Txt_Zoeken_Supplier.Text; "Supplier" )

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@AB_

Alternatively, you could extend the filter() with an in operator - this results in cleaner code. If you use Dataverse, in is a delegable operator when comparing text fields. If you use SharePoint neither Search or in are delegable so the outcome would be the same:

Filter( VRT_WS_Artikels; IsBlank(ComboBox3.Selected) || IsEmpty(ComboBox3.Selected) || Categorie.Value = ComboBox3.Selected.Result; Txt_Zoeken_Title.Text in "Title"; Txt_Zoeken_Supplier.Text in "Supplier" );

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
AB-18111337-0 48 on at

Like
a
(0)

Report
Copy link

Link copied!

This works brilliant, thank you LaurensM!