Need help for large data ( Sharepointlist )

(0) Share

Report

Posted on by Stylead

148

Hello, I hope everyone is doing well.

I created an inventory app for my organization to search by name and email to see what users use.

I created a collection using the code below ( Thanks Mr. WarrenBelz for helping ) but it only can load 4,000 records.

With(
 {
 wLow: 
 Sort(
 AnaMlaak,
 ID
 ),
 wHigh: 
 Sort(
 AnaMlaak,
 ID,
 SortOrder.Descending
 )
 },
 ClearCollect(
 colMyCollection,
 wLow,
 Filter(
 wHigh,
 !(ID in wLow.ID)
 )
 )
)

However, my question is whether there is a workaround to create more than 1 collection and merge them together in 1 for example :

FirstCollection can load 1 to 2000 records

SacondCollection can load from 2001 to 4000 records

ThirdCollection can load from 4001 to 6000 records … etc until 10 collections and merge them together on 1 collection ( AllColection )

the solution in Mr. WarrenBelz’s blog is more advanced because I have low knowledge of Powerpp.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Stylead ,

Thank you for the mention - the only way you can add more than 4,000 records is as per this blog - it is really not that difficult, but you need an additional numeric field with the ID of the record in it.

Quite simply SharePoint has Delegation limits and this (or various variations of it all involving a "shadow ID" field) is the only workaround.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No