Friends Don't Let Friends Manipulate Data in Power Automate

Description

Power Automate is brilliant at connecting to systems and orchestrating processes. But when it comes to joining, grouping, aggregating or transforming data, things quickly get messy. Just because you can solve the problem with another Apply to Each and a clever expression doesn’t necessarily mean you should.

In this demo-heavy session, we’ll explore the point where Power Automate stops being the right tool for the job. We’ll look at ways to offload data manipulation to Excel, SQL, Power BI, Microsoft Fabric and Azure Functions, then bring the results back into your flow and carry on with the process.

You’ll leave with a practical way to decide when to use Power Automate, when to call for help, and which tool should get the job.

Calendar