Power Automate Office Scripts Basics
<slideshow style="nobleprog" headingmark="⌘" incmark="…" scaled="true" font="Trebuchet MS" >
- title
- Power Automate Office Scripts Basics
- author
- Lukasz Sokolowski
</slideshow>
Power Automate Office Scripts Basics
Power Automate Office Scripts Basics Training Materials
Copyright Notice
Copyright © 2004-2025 by NobleProg Limited All rights reserved.
This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise.
Introduction
Single module context
- 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
Intro Con't
Office Scripts
- Online version of VBA
- Built to run in Excel online
- similar to GoogleDocs App Scripts, but based on TypeScript instead of Javascript
- TS is a subset of JS, so we can use JS as well
- More here
Accessing Scripts
// comment
let a: string = 'code'
