Answered

Multiple Search Criteria Text Box

(0) Share

Report

Posted on by Georgetown15x

I am a dummy with no programming experience, your help is greatly appreciated!

First of all, I have a table called "Movements", with two columns - "Name" and "Location"

Name	Location
Jay	Tasmania
Kay	Sydney

I have created a textbox to use as a search box, named "FilterTextBox"
below is the function I used to search for the "Name" in the Gallery

Sort(If(IsBlank(FilterTextBox),Movements,Search(Movements, FilterTextBox.Value,Name)),Name)

How do I incorporate "Location" into the function? So that I can also search for both name and location.

Your insights and solution are much appreciated.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Georgetown15x

Consider the following change to your formula for your Items property of your Gallery:

SortByColumns( Search( Search(Movements, FilterTextBox.Text, "Name"), FilterLocationTextBox.Text, "Location" ), "Name" )

This is assuming you are putting a separate text input control for your Location filter (FilterLocationTextBox).

If not, and you just want to search both columns with the same criteria in the one textbox, then consider this:

SortByColumns( Search(Movements, FilterTextBox.Text, "Name", "Location"), "Name" )

I hope this is helpful for you.
Georgetown15x 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes

It gives me the error - The function 'Search' has some invalid arguments. Please help.

*The data was stored in Common data service; therefore the Name is "crcf8_name". In case you're wondering.
Georgetown15x 61 on at

Like
a
(1)

Report
Copy link

Link copied!

You're definitely the smartest person I ever met. Bravo!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Georgetown15x

Sorry about the cross-edit. You must have picked up my first reply that actually had a syntax issue in it. I corrected it and I am assuming you discovered that.

Glad you got some moving forward help.