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.
