cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate III
Advocate III

Delegation limit (500-2000) workaround with ForAll (SharePoint list)

In this solution@mr-dang tried to explain how to work with delegation limit, however, it doesn's seem clear enough to me. What his solution does is basically: count all items, divide by 500 (or 2000) delegation limit, then repeat the data collection as many times as it needs to, to collect all data to a temp datatable.

 

My SharePoint list currently has 600 items, but the ID starts at 2300, as I removed all previous items. So the ID range in my list is 2300-2900. But let's say I need to collect data 2 times (2000 records per one time) using ForAll function, but I can't get the above solution to work.

 

I'd appreciate any help in pointing me in the right direction.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Delegation limit (500-2000) workaround with ForAll (SharePoint list)

Hi @GrischkePro 

If you are planning on having thousands of records, I would suggest that you start start looking into converting your data from SharePoint to either Sql  or Common Data Service.  You will run out of reasonable options once you have more than 4000 records in SharePoint unless you figure out a way to filter them down to less than 2k first.

View solution in original post

5 REPLIES 5
Highlighted
Helper V
Helper V

Re: Delegation limit (500-2000) workaround with ForAll (SharePoint list)

I might be misunderstanding your question but if your list only has 600 items, why not just increase your row limit to 1,000?  If you need to count it twice, then I'd just switch 1000 to 1,500 or 2000.  

 

To do this, go to file --> app setting --> advanced settings.  Go to data row limit for non-delegable queries and replace the 500 with whatever you want. 

Highlighted
Advocate III
Advocate III

Re: Delegation limit (500-2000) workaround with ForAll (SharePoint list)

This list is at testing stage. There will be thousands of items eventually. Increasing the limit to even 2000 will not help in the long run.
2000 is the maximum for that setting you’re suggesting.

Hope it makes sense.
Highlighted
Super User
Super User

Re: Delegation limit (500-2000) workaround with ForAll (SharePoint list)

Hi @GrischkePro 

If you are planning on having thousands of records, I would suggest that you start start looking into converting your data from SharePoint to either Sql  or Common Data Service.  You will run out of reasonable options once you have more than 4000 records in SharePoint unless you figure out a way to filter them down to less than 2k first.

View solution in original post

Highlighted
Advocate III
Advocate III

Re: Delegation limit (500-2000) workaround with ForAll (SharePoint list)


@Drrickryp wrote:

Hi @GrischkePro 

If you are planning on having thousands of records, I would suggest that you start start looking into converting your data from SharePoint to either Sql  or Common Data Service.  You will run out of reasonable options once you have more than 4000 records in SharePoint unless you figure out a way to filter them down to less than 2k first.


Please explain why I will run out of reasonable options? when I reach 4000 records?

When I say thousands, I meant up to 10,000 maximum in the next 5 or so years. What's unreasonable about this?

SharePoint is my only option at this moment in time.

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Delegation limit (500-2000) workaround with ForAll (SharePoint list)

Hmm...there is a trick using Flow that calls sharepoint search 🙂

I've done that in one of my demo apps described in this blog post: 
https://michalguzowski.pl/search-in-sharepoint-from-powerapps/

However to be coherent to best practices I'd suggest using delegation and/or changing your data source to SQL/CDS as @Drrickryp suggested

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

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,400)