web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow Run Script Action...
Power Automate
Answered

Flow Run Script Action - Multiple Scripts

(0) ShareShare
ReportReport
Posted on by 5,331 Moderator

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:
I have the same question (0)
  • v-hanytian-msft Profile Picture
    Microsoft Employee on at

    Hi @Phineas ,

     

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

    vhanytianmsft_0-1694054995322.png


    Hope this will help you,

    Best Regards,
    Tina

  • Phineas Profile Picture
    5,331 Moderator on at

    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.

  • Verified answer
    v-hanytian-msft Profile Picture
    Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 552

#2
Valantis Profile Picture

Valantis 388

#3
11manish Profile Picture

11manish 375

Last 30 days Overall leaderboard