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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Gerard Simpson 2,987 Moderator on at

Like (1)

Report
Hi @MikeAS

Can you try:

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

Was this reply helpful? Yes No
MikeAS 13 on at

Like (1)

Report

AmDev, Thank you very much. That's what I needed

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report

Great stuff! - Glad that worked out for you.

Good Luck with the rest of your build! ☘

Was this reply helpful? Yes No