Multiple TextInput search on a single column

(0) Share

Report

Posted on by tbowland

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

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
tbowland 10 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
tbowland 10 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

dev_fridden 9 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
tbowland 10 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No