How to use Office Scripts and Power Automate to do Boring Excel Tasks for You

Learn how to effortlessly run Office Scripts in Excel online, without even opening your files! Discover how to automate tasks across multiple Excel sheets and files seamlessly.

📌 What You'll Learn:
▪️ Create and Run Office Scripts: Discover how to record a script in Excel for tasks like formatting. We'll show you how to script for multiple sheets in a file.
▪️ Adjust Scripts for Broader Use: Modify your script to work on every sheet of your Excel file.
▪️ Seamless Integration with Power Automate: Learn to use Power Automate to run your script on all files in a folder, schedule tasks, and more.

In this video you'll learn how to trigger an Office Script with Power Automate in Microsoft Excel. Office Scripts in Excel on the web lets you automate your day-to-day tasks. It's like running a macro on the web. You can repeat your recorded Excel actions on different workbooks and worksheets without ever opening the files. You can run your script from your mobile, based on a schedule, or if something happens in another app. As we setup this Office Script, I'll show you how you can apply your script to each worksheet. So we'll use Office Scripts to loop through each sheet in the file.

In this step by step tutorial we'll create an office script that applies s special formatting to all sheets in an Excel file. The script should run not just on one file but on any file in a specific folder. With Power Automate we will loop though all files in a folder and if we come across an Excel file it will apply the script.

00:00 How to Run an Office Script in Excel With Power Automate
01:27 Recording an Office Script
03:17 How to Edit and Adjust an Office Script
06:36 How to Setup the Flow in Power Automate
10:49 Testing the Flow to Trigger the Office Script
11:34 Wrap Up

LINKS to related videos:

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #officescripts #powerautomate

[jchanning]

I love your honesty, even with the awkward comments and questions. Thank you for the content, it has taught me a lot!

[mistofstars]

Thanks Leila! I'm just getting into Power Automate and your videos are really helpful <3

[wayneedmondson]

Hi Leila. Office Scripts and Power Automate together looks very powerful! Thanks for sharing this example. Thumbs up!!

[bobhutchins]

Wow! I've been out of the Excel/Office loop for a couple of years and what a great surprise - a lot of really neat features have been added! Thanks for a wonderful tutorial!

[shaundicker]

Great video, I learnt so much, thanks Leila! I love how you explain things in your videos!

[mehdid.]

I learnt something new today, thanks a lot! I use Power Automate quite a lot but never used it with Excel scripts. Good to know!

[jeffkerr]

You have some of the best productivity content. Thanks so much

[derekeano]

Fantastic video, I learned so much. Beautifully presented and you have such a nice voice to listen to! Very pleasing to the ear.

[chh]

For me ... a lot to unpack here. But a flawless delivery (once again) ... and Leila's encouragement makes me curious. But I still have a long road to travel before I get "there".

As always ... thank you ... thank you ... thank you.

[prof.code-dude]

Wow!!! You changed your workplace! And as you said in your Q and A you made a video on this

[toughslaut]

I'm going to apply this to my daily/weekly/monthly work routine. Hope this will simplify my work which currently I think taking too much of my precious time.

[JSinc]

Hello Ms. Leila, Thank you for another great tutorial. I'm wondering if you can make a video on how to make a simple CRUD using Microsoft Forms or if its not possible maybe you can give some advice on how to make a formatted and ready to print webpage generated from an excel table that was populated from MS forms... Sorry for my bad English, hope you understand what I meant and want to achieve. thanks again...

[elvisosei]

As usual.... Always delivering the best tutorial. Thanks for this. Forever grateful

[jeremy]

The excel videos are really great and easy to follow. I wish you did videos on access. Everyone else is so dry or hard to understand.

[dc]

I did not realise how macros could be integrated with power animate.

I’ve been “stuck” in my personal exploration of power animate and watching you set up the script really helped a few things click.

This knowledge makes me hopeful. Thank you!

[IvanCortinas_ES]

Tremendous video!! Thank you Leila! Superb!!!

[FRANKWHITE]

Another great video! Thanks for sharing!!

[troyhenderson]

Just learning of Power Automate. Have downloaded and am ready to add it to my skills.

[autobusesMexico]

I love your voice, and your knowledge

[garyhanson]

Wow you have so much information. Now to put it in practice :-) thanks