Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Building a Applicant Look up App without a Gallery

I am trying to build my company an app that will allow applicants to look up their names in our waitlist and find out their status.


The issue is that there is nearly 20,000 names on our list and Gallery has a strict delegation limit that is creating issues for my Search/Filter functions.


Is there another way to make an app that would allow people to search their names and confirm their waitlist statuses?  Perhaps instead of a Gallery, there is just some text boxes that show the applicant if a result comes up or state no applicant if none found.


Any way that will allow a search with a list of 20,000 applicant names. 

Memorable Member
Memorable Member

You can easily lookup names in a gallery list even with 20000.  Delegation limits only apply if yu use a non delegable function or expression.  Example StartsWith(ColumnName,Textinpout.text) is delegable and would find any surname in the whole list whereas 'in' Textinput.text in Column Name is not delegable. 


I have lists with over 40000 records and easilly search multiple columns. Filter(Source,StartsWith(ColumnName1,Textinput1.text) And StartsWith(ColumnName2,Textinput2.text)) etc

Hello, so if i wanted to make a search engine with 3 different fields:  First Name, Last Name, and Birth date, I can do it by the code you provided?


Is there a way i can do a click to search? Instead of having the gallery "filter" as I perform typing?  I am also trying to build this in a way that only results show after all 3 inputs are filled in.  The reason is that this is a list for applicants to look up for themselves, but i don't want them to be able to locate others on the list due to privacy reasons.  


Does that make sense?  

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,747)