Data Row Limits

[iagosalvadori]

Dear Microsoft community,

I have a very basic question, in my organization we're building a some Apps utilizing only sharepoint lists connection.

The apps are simple, and don´t utilize Collections or complex things, however, is there a data row limit?

Best Regards

[Drrickryp]

@iagosalvadori 

Yes and no. It depends on the functions used. Some are delegatable meaning the function works at the server level and there is no limit. Others are not delegatable, meaning the data has to be downloaded to the users device. These are limited to 500 by default or 2k max. There is much information about delegation in SharePoint and PowerApps. See @WarrenBelz 's excellent review of the subject in his blog "Practical PowerApps". 

[WarrenBelz · Accepted solution]

Hi @iagosalvadori ,

There are two "limits" which are easily managed. The first is your Delegation limit which is standard 500, but up to 2,000, which simply requires Delegable queries.  I have a blog on this that may assist here. The second is 5,000, where any columns involved in queries need to be indexed in SharePoint - 20 indexed column per list are allowed. 

Other than that , SharePoint will hold up to 30 million records.

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.

Visit my blog Practical Power Apps