Tip #1451: Aggregates in Power Automate
There is no easy way to calculate aggregates in Power Automate, but there are a few options available. One option is to loop over the array and apply formulas, another is to use the Graph API and Excel formulas, and a third option is to use third-party connectors. However, if your data is coming from Dataverse or SharePoint, you can use FetchXml or CAML aggregations, respectively. Another option is to use Code-Only Connectors (CoC), which allow you to perform calculations using code. The CoC connector can aggregate arrays of numbers or objects and provide Excel-like aggregate functions such as Sum, Avg, StDev, Median, Min, Max, Product, and ModeSngl. There are plans to add more Code-Only Connectors in the future.
Article 13m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time