Deligation question

[Draax]

Hello!

Im building an inventory management for our devices and will reach about 1500 devices which is stored in an SharePoint list.

I thought if i downloaded the full list with:

ClearCollect(Local_Storage, Inventory)

 and made my search and filters on the device it would download all records and make the filters on the device.

It only downloads the first 500 records and skips the later.

How can I overcome this issue? We have 1500 devices today wich will of cource in the feature be more.

/Johan

[Anonymous]

Hi @Draax,

you have to change the Value in the advanced settings from 500 to 1500.

The max value is 2000.

Best regards

Vasii

[Draax]

Thanks Vasii, it seems to be working.

But what do I do when I reach 2000 devices?
Will a diffrent datasource like CDS be better in my cenario?

/Johan

[Anonymous]

To be honest, i don't know, i haven't developed such great apps with powerapps 

Best regards

Vasii

[timl · Accepted solution]

Hi Johan,

Yes, CDS or SQL Server data sources will help you collect more than 2000 records into a local collection.

This is because with CDS and SQL Server, the <, <=, >, >= operators are delegable. This enables you to use the less than/greater than operators against a numeric field to collect batches of 2000 records, and to store them into your local collection. 

The post here by @Mr-Dang-MSFT is the best guide on how to do this.

https://powerusers.microsoft.com/t5/General-Discussion/Overcoming-the-500-record-limit-locally/td-p/...