Filter both conditions

(0) Share

Report

Posted on by Francisco77

353

Hi All,

I have a gallery that is filtered according to a text entry box. The formula is:

Sort(Filter(CollectionName;StartsWith('TXNUMBER';TextSearchBox1_1.Text));'FIELD')

I am filtering by TXNUMBER, is it possible to set a second condition to filter the gallery; that is, that it can be filtered by both TXNUMBER and COND2?.

Thanks¡.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Francisco77,

Yes, this is possible. Just insert a comma after your first logical test. I have added an example below.

Sort( Filter( colTest, StartsWith('Test Input Text', TextInput1.Text), //Logical Test 1 Dropdown1_1.Selected.Value = ThisRecord.'Test Input Choice' || IsBlank(Dropdown1_1.Selected.Value) //Logical Test 2 ), 'Created On' )

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
Francisco77 353 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AARON_C

Thanks, but with that formula I would filter by adding data to a text entry or a drop-down list. What I need is for the same text entry to be able to enter two different conditions to filter.

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Francisco77,

Just to clarify, you want to be able to filter the gallery using 1 text input on multiple text columns?

What is your second condition you want to use to filter the gallery?

Was this reply helpful? Yes No
Francisco77 353 on at

Like
a
(0)

Report
Copy link

Link copied!

I have this gallery, and with a text entry I want to filter by any of the two values marked in red.

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Francisco77

Is the second condition also a text column? If not what is the column type

Was this reply helpful? Yes No