cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Steelman70
Power Participant
Power Participant

Data source 500 item limit for SP list and 256 items for AWA table

Hello all.

I am banging my head against a limit of 500 items on a SharePoint* list and 256 items for an Access Web App table (should be equivalent to an Azure SQL table).

I test this by simply adding a data source and then show the result in a text box with text = CountRows(MyDataSource)

Does anyone have any ideas how to increase these limits or work around them?

 

*SharePoint online as part of Office 365

11 REPLIES 11
rc
Power Apps
Power Apps

This is something we're actively working on improving -- stay tuned for updates on this front very soon.

mr-dang
Community Champion
Community Champion

I posted a highly roundabout solution the other day:

 

https://powerusers.microsoft.com/t5/PowerApps-Forum/Rollback-delegation/m-p/2131#M1188

Microsoft Employee
@8bitclassroom
Anonymous
Not applicable

Do we have any updates on when SharePoint's items limit will be increased? I know it has already been sorted for SQL Azure, so I was wondering if SP will be next? 😄 

daleritf
Helper II
Helper II

Somehow my Sharepoint list shows only 256 items

This is known issue. I received an Email from support saying that this should be fixed by the middle of November.

I will keep my fingers crossed.

 

Thnak you

Anonymous
Not applicable

Bad news for everyone waiting for this 😞 looks like it's not going to be released until Jan/Feb 2017...

 

PowerApps-Forum - Only-256-Entries-show-from-Sharepoint-list/m-p/11314#M5026

ColinI
Advocate IV
Advocate IV

Was this issue successfully resolved? Is there a bottom line effective limit on the number of Sharepoint list rows/items when used by PowerApps as a data source? Is it 500? Is it 5,000,000?
ColinI
Advocate IV
Advocate IV

Further to the above, is the effective limit dependent on the number of fields/columns in the sharepoint list data source?
Anonymous
Not applicable

@ColinI,

 

The 500 items list items has been raised, however it will only work in some cases using Delegation..

 

Have you seen these articles? 

 

https://powerapps.microsoft.com/en-us/blog/powerapps-update-large-sharepoint-lists-startswith-delega...

 

https://powerapps.microsoft.com/en-us/tutorials/delegation-list/

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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