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

Thanks MelindaK.  I think I understand the delegation workaround.  I guess what I ultimately need to discover for my company is how feasible or advisable it is to use SharePoint lists as a datasource (as oppoed to the more expensive Dynamics 365, say).  A judgement call I imagine (based on the ultimate size--number of rows--of the planned data tables), but to what extent do the number of COLUMNS/FIELDS also contribute to the inevitable degradation of perfomance?  Are there recommended upper limits (on rows and columns) beyond which SP becomes obviously impractical as a datasource for PowerApps?

Anonymous
Not applicable

I'm not sure how PowerApps actually gets the data from SharePoint Online, but i suspect that somewhere behind the scenes a CAML query must be involved in order to fetch records. Where I am, we have SharePoint lists and libraries with >100,000 items, so long as queries are made on Indexed columns, and the query returns less than 5000 items at a time (limit set by Microsoft) I have witnessed pretty minimal performance degradation.

 

Taking into account this, I would think that so long as your query falls within the boundaries set by PowerApps you wouldn't experience performance issues. The biggest list I've worked with in SP from PowerApps so far has been about 700 items, and so far so good, when workarounds for delegation are implemented correctly.

 

The main limitations I have found with using SP as a datasource at the moment has been at the Powerapps end, with the 500 item limit and (even with delagation) the inability to filter on more complex fields (e.g. Person, Date). Workarounds (such as the one Mr. Dang has put together) are around, but it would be great if Microsoft can lift these limitations down the road to simplify the process.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,543)