Showing results for 
Search instead for 
Did you mean: 

Delegable command in Collection

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.




Community Support
Community Support

Hi ManishM,


Please check this documentation about “Delegable data sources”:


So I am afraid that a Collection doesn’t support delegation.


About delegable functions, please check it at here:

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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.



Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (68,930)