cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Draax
Resolver I
Resolver I

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

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
Anonymous
Not applicable

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

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
Not applicable

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

 

Best regards

Vasii

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

 

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,916)