Hi, is it possible to retrieve aggregated data with the CDS Current Environment / List Records action?
Trying something super simple like:
<fetch aggregate='true' >
<entity name='account' >
<attribute name='accountcategorycode' alias='accountcategorycode' groupby='true' />
<attribute name='revenue' alias='revenue' aggregate='max' />
</entity>
</fetch>
Which is a very valid query, but running the flow gives me:
Key property 'accountid' of type 'Microsoft.Dynamics.CRM.account' is null. Key properties cannot have null values.
Of course I don't want to add the accountid attribute, as it would prevent me from getting the aggregation I want.

Report
All responses (
Answers (