Power Platform Community Forum Thread Details

Hello, Expert,

Today I am working with large datasets (100K+ records) in my Dataverse table.

I want to display them in my combobox, The problem is it try to perform search instantly when user type just the first character and another query was send for every character. This result in unnecessary multiple query and the performance is bad (10-20s until getting result).

One thing I try to archive is limiting the app to perform search only when user input more than 3-5 char in combobox's search text. I tried with these method, all break the delegation, Power Apps tried to fetch EVERY record without filtering on Dataverse side resulting in missing record or even no record showed up.

Any suggestion is appreciated.

Code 1 Code 1