Hello there,
So I am working on a form for my team where we have a section where we can search a employee ID and it then populates the Employees name location etc. but I recently found that the largest the list can be in length is 20,000 and I have roughly 27,000 employees on this list we can search. My thought/questions is if i break the list into two halves can query/search from one box both data sources then get the content i need to generate in my form? or another option if some one has some input is how to get it to read my excel doc that has all 27,000 employees and there info on the form.