Office Scripts Lesson 5: Run Scripts From Power Automate

⏱ 2 min read

In this article

The real power of Office Scripts: Power Automate can run them on a schedule or when something happens, with no one opening Excel.

Parameters and return values

function main(workbook: ExcelScript.Workbook, region: string): number {
  // ... calculate
  return total;
}

Extra parameters after workbook appear as inputs in Power Automate; the return value becomes dynamic content for later steps.

Scheduled cloud flow, daily at 8:00.
Excel Online (Business) › Run script: choose the file and script, enter region “North”.
Send an email with the script’s result.

💡 Throw an Error with a clear message when something is missing. The flow run then fails visibly with your message instead of emailing a wrong zero.

Scripts run up to a few minutes, and Power Automate limits daily script runs per user; fine for daily reports, not for thousands of runs.

Problem	Fix
Script not listed in the flow	Save it to the default Office Scripts folder in OneDrive
File locked	Close it in desktop Excel

That’s the Office Scripts course.

Create a Sales table and a Summary sheet, save the script, then call it from a scheduled flow.

📝
Lesson 5 Office ScriptPaste into Excel on the web > Automate > New Script.
⬇ TS · 636 B

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.

✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Model Free · AI can be wrong