cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikeAS
Regular Visitor

Filter datatable by either one text input or another

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

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
AmDev
Memorable Member
Memorable Member

Hi @MikeAS 

 

Can you try:

 

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

View solution in original post

3 REPLIES 3
AmDev
Memorable Member
Memorable Member

Hi @MikeAS 

 

Can you try:

 

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

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

AmDev
Memorable Member
Memorable Member

Great stuff! - Glad that worked out for you.

 

Good Luck with the rest of your build! ☘

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,773)