Build a Teams channel agent that drafts weekly status reports
Build an agent that compiles a Teams channel's conversations and linked meetings into a stakeholder-ready weekly update.
Set up a recurring "Monday status report" task that Copilot Cowork runs end-to-end each week instead of someone compiling it by hand.
A consistent weekly status update produced on schedule without taking up someone's Monday morning.
The apps run in this order.
Write the brief for what the weekly report should cover — project status changes, blockers raised in Teams, upcoming deadlines — and where it should be delivered (a Teams channel post, an Outlook email to the team).
Configure the task to run automatically on the same day and time each week, so it becomes a standing deliverable rather than something you have to remember to trigger.
Prompt idea:
Every Monday at 8am, compile a status update from the project tracker's changes this past week, any blockers flagged in the team Teams channel, and deadlines coming up in the next 7 days. Post it to the Project Updates channel.
Review the first 2-3 automated reports in detail before trusting the cadence unattended — this is where you catch a misread source or a formatting issue before it becomes a weekly habit.
Open the recurring task's configuration whenever a source changes — a tracker migrates to a new tool, the team moves to a different channel — and update the brief immediately rather than waiting for someone to notice the report quietly stopped reflecting reality.
Inspired by: Microsoft, Copilot Cowork blog, 2026.
A weekly status update delivered to the team on a set schedule, pulled from the same sources every time.
Listing deadlines in the next 7 days is a date filter. Reading what was actually flagged as a blocker in Teams chat, versus just discussed, is the part that needs language understanding.
Build an agent that compiles a Teams channel's conversations and linked meetings into a stakeholder-ready weekly update.
Pull Outlook, Teams, OneDrive and SharePoint into one prioritized briefing that gets you ready for a full week of meetings in one pass.
You have a budget export, a status report, and an email thread — and they disagree.
It's end of quarter and the raw numbers just came in.
Get practical help with AI consulting or ask about training courses for your team.