Running an office script in an excel file is quite simple. From excel, I will click on “automate -> automate work”:

On the right side, a template list will appear (left picture), scroll down to select “see all templates” (right picture):

From here, I will select this option:

In the other hand, I can create the flow from Power Automate directly by selecting “instant cloud flow”:

Click on the “+” to add a new step:

In the “search” field, put “excel run script” to select this option:

Then optionally, I can add a button, read Power Automate: add a Power Automate button to an excel file.

After clicking on the “run script”, I will fill all fields:

And that’s it for the flow:

I may get an error when testing my flow, mainly because of code lines. In fact, running from my desktop, they are working properly but running from the cloud, they may not, so make sure that code lines are referencing correctly. For instance:

• Instead to put copyFrom("A10:D15"), put copyFrom(workbook.getWorksheet("Sheet1").getRange("A10:D15"))
• Instead to put 01/01/2025, put 1/1/2025
• Etc.

NOTE:

• If the script will run in a table and I made some changes in my table, I will need to recreate the table and/or the sheet
• If possible, put the “run script” outside of “apply to each” and “condition”, it will run better

For my colleagues to use the flow, click “edit” in the “run only users” section:

Then fill up those fields:

NOTE:

• change “provided by run-only user” by your account
  
• If I have multiple scripts to run in multiple excel files, although as the owner, I don’t need to open all excel files or at least only 1 excel file, my colleagues will have to open all of them if not, the flow will get an error