cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Draax
Level 8

Deligation question

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Deligation question

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/...

 

 

 

View solution in original post

4 REPLIES 4
Vasii
Level 8

Re: Deligation question

Hi @Draax,

 

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

The max value is 2000.

 

settings.PNG

 

Best regards

Vasii

Draax
Level 8

Re: Deligation question

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

Vasii
Level 8

Re: Deligation question

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

 

Best regards

Vasii

Super User
Super User

Re: Deligation question

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/...

 

 

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,873)