Intro We need to know a little “code” when working with Excel in Power Automate:WDL (Workflow Definition Language) to create functionsJSON to interpret the resultsTypeScript to create Office Scripts Learning Objectives ExcelExpressionsJSON parsing Description Download the Excel book with sample dataFor the January sheet update each row as follows:TotalSales = SalesStore1 + SalesStore2Profit = TotalSales – CostEstimatedProfit = 12 x ProfitExpand the solution to work for all sheetsAdvanced: Can you do the same with Office Scripts?