Power Platform Community Forum Thread Details

Hello all,

I am struggling to find this answer...trying here.

Let us say we have a model-driven app on Dataverse, which includes a table with a very large number of records, i.e. 1 million - for example, 1 million customers/contacts.

When I create another table and a lookup field in it related to the Customers table, will that field be able to search within all relevant Customer records, or is there some limit? And will that be doable within a reasonable period of time, so the user searching for Customer XY in that field won't have to wait 10 seconds to get the suggested results?

Thanks!

Categories:

Building Power Apps