25
Hi there,
I am trying to apply an orderby to an aggregate query and am getting the following error message back:
{"error":{"code":"0x80041134","message":"An alias is required for an order clause for an aggregate Query."}}
I understand what the error message is saying but am unclear on how to actually resolve the issue. Here is an example of the query:
.../incidents?$filter=statecode eq 0&$groupby((statuscode), aggregate($count as total))&$orderby=statuscode desc
Regards,
Andy
Hello Andy,
please have a look in the following:
Query Data using the Web API (Microsoft Dataverse) - Power Apps | Microsoft Docs
There are a lot of example that can help you to build your query correctly.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (