cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DanielaHo
Advocate IV
Advocate IV

PowerApps Delegation on large SPO lists

Hello,

Is there is a limit on the number of SharePoint Online list items that a PowerApps can return when using a delegation?

Our requirement is currently a simple app that should display certain items from a Sharepoint list. I am using a delegation to only return the required subset of items, which works fine without warnings, however the list is likely to grow large very quickly (20.000+ rows).

Let’s say my delegation should only return 3 list items. When using a delegation, does it then matter at all how large the list grows? 

Just trying to gauge how reliably delegations work on large lists...

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @DanielaHo ,

Do you apply a delegale formula into your SP list data source?

 

If you applied a delegable formula into your SP List data source, the app would delegate the data process to the SP List itself rather than process data locally.

 

More details about the Delegation in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

 

If you use a delegable formula within your app, but the result could only return proper records as expected, I think this issue may be related to SP List server. I agree with @RezaDorrani 's thought almost, there is an limit on the query performed on SP List Items.

More details about limits on SP List, please check the following article:

https://docs.microsoft.com/en-us/sharepoint/install/software-boundaries-and-limits

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Pstork1
Dual Super User III
Dual Super User III

As long as you are using a delegable function and are return less than the 500 maximum by default the list can get as large as you need it to be without an issue.  There is of course an upper limit in SharePoint, but I think its around 4,000,000 items.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
RezaDorrani
Dual Super User II
Dual Super User II

Hi @DanielaHo 

 

You would have to make sure to use functions which are delegable with SharePoint as a data source

https://docs.microsoft.com/en-us/connectors/sharepointonline/

 

Additionally, please note that SharePoint also has a limit of 5000 items for queries performed

Hence you need to make sure that when Filtering data in SharePoint using PowerApps, the specific columns are indexed in the SharePoint List/Library

 

You can create max of 20 indexes per list/library

Also, Indexes cannot be created/deleted once your list grows above 20k records

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

v-xida-msft
Community Support
Community Support

Hi @DanielaHo ,

Do you apply a delegale formula into your SP list data source?

 

If you applied a delegable formula into your SP List data source, the app would delegate the data process to the SP List itself rather than process data locally.

 

More details about the Delegation in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

 

If you use a delegable formula within your app, but the result could only return proper records as expected, I think this issue may be related to SP List server. I agree with @RezaDorrani 's thought almost, there is an limit on the query performed on SP List Items.

More details about limits on SP List, please check the following article:

https://docs.microsoft.com/en-us/sharepoint/install/software-boundaries-and-limits

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (24,551)