Intro

We need to know a little “code” when working with Excel in Power Automate:

  • WDL (Workflow Definition Language) to create functions
  • JSON to interpret the results
  • TypeScript to create Office Scripts

Learning Objectives

  • Excel
  • Expressions
  • JSON parsing

Description

  • Download the Excel book with sample data
  • For the January sheet update each row as follows:
    • TotalSales = SalesStore1 + SalesStore2
    • Profit = TotalSales – Cost
    • EstimatedProfit = 12 x Profit
  • Expand the solution to work for all sheets
  • Advanced: Can you do the same with Office Scripts?