Question

A canvas app has a Dropdown control whose Items property must show the unique Region values from a Dataverse table named Accounts that contains 250,000 records. Makers report that only a subset of regions appears in the dropdown. You must ensure ALL distinct regions are available for selection while keeping the app performant. What should you do?

Accepted Answer

Create a Dataverse choice (option set) column for Region and bind the Dropdown Items to that choice column's options.

Answer

Set the Dropdown Items to Distinct(Accounts, Region), because Distinct is delegable to Dataverse and will return every unique value.

Answer

Increase the app's Data row limit for non-delegable queries setting to 2000 and keep using Distinct(Accounts, Region).

Answer

Use a Power Automate flow triggered on OnStart that returns all Accounts, then apply Distinct on the returned collection.