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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,338)