Office Scripts and ALM: Best Practices for SharePoint and Power Automate

Do you want to learn how to use Office Scripts with SharePoint and Power Automate for ALM scenarios? In this video, you will see how to:

Create and run Office Scripts in Excel online to perform tasks that are not possible with Power Automate, such as calculating workdays.

Call Office Scripts from Power Automate using the Run Script from SharePoint Library action, which is more reliable and secure than the Run Script action.

Use environment variables to manage different Dev, Test, and Prod environments for your SharePoint sites, libraries, and Excel files.

Use the Graph API to get the drive IDs and file IDs for SharePoint libraries and Excel files, which are required for the Run Script from SharePoint Library action.

Use a Canvas App that I created to help you get the drive IDs and file IDs easily.

This video is intended to provide value and guidance for anyone who wants to use Office Scripts in their projects. You will also learn about the pitfalls and best practices of using Office Scripts with SharePoint and Power Automate.


Here's the link to the Canvas App repository on GitHub:

https://github.com/andresbiarge/Get-D...

I hope you like it!

PS: You can hire my consulting services through my personal website: https://www.andresbiarge.com


------------------------------------------

00:00 - Introduction and overview of the video topic

00:40 - How to create and run Office Scripts in Excel online

02:10 - How to call Office Scripts from Power Automate using the Run Script from SharePoint Library action

03:30 - Why you should avoid using the Run Script action and store Office Scripts in OneDrive

05:00 - How to use environment variables to manage different Dev, Test, and Prod environments for SharePoint and Excel

06:40 - How to use the Graph API to get the drive IDs and file IDs for SharePoint libraries and Excel files

08:10 - How to use my Canvas App to help you get the drive IDs and file IDs easily

09:20 - Conclusion and contact information

#powerautomate #officescripts #powerplatform #sharepointonline