Search function question

(0) Share

Report

Posted on by ShanP

143

Search(Table1,TextSearchBox2.Text, "Employee_x0020_In_x0020_Charge")

This is the code that I am using to search, Table1 is a table in an excel file, textsearchbox2 is the user inputted search and Employee_x0020_In_x0020_Charge is one of the column headers in the excel file.

I want the user to search through multiple columns at the same time. I looked through the references and it said I could do this:

Search(Table1,TextSearchBox2.Text, "Employee_x0020_In_x0020_Charge", [WorkLocation])

But doing this gives me an error, saying expected text value.

Categories:

Building Power Apps

All responses (9)

Answers (0)

Sort by

charafRef 91 on at

Like
a
(0)

Report
Copy link

Link copied!

You should use Or function in your search formula :
Search(Table1,TextSearchBox2.Text, "Employee_x0020_In_x0020_Charge" or TextSearchBox2.Text, " NameID ").
ShanP 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there an alternative to or? When I hover over or it says invalid argument type (boolean) expected a text value.
charafRef 91 on at

Like
a
(0)

Report
Copy link

Link copied!
see this example on my formula :
Sort(If(IsBlank(TextSearchBox1.Text); ManuelsLists; Filter( ManuelLists; TextSearchBox1.Text in Text (AnnouncementType) Or TextSearchBox1.Text in Text (Title))); AnnouncementType; If(SortDescending1; SortOrder.Descending; SrtOrder.Ascending))
ShanP 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Where would I put in my variables? I tried it and it did not work
charafRef 91 on at

Like
a
(0)

Report
Copy link

Link copied!

share your formula , maybe i can resolve it or someone else could help you
ShanP 143 on at

Like
a
(0)

Report
Copy link

Link copied!

see this example on my formula :

Sort(If(IsBlank(TextSearchBox1.Text); ManuelsLists; Filter( ManuelLists; TextSearchBox1.Text in Text (AnnouncementType)
Or TextSearchBox1.Text in Text (Title))); AnnouncementType; If(SortDescending1; SortOrder.Descending; SrtOrder.Ascending))

What is manuelsLists, what is in Text, what is AnnouncementType?
charafRef 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Oups sorry in my head it's was clear lol !
ManuleList = sourcedata
AnnouncementType = column
Title = another column
Text = it's a kind of formula on items you can write it as :
(AnnouncementType; TextSearchBox1.Text)
Or :
(TextSearchBox1.Text in Text (AnnouncementType)

Hope could helps you !
ShanP 143 on at

Like
a
(0)

Report
Copy link

Link copied!

No, it did not help 😞

I don't think the or function is working properly for me. And if I copy and paste your formula and insert my variables nothing changes
CU28061254-0 337 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Why not just use SEARCH instead of Filter ? Others remain unchanged.

Search(DS, Search.Text, "Column1", "Column2", " ", " ",....)
Take note that the column to search must be encloded with "...".

Hope this helps,
TQ