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
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.

mr-dang 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
MelindaK 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
daleritf 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
daleritf 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

MelindaK 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
ColinI 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
ColinI 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?
MelindaK 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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,220)