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: […]

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?
Please accept marketing-cookies to watch this content.

Write a comment