Recently I had a few cases in working with Power Automate and Dataverse Plugins where I had do stuff like sums and other things related to many records. Until I mostly gone the probably “most simple” way: Fetching all relevant records and iterate through them and do the calculation that was needed. Works okay but always felt a bit cumbersome 🤔
This time I wanted to try something new I always was there but until now had never tried: FetchXML aggregates.
Original Post https://nckr.de/posts/fetchxml-magic-aggregations-basics/