cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iagosalvadori
Helper I
Helper I

Data Row Limits

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

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

View solution in original post

2 REPLIES 2
Drrickryp
Super User
Super User

@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
Super User
Super User

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (15,513)