Filter by column 'First Name' and 'Last Name' when full name is searched

(0) Share

Report

Posted on by simondpalmer

131

Hi, I am trying to filter by column 'First Name' and 'Last Name' when full name is searched.

So when I am typing a full name when I start with a first name or last name its fine:

BUT when I type the entire full name it comes up empty:

What I have at the moment is:

SortByColumns(Filter([@'Contacts Database'],StartsWith('First Name', TextSearchBox1.Text) || StartsWith('Last Name', TextSearchBox1.Text)||StartsWith(Company,TextSearchBox1.Text)),"Title",If(SortDescending1,Ascending,Descending))

I have tried reversing the StartsWith like:

SortByColumns(Filter([@'Contacts Database'],StartsWith(TextSearchBox1.Text, 'First Name') || StartsWith(Company,TextSearchBox1.Text)),"Title",If(SortDescending1,Ascending,Descending))

But this is not Delegable. This is on a SP List that is 4200 items so needs to be delegable.

Without having to use Power Automate to create a 'Full Name' column from first name and last name. How can I achieve a search of a full name to filter the gallery? AddColumns 'Full Name'?

Any help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
@simondpalmer
I haven't tested this but try the formula below and see if it works. Basically, it is parsing the name in the textinput box

SortByColumns( Filter( [@'Contacts Database'],StartsWith( 'First Name', First( Split( TextSearchBox1.Text," " ) ).Result ) || StartsWith( 'Last Name', Last( Split( TextSearchBox1.Text," " ) ).Result ) || StartsWith( Company,TextSearchBox1.Text ) ),"Title",If(SortDescending1,Ascending,Descending) )

Was this reply helpful? Yes No
simondpalmer 131 on at

Like (0)

Report

Thanks but it errors that it is an invalid data type of Record. Expecting Text instead for StartsWith

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@simondpalmer

I tested it out and it worked great but take a look at the formula. I may have a mistake in the one I posted. Here is the one I tested myself.

Was this reply helpful? Yes No
simondpalmer 131 on at

Like (0)

Report

Awesome thanks! Yeah I forgot the ".Result" but that works great now. Super handy for other Filtering as well

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report

I am trying to do the same thing but I'm getting an error. I had to change "Result" to "Value

Was this reply helpful? Yes No