Filter datatable by either one text input or another

(0) Share

Report

Posted on by MikeAS

Hi, I see a lot of posts about the correct syntax for using multiple filters at the same time. But all I need to do is to filter by whichever textbox is chosen by the user. I have this working fine with the one textbox:

This is set to the Item Property of the datatable:

Filter([@PT_TrackingDataFinal], StartsWith(so, TextInput1.Text))

But I can't figure out the syntax for adding a second filter to the item property of the datatable so that the user can filter from a different column . It should filter like this if it were a single filter added to the Item Property:

Filter([@PT_TrackingDataFinal], StartsWith(PO, TextInput2.Text)

any help would be appreciated. Thanks

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Gerard Simpson 2,987 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MikeAS

Can you try:

Filter([@PT_TrackingDataFinal], StartsWith(so, TextInput1.Text), StartsWith(PO, TextInput2.Text))
MikeAS 13 on at

Like
a
(1)

Report
Copy link

Link copied!

AmDev, Thank you very much. That's what I needed
Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Great stuff! - Glad that worked out for you.

Good Luck with the rest of your build! ☘