Allowing Filtering Gallery Through Text Input Based on First Name, Last Name, and out of order ID

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am currently working on a PowerApps in which it is required that we can filter through a SharePoint. There are currently 13,500-ish rows within a column; the first column being a persons name (Last Name, First Name) and a second column being a username (FirstPart.LastPart). Is there anyway for a text input box to show the right output going based on first name, last name, or their username (even out of order). For instance, if someone was named John Doe, and i searched up Doe, his name would pop up; within that same text input, if I use his username (i.e. John.Doe) and search using Doe first or John.Doe would it show up? Is there a method for this with given the volume of data?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

I will answer in two parts - the First and Last name can be done

Filter( ListName, StartsWith( 'First Name', YourSearchBox.Text ) || StartsWith( 'Lastt Name', YourSearchBox.Text ) )

Your other field however cannot be done in a Delegable manner as you need the in Filter.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No