Announcements
Hello fellow Appers!I'm struggling to find a solution for an app I'm building for our company. The module is a Non-Conformance module where I'm needing to use the app to create entries. The hang-up I'm having is that the field where we enter the Part Numbers need to pull from a fairly large list (Over 100k Part #s), so using something like "Choices" isn't an option because of the "Delegation" limit.Is there anyone who can help point me in the direction of a solution it would be VERY much appreciated. I will try to describe the layout a little better below.PowerApp = EditForm (Sharepoint List 1)EditForm needs to contain a box that lets you choose an option from our LARGE part # list ("Title" Column in Sharepoint List 2) and apply it to the record being created (Sharepoint List 1)
Hi
i think the only way to do this is have the power apps split the list into groups this will remove the 999 limit that there is. is it a combox you are using?
Yes, the box is in fact a ComboBox.I should have noted the actual structure of the part numbers, as they are all 6 digit numbers (200001, 200002, etc) So I'm not exactly sure how I could split such a large amount of numbers into groups.
Hello Again
i did watch a video on how to do it but i not remeber which one it is there is this video it might help look at his code and how he uses it
https://www.youtube.com/watch?v=QhGV4AhCFRc
Looks like Shane is using the SearchTerm function which I believe is exclusive to the Office365 tools in PowerApps, as I cannot find any reference to it being used on a different function anywhere else on the internet.Also about your first idea of storing them in a collection, because of the size of the dataset I'm afraid the code will be extremely long and would result in extended wait times and an overall terrible user experience. While I wait for some other solutions I think I'll give it a try and see if/how poorly the app runs.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 352 Super User 2026 Season 2
M Bilal Khan 323
Mohsin Ali 226
