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.
Login now to access my digest by 365.Training