How to Master Power Automate Scripts
Image Source:
Nov 7, 2022 9:38 PM

How to Master Power Automate Scripts

External Blog Post

Office Scripts are an online version of VBA. Built to run in Excel online, it is similar to GoogleDocs App Scripts, but based on TypeScript instead of Javascrip

So this may note sound like a Power Automate script, but what you can do is call Office Scripts from Power Automate. Additionally you don't need to actually use the Excel side of the action, so they can extend the functionality of Power Automate, not just around missing functionality with Excel.

In this article I'm going to cover:

  • Accessing Scripts
  • Triggering Scripts in Power Automate
  • Intellisense
  • Variables, Types and Interfaces
  • Get & Set
  • Basic Excel Actions
  • If
  • Loop
  • Send and Return Data
  • Additional functions

Open full article