Power Automate Office Scripts Basics: Difference between revisions
Jump to navigation
Jump to search
Lsokolowski1 (talk | contribs) (Created page with "{{Cat|JavaScript}} <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 {{Can I use your material}} == Introduction == Single module context * Accessing Scripts * Triggering Scripts in Power Automate * IntelliSense * Variables, Types and Int...") |
Lsokolowski1 (talk | contribs) mNo edit summary |
||
| Line 28: | Line 28: | ||
* Connection to SAP GUI through Scripting Engine | * Connection to SAP GUI through Scripting Engine | ||
--> | --> | ||
== 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 | |||
== Accessing Scripts == | |||
<syntaxhighlight lang="ts"> | |||
// comment | |||
let a: string = 'code' | |||
</syntaxhighlight> | |||
== Triggering Scripts in Power Automate == | |||
== IntelliSense == | |||
== Variables, Types and Interfaces == | |||
== Get & Set == | |||
== Basic Excel Actions == | |||
== If == | |||
== Loop == | |||
== Send and Return Data == | |||
== Additional functions == | |||
Revision as of 19:19, 10 December 2024
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
Accessing Scripts
// comment
let a: string = 'code'
