cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tbowland
Level: Powered On

Multiple TextInput search on a single column

What I want to do Is type a search word in two textInputs and seach on one column

 

TextInput1  "Oil" & TextInput2 "Essential"

Results from Description column

 

Lavendar Oil

Oil
Essential

Essential Bath Balm

 

Anxious to hear from anyone that can help
Thanks
Ted

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
dev_fridden
Level: Powered On

Re: Multiple TextInput search on a single column

With Filter() you can use a combination of && and || to make a match

 

Like this:

 

Filter(List1;(TextInput1.Text in Text1 && TextInput1.Text in Text2) || (TextInput1.Text in Text1) || (TextInput1.Text in Text2))

 

Hope this helps,

Fredrik

 

 

View solution in original post

7 REPLIES 7
Super User
Super User

Re: Multiple TextInput search on a single column

What is the data source (SQL, Excel, SharePoint, CDS or a Collection)? Also is the goal to return only records that have the value of TextInput1 or TextInput2 in the description column?



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Dual Super User
Dual Super User

Re: Multiple TextInput search on a single column

Hi @tbowland 

 

Search function only allows one search term

 

you could try Filter(PADEVICES,TextInput1.Text in column  || TextInput2.Text in column )

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

tbowland
Level: Powered On

Re: Multiple TextInput search on a single column

The data ultimately comes from a sql server but will be brought in to a collection for possible offline use.


Reza's " Filter(PADEVICES,TextInput1.Text in column  || TextInput2.Text in column ) " works but not exactly they way I need.
This solution kind of works like a AND where I need a AND/OR meaning the results need to show items matching TextInput1 AND/OR TextInput2
Ted

Still working on it

tbowland
Level: Powered On

Re: Multiple TextInput search on a single column

Wow that works but not exactly they way I need.

This solution kind of works like a AND where I need a AND/OR. meaning the results need to show items matching TextInput1 AND/OR TextInput2

Thanks

Ted

dev_fridden
Level: Powered On

Re: Multiple TextInput search on a single column

With Filter() you can use a combination of && and || to make a match

 

Like this:

 

Filter(List1;(TextInput1.Text in Text1 && TextInput1.Text in Text2) || (TextInput1.Text in Text1) || (TextInput1.Text in Text2))

 

Hope this helps,

Fredrik

 

 

View solution in original post

Dual Super User
Dual Super User

Re: Multiple TextInput search on a single column

Hi @tbowland 

 

you can change the filter creiteria to combine it with || and && based on your requirements

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

tbowland
Level: Powered On

Re: Multiple TextInput search on a single column

Thanks
This is what I settled on
If( IsBlank(txt_Search2.Text),Filter(Col_AllProduct,txt_Search1.Text in DESCRIPTION),Filter(Col_AllProduct,txt_Search1.Text in DESCRIPTION && (txt_Search2.Text in DESCRIPTION)))

 

Thanks also to  @RezaDorrani   and @Jeff_Thorpe 

 

Ted

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 414 members 5,651 guests
Please welcome our newest community members: