PowerUp Corporation wants to implement a solution using Office Scripts and Power Automate to automate the process of sending monthly email reminders based on a schedule stored in an Excel workbook…

Question

Options

• ACreate an Office Script
• BCreate an Instant Cloud Flow using Power Automate
• CCreate a Scheduled Cloud Flow using Power Automate
• DUse Excel Online to run the script
• EUse Compose action and add an expression

• A
  85% (22)
• B
  12% (3)
• E
  4% (1)

Explanation

Three actions are needed to accomplish this scenario. (A) Create an Office Script: an Office Script written in TypeScript is used to read the Task table in the Excel workbook, extract the relevant scheduling data (names, emails, start/end dates), and return it to the flow. (C) Create a Scheduled Cloud Flow: since reminders are monthly, a Scheduled Cloud Flow (not an Instant flow) is required to trigger automatically on a recurring monthly schedule without manual intervention. (D) Use Excel Online to run the script: within the Scheduled Cloud Flow, you use the 'Excel Online (Business)' connector's 'Run script' action to execute the Office Script against the workbook - this is how Office Scripts are invoked from Power Automate. An Instant Cloud Flow (B) is manually triggered and does not support scheduled automation. The Compose action with an expression (E) is not required for this workflow.

No community discussion yet for this question.