Power Automate - Fast Data Aggregation - Group By, Sum, Count


In this video, you'll learn how to efficiently group by, count, and sum values from a data source like SharePoint using Power Automate. The presenter demonstrates using the select function to get distinct values and convert JSON data into XML. They also show how to use XPath expressions with select to perform sum and count operations. Additionally, they introduce xpather.com, a free online tool for writing and testing XPath expressions. The video provides a complete solution for handling complex data aggregation scenarios in Power Automate Cloud Flow, using only 7 actions and API calls. No apply to each actions were used. Check out the efficiency playlist for more videos.


Video 15m

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