Search within multiple columns

(0) Share

Report

Posted on by NVN_krg

Hi,

I'm new to this and I've looked through several posts to find an answer, but no joy.

I tried following the "Filter, Search and LookUp function"-article. But it still messes up.

Problem:

I'm trying to set up an easy search field with a gallery to show the results. The DS is an Excel file, it's on my OneDrive and it connects perfectly.

Table name is: Employee

Text Input name: TextInput4

Name Location

Kim	Location 1
Alf	Location 2
Andreas	Location 3
Mathias	Location 1
Leif	Location 2

In the Items property of the gallery I use this formula:
Search(Employee,TextInput4.Text,"Name")

This works well and it presents the results.

If I use the following:

Search(Employee,TextInput4.Text,"Location")

It also works perfectly.

Here is the problem. I want to search both columns. I use this formula:
Search(Employee,TextInput4.Text,"Name","Location")

This presents no results. And for the life of me, I can not understand why,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like
a
(4)

Report
Copy link

Link copied!
According to Microsoft, it appears that search only returns results from a single column. If you want to get results from multiple columns you would need to use the Filter function like this:

Filter(Employee, TextInput4.Text in Name || TextInput4.Text in Location)

Was this reply helpful? Yes No
NVN_krg 7 on at

Like
a
(0)

Report
Copy link

Link copied!
So simple.
Thanks!

I was trying with this Syntax (from the article). They should remove it if it doesn't work?
Search(Table*, SearchString, Column1 [, *Column2*, ... ] )
Table - Required. Table to search.
SearchString - Required. The string to search for. If blank or an empty string, all records are returned.
Column(s) - Required. The names of columns within Table to search. Columns to search must contain text. Column names must be strings and enclosed in double quotes. However, the column names must be static and cannot be calculated with a formula. If SearchString is found within the data of any of these columns as a partial match, the full record will be returned.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I may have misunderstood that when I read it. I didn't look at the examples, but it wasn't working for you. I know that the filter option works as I have used it many times. Not sure why the searching didn't work for you.

Was this reply helpful? Yes No