Friday 1:50 PM - 3:00 PM · Room 602:603

How to Execute JavaScript, TypeScript, and Excel Formulas In Power Automate

Mark Rackley

Group Manager, Modern Workplace Architect at Avanade

Power Automate has become an essential tool for the Microsoft 365 developer. However, all too often executing simple logic can become tedious and painful using Power Automate standard features. Doing math in Power Automate shouldn't be so painful!

Thankfully, Power Automate developers can now create scripts that use JavaScript, TypeScript, or even Excel formulas to execute complicated business logic and bring more power to your Power Automate solutions. Attend this demo-packed session to learn out to take your Power Automate Flows to the next level as we dive into a real-world scenario and build a practical solution step-by-step.

In this session, attendees will learn to use Office Scripts to:

• Execute JavaScript, TypeScript, and Excel Formulas
• Simplify complicated Flows
• How to quickly and easily generate dynamic adaptive cards
• Generate graphs and charts on the fly for real-time updates to SharePoint data