Announcements
If I am able to get all the records (more than 500) from a CDS table into collection, am I still restricted on commands like DISTINCT to read only 500 records even from collection? It is happening to me hence confirming and would also like to know list of commands that work on all entries in a collection.
Thanks
Manish
Hi ManishM,
Please check this documentation about “Delegable data sources”:https://powerapps.microsoft.com/en-us/tutorials/delegation-list/
So I am afraid that a Collection doesn’t support delegation.
About delegable functions, please check it at here:https://powerapps.microsoft.com/en-us/tutorials/delegation-overview/
Best regards, Mabel Mao
@v-yamao-msft thanks for confirming.
That's a bummer. I was under the impression that once data was in collection, most commands would work, and delegation was applicable only when retrieving info from data source.
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 350 Super User 2026 Season 2
M Bilal Khan 318
Mohsin Ali 220
