Answered

Flow Run Script Action - Multiple Scripts

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I have a workbook in which is multiple sheets.

I have created a 'script' for each of the sheets, as the sheets are formatted slightly different.

I have created a flow with the trigger - ' When a file is created or modified (properties only).

I have a need to apply the corresponding script to its associated sheet.

I am using the 'Run Script' action in the flow. Can I choose more than one script in the script input of the action, or do I need to create a flow for each of the script actions?

The workbook is overwritten one or twice a day and several times week. The name of the workbook never changes and has the same four sheets.

My four scripts delete rows, change column formatting, and creates a table of the data on each sheet.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-hanytian-msft Microsoft Employee on at

Like (0)

Report

Hi @Phineas ,

You can Create just One Flow and have several actions for Run Script.

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

Yes, thank you.

I eventually figure that out.

Now, I need to know whether I can add 'Create item' actions to the same flow, that take the Excel table data and add it to a SharePoint list?

I tried to add four corresponding 'Ceate items' and the bottom of the flow and got table errors. The tables that need to be referenced in the 'Create item' actions are created by the 'Run Script' above. The consequence, Power Automate won't let me save the flow because the tables don't already exist.

Was this reply helpful? Yes No
Verified answer

v-hanytian-msft Microsoft Employee on at

Like (0)

Report

Hi @Phineas ，

If I have solved your first problem, please accept my post as a solution so that more people can solve the problem efficiently.
For new questions, we recommend that you create a new post so that more people can discover it.

Best Regards,
Tina

Was this reply helpful? Yes No