Search multiple colums with same box

(0) Share

Report

Posted on by StefWS

149

There are days when I think I'm just too dumb to even low code 🤷‍.

Let's say I have a simple Table with two columns, LastName and FirstName.

I created a gallery with those. I created a text box to enter my search value. When I type something in the textbox, I want everything that starts with that text to appear whether that be the last or the first name. Been at it for over an hour and can't make it work.

So the working code to just search the lastname is:

SortByColumns(
Filter(
[@TableName],
StartsWith(
LastName,
SearchBox.Text
)
),
"LastName",
Ascending

)

But now it also has to look for this same value in the FirstName column.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Have you tries something like this:

SortByColumns( Filter( [@TableName], StartsWith( LastName, SearchBox.Text ) || StartsWith( FirstName, SearchBox.Text ) ), "LastName", Ascending )

Was this reply helpful? Yes No
StefWS 149 on at

Like (0)

Report
Copy link

Link copied!

I had a lot more columns and wrapped in a sort and a bunch of If-statement. I've must 've left out a bracket or a , somewhere probably.

Thanks!

Was this reply helpful? Yes No