Rendering a lookup as a dropdown list record limitation

(0) Share

Report

Posted on by SarahC

I have a lookup containing nearly 16000 records.

In my power page I am rendering the lookup as a dropdown.

Seems because this generates as a list now it hits the Microsoft 5000 records list limitation, similar to sharepoint and power apps canvas.

How can I get the dropdown to render all 16000 records.

I also have javascript to allow for typeahead, hoping that some how helps filter the records returned some how, but it only searches the 5000 rendered records.

Any suggestions?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

OOlashyn 3,496 Most Valuable Professional on at

Like (2)

Report

Hi @SChavez ,
Unfortunately, you cannot increase the number of records to fetch when you render the lookup as a dropdown. I would advise you not to render lookup as a dropdown. Instead, hide it, fetch the needed records (either via web API or fetchxml), create a custom dropdown and populate it with results. You can then use your typeahead and after user selection populate the actual lookup.

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

Hi @SChavez

Great answer from @OOlashyn. Please follow the advice. Just an additional two cents. You can also build your own PCF for this problem and use it for your project. Official URL: Click here

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No