cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Power Apps
Power Apps

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

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

Highlighted
Community Champion
Community Champion

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

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
Highlighted
Skilled Sharer
Skilled Sharer

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

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? 😄 

MelindaK
Highlighted
Helper II
Helper II

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

Somehow my Sharepoint list shows only 256 items
Highlighted
Helper II
Helper II

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

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

Highlighted
Skilled Sharer
Skilled Sharer

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

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

MelindaK
Highlighted
Advocate IV
Advocate IV

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

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?
Highlighted
Advocate IV
Advocate IV

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

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

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

@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/

MelindaK

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,780)