Flow / Power Automate - Excel: Link Excel Scripts and Power Automate Flows Video

Discover the world of automation with Microsoft Excel and Power Automate! Learn how to schedule the execution of an Excel script, automate filtering actions for US orders with pending payments, and create a clickable button to run the script easily. With these powerful tools, you can automate repetitive tasks and save valuable time. Happy automating!

03:22
121 views

00:00:08

In this video,

00:00:09

we will discover how to schedule the execution

00:00:12

of an Excel script with power automate.

00:00:15

You must distinguish two things here.

00:00:17

The script is a program similar to a Macro written in

00:00:21

VB A which will generate the actions to be automated.

00:00:25

The automate work button will allow you either to create a flow from a

00:00:29

template associated with this workbook and other

00:00:32

Microsoft 365 applications or to select a template

00:00:37

that you can then modify and adapt in power automate. In

00:00:40

this example,

00:00:41

we will use power automate solely to trigger the Excel script in a scheduled manner.

00:00:48

Imagine you are managing an Excel file containing a list

00:00:51

of customer orders with data such as the order,

00:00:54

date status and delivery country.

00:00:57

You want to automate a filtering script for us orders with pending payments.

00:01:02

Follow these simple steps.

00:01:04

Click on the automate tab in the Excel ribbon.

00:01:08

If this tab is not visible,

00:01:10

customize the display by right clicking on one of the menus

00:01:14

in the automate ribbon,

00:01:15

you will find sample scripts.

00:01:17

However, for our case, you will create your own script.

00:01:21

You can either write it in VB A language or record the actions to be automated.

00:01:26

Choose the recording option for simplicity,

00:01:28

start the recording and perform the filtering actions in your workbook,

00:01:32

filtering by country us and by status pending payment.

00:01:39

Stop the recording. Once the actions are complete.

00:01:42

If necessary, you can edit the script in VB A

00:01:45

or simply rename it for better organization.

00:01:50

Add a clickable button directly in the workbook to run the script easily

00:01:54

to schedule the execution of the script.

00:01:56

Click on automate work,

00:01:58

then select schedule an office script to run in Excel from the list of templates

00:02:04

if needed, rename the flow and click next.

00:02:07

For this example, we execute this script every week starting from November 1st

00:02:13

choose the script we designed, then confirm the set up of the flow

00:02:19

to test the button.

00:02:20

Manually remove the filters and click the button to check its functionality.

00:02:26

If the button changes proportions due to row hiding,

00:02:29

adjust its properties to disable automatic movement and resizing

00:02:35

test again to ensure everything works correctly.

00:02:41

Once the scheduled flow is created in power, automate, run it.

00:02:47

Once the execution is successfully completed,

00:02:50

open the Excel file and you will see that the script has run correctly

00:02:55

to ensure the script functions correctly.

00:02:57

We will proceed with a second verification,

00:03:00

change the status of an order and run the flow

00:03:02

again to verify that the modified row disappears as expected.

00:03:09

There you have it a functional example of a Planned Excel script via power automate.

00:03:14

With these powerful tools,

00:03:16

you can automate repetitive tasks and save valuable time, happy automating.

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This video is part of the following courses

122 Views

Microsoft Video Training Power Automate – From discovery to mastering automation

Boost your productivity with our Power Automate course! Learn to automate your tasks and seamlessly integrate various Microsoft 365 services...

ALL COURSES