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

[Steelman70]

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

[rc]

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

[mr-dang]

I posted a highly roundabout solution the other day:

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

[MelindaK]

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]

Somehow my Sharepoint list shows only 256 items

[daleritf]

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]

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]

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]

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

[MelindaK]

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