Skip to content
Contact
Menu

Free tutorial

Excel

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

Anders Jensen Automation & AI Instructor

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?

More tutorials

  • Microsoft Power Automate

    Lessons for Microsoft Power Automate (cloud): approval flows, Excel, Outlook, forms, AI Builder, HTTP requests, error handling, and more.

    Read more →

  • Error Handling and Creating a Detailed Log

    Make sure your flows can handle when things don't go as expected: Error Handling and write a Log.

    Read more →

  • Forms

    Microsoft got Forms - a free survey application. And it integrates with Power Automate.

    Read more →

Comments (2)

These comments were migrated from the previous version of this site. Commenting is closed.

  1. Victory

    i will like to get the study file

    1. Stine Høiberg Rasmussen

      Hi Victory. Under "Description" follow the link "Download the Excel book with sample data" :) Kind regards, Stine