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
Super User
Super User

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
Super User
Super User

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
Super User
Super User

Great stuff! - Glad that worked out for you.

 

Good Luck with the rest of your build! ☘

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,870)