cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User III
Super User III

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

Super User III
Super User III

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (65,926)