Announcements
I want to use For All function on a table in Data Verse contains more than 8,000 records.However, The For All function only returns 2000 records ( I think due to delegation warning and it doesn't show the sign of delegation warning).How to do it ?
Hi @OussamaOsman,
Performance-wise I would not recommend looping through such a high amount of records with a ForAll() function. The 2000 limit is because that is the record fetching limit - meaning Power Apps cannot return more than 2000 records with a single call.What exactly would you like to achieve with the ForAll function? We might be able to find a more performant alternative solution.
If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
Hello @LaurensM ,Thank you for your reply.What I was trying to achieve is that I want to automate patch data into a table that has a lookup column based on a 8000+ records in dataverse tables.I solved this problem by extracting the table into excel, then collecting all the rows in the excel file into a collection and use for All on the collection itself.As you mentioned, the performance on high amount of records is bad but it's a one time thing.Regards.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 105 Most Valuable Professional
Haque 77
VASANTH KUMAR BALMADI 70
