Excel
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: […]
Table of Contents
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?