Aggregate, summing data from dataverse

[ingovals]

So I have a collection of data from Dataverse that I need to get, and I also need to get the totals of it for further calculations.

There are so many ways of solving this but not a single one of them seem to work.

• Issues with filtering when trying to create it as a rollup column ( property I want to filter on just doesn't appear )
• Aggregate function in the dataverse web api, $apply=groupby((star_supertype),aggregate(star_value with sum as total)) just doesnt exist in dataverse it seems.
• Aggragate sum in Power Automate, just not there.

Any pointers, I'm mostly hoping here for how I can use the $apply thing to query dataverse.

[grantjenkins · Accepted solution]

If you can get the full data into Power Automate, then we can aggregate the data by converting to XML then using XPath.

Happy to try and build what you're after but would need to see the actual JSON output (obfuscated is fine to hide any confidential data) that we would get in Power Automate, and details of what you're trying to aggregate.