Question

A project manager repeatedly performs the same multi-step routine each week: pulling status updates from a specific SharePoint site, checking a project tracker list, and drafting a formatted summary email for stakeholders using a fixed template. They want a reusable solution their whole team can trigger on demand without re-explaining the steps and data sources every time. Which approach best fits this need?

Accepted Answer

Create a custom Copilot agent scoped to the SharePoint site and tracker list with the reporting instructions and template built in

Answer

Use a standard Copilot chat session and re-enter the full prompt with all instructions each week

Answer

Ask Copilot in Word to summarize whatever document happens to be open at the time

Answer

Export the SharePoint data to a personal spreadsheet and manually write the email without Copilot