I posted this thread about a year ago and much has changed with PowerApps since then. CDS has allowed more complicated conditions for filtering a datasource. It's expanded security to record level in preview. In that time, I had created a solution for pulling in all records in a datasource. Were it not for the limitations, I don't think I would have taken the time to figure out a work-around, and I'm happy that I had learned much since then. Knowing what I know now, I understand that the restriction has achieved performance gains.
That said, a year has passed, but the 500 record limitation is still in effect. For Dropbox and OneDrive, you can only read from the first 500, but you can write more to it that cannot be read. For CDS, you can read from all records, but you can only pull in 500 at a time with filters.
I ran some numbers and the effect of the 500 record limitation is significant enough to the PowerApps forum community:
- As of posting, there are about 3300 discussions in the PowerApps forum
- 228 of the discussions contained either "500," "delegation," or "delegate"
- This effectively means at least 6.8% of the discussions started on the forum are questions related to the 500 record limitation.
- By default, the forum shows 30 discussions on each page. So 6.8% means that of the 30 discussions on each page, readers can expect 2 of the discussions to be about delegation on average.

I'm bringing up the forum stats because Stack Overflow just had a blog post about how their users had just sought the answer to "How do I exit Vim" for the millionth time: "In the last year, How to exit the Vim editor has made up about .005% of question traffic." The question was so infamous that it had become a meme in good internet fun. The scope of engagement on Stack Overflow is far broader than the PowerApps forum, so a few decimals can be large. But since the PowerApps forum is primarily about connecting to data, creating apps, using apps, and flows, 6.8% is a fairly significant percentage for inquiry. It has become "a thing" since there is a new discussion started about it every day.
Obviously the forum community doesn't represent all PowerApps users. There's statistics that the PA team might know (maybe not, due to privacy) that could be more informative than the stats I presented:
- What percent of users of CDS regularly make calls to entities with more than 500 records? Sharepoint users?
- What's the average amount of records in a CDS entity?
- What's the percentage use of OneDrive/Dropbox/Google Drive vs. connections that have better delegation like CDS?
- Has 500 been enough for the PowerApps user target demographic?
- What data has/had informed the decision making to choose 500?
- How many pageviews has the reference page for delegation received compared to others?
Since it's been a year, and since there is a new discussion thread started each day about the 500 record limitation, can we get a blog post or a a stickied thread that communicates the current progress or future roadmap for delegation or accessing more than 500 records? I think that should clear up that question so it doesn't come up again and again.
@Meneghino @AmitLoh-Powerap @hpkeong
@GregLi @jonoluk