web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Is ForAll is able to g...
Power Apps
Unanswered

Is ForAll is able to get more than 2000 record?

(0) ShareShare
ReportReport
Posted on by 162

This is my code:

matthew12333333_0-1658509515987.png

I'm collecting from a SharePoint List. I do not have a delegation warning right now (I have like 20 records). But my question is when I will have more than 2000, will the ForAll collect all the records? I'm confuse because there is no delegation warning, but I just want to make sure, because it's important that the ForAll will collect all the data.

Thank you!

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @matthew12333333 

    Delegation and record limit are two different things.  Delegation has to do with sending a query/criteria to a data source for the data source to be able to return records based on that.

    Record limit is the limit to how many records you can ever return from a datasource in one function.

    PowerApps is limited to 2000 records maximum.  You can never return more than 2000 records for any function.

     

    Your formula is using the ForAll backward though.  You are using it like a For Loop in some development language - which PowerApps is not.

     

    Your formula should be based on a Filter, not a ForAll with an If.  ForAll is a function that returns a table.  So trying to do functions in it, although might work, is not how it was designed.

     

    Your formula should be:

    Collect(EtapesFermees,
     Filter('Etape de traitement demandes DM1',
     Etape.Value = "Fermer"
     ).'ID de la demande'
    )

     

    The above is delegable, however, again, delegation and record limits are two different things and the above will only ever return 2000 or less records.

     

    I hope this is helpful for you.

  • matthew12333333 Profile Picture
    162 on at

    I don'T know why, but with this formula, the collection is with weird row names and it doesn'T collect the right row that I want.

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @matthew12333333 

    Can you show what you are seeing and have a question on?

  • matthew12333333 Profile Picture
    162 on at

    Finally it's seem all right, I have made this formula for getting 4000 records. I think it is the max:

    matthew12333333_0-1658512145709.png

     

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @matthew12333333 

    With that formula, you are performing 2 filters.  The max on a filter (and any data operation) will be 2000. So, two formulas times 2000 is going to give you a max of 4000.

     

    However, whenever I see someone trying to pull huge amounts of data into their app, I have to ask why?  PowerApps is not designed to be a big app with lots of data in it.  Think about it this way...what would an app be like that did a Google search, however, the app had to pull down every page on the internet so that it could search it in memory?

     

    This is why looking at delegable ways to get your data is key.  Just like the google search example, when you do a search, the search criteria is "delegated" to the search service and then it returns results.  Same should be considered as a design goal in a PowerApp.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 401 Most Valuable Professional

#2
11manish Profile Picture

11manish 201 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard