PL-500 Question #184: Real Exam Question with Answer & Explanation

Question

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. The schedule contains a Task table with details such as the names, email addresses, and start/end dates of individuals responsible for different months. Which actions should you perform to achieve this? (Choose three)

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

Explanation

{"question_number": 8, "question": "PowerUp Corporation wants to automate monthly email reminders using Office Scripts and Power Automate based on an Excel schedule...", "correct_answer": "A, C, and D", "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.", "generated_by": "claude-sonnet", "llm_judge_score": 4}

No community discussion yet for this question.