Cowork + Plugins Hands-On Lab

Use Copilot Cowork to draft emails and build a SharePoint sales dashboard in 30 minutes, with optional Extra Credit on skills and plugins.

Content last updated: 10/19/2026

Level 200 30 min Core Learning Path Report an issue

Cowork + Plugins Hands-On Lab

Delegate real work to Copilot Cowork — hand it a document, let it reason over the content, and have it take action on your behalf while you get on with something else.

Lab Details

Level	Persona	Duration	Purpose
200	Business User	30 minutes	After completing this lab, participants will be able to delegate document-grounded tasks to Copilot Cowork, create an interactive dashboard from SharePoint data, and verify Outlook drafts before sending.

Introduction
Prerequisites
Use Cases Covered
Instructions by Use Case

Introduction

This lab accompanies Cowork (+ skills, + plugins) in the Deep dive in modern agents workshop.

Copilot Cowork takes a delegated task and works it agentically: reading source material, resolving who and what it needs from your organisation, and producing real output in Microsoft 365 — a drafted email, a document, a set of updates — for you to review before anything is sent.

In this lab you ask Cowork to draft an executive email from a hotel performance report, then start a separate task to find sales data in SharePoint, build an interactive dashboard, and draft a summary email with a graphic attached. In both use cases, you verify the output in Outlook without sending it.

The optional Extra Credit exercise adds a shared RFP Response plugin to Cowork and uses its bundled skill to generate a proposal as Markdown and PDF files. It is outside the 30-minute core lab.

Prerequisites

A Microsoft 365 account with a Microsoft 365 Copilot licence
Access to Copilot Cowork
Outlook available to the same account, so the drafted email can be verified
A colleague named Dewain Robinson who resolves in the tenant directory, or a facilitator-provided recipient substituted consistently in both use cases
Download the sample report PDF: Contoso Grand Hotel Performance Report
For Use Case #2: a sales tracker Excel workbook in a SharePoint document library the account can reach, with columns covering month, region, product line, and sales rep — the reference tenant uses Sales.xlsx in the Sales Lab1b document library
For Use Case #2: access to Claude > Opus 5 in the Cowork model picker, as used in the dashboard instructions
For optional Extra Credit only: the RFP Response plugin published by the facilitator and shared with your account in Cowork. Confirm it appears under Customize > Plugins > Shared with me before starting; if it is missing, ask the facilitator to share it. You do not need to complete the Skills lab or create a Copilot Studio agent or workflow.

Use Cases Covered

Step	Use Case	Value added	Effort
1	Draft an executive email with the Cowork agent from a PDF report	Cowork takes agentic action: reads the PDF, resolves the recipient, and drafts a real Outlook email on your behalf	10 min
2	Build an interactive sales dashboard from SharePoint and draft the summary email	Cowork locates the workbook through Work IQ, extracts the data, builds an interactive HTML dashboard, and drafts an email with a graphic attached	20 min
EC	Extra Credit: Using skills and plugins in Copilot Cowork	Install a shared plugin and use its bundled skill to generate an RFP response (Optional)	~6 min

Instructions by Use Case

Use Case #1: Draft an executive email with the Cowork agent from a PDF report

If Researcher (the Researcher exercise in Lab 1) is still reasoning in the background, that’s fine — you can run Cowork in parallel. Switch to Cowork to do something purely conversational agents cannot: agentically read a complex business document, look up the right recipient in your organization, and draft a complete email in Outlook — ready for you to review and send.

Use case	Value added	Estimated effort
Draft an executive email with Cowork	Cowork takes agentic action: reads the PDF, resolves the recipient, and drafts a real Outlook email on your behalf	10 minutes

Summary of tasks

In this section, you’ll upload the same Contoso PDF to the Cowork agent, ask it to draft an email to a specific colleague summarizing the most urgent operational issues, and then verify the draft was created in Outlook.

Scenario: You’re an operations lead at the Contoso Grand Hotel and need to brief your colleague Dewain on the most pressing issues from the annual performance report. Rather than writing the email yourself, you’ll let Cowork extract the key facts from the report and draft the email — addressed to Dewain, ready for you to review, edit, and send.

Objective

Use the Cowork agent to read the same PDF report you uploaded to Researcher, identify five operational issues with root causes and recommendations, and have Cowork draft a real Outlook email to a named recipient (Dewain Robinson).

Step-by-step instructions

Open the Cowork agent

From the same Microsoft 365 Copilot page (https://m365.cloud.microsoft/chat/?auth=2&home=1), select Cowork on the Chat / Cowork toggle at the top of the Copilot panel.

Take a moment to orient before you type anything. The message input reads Start a task…, not “ask me anything” — and that wording is the distinction this whole lab is about: you are handing over an outcome, not opening a conversation. In the left rail, My tasks is where delegated work appears while it runs, Automations is for work you want to recur, and below those Cowork lists your previous sessions.

[!TIP] Cowork is generally available in Microsoft 365 Copilot and is purpose-built for agentic action-taking: it can read documents, look up people in your tenant, and create real Outlook drafts / Word docs / Teams messages on your behalf. While Researcher excels at deep analysis and Analyst at data and computation, Cowork excels at completing multi-step tasks that span several Microsoft 365 surfaces.

Upload the report and ask Cowork to draft an email

Click Add attachments (the paperclip icon next to the message input), then choose Upload images and files (PDF, Word, Excel, images). Select the Contoso_Grand_Hotel_Performance_Report.pdf file you downloaded for the Researcher exercise in Lab 1.
Wait for the upload to complete — the PDF will appear as a chip above the message input.

[!TIP] Uploading is not the only way to give Cowork a file. While editing a prompt, press # to pick one straight from OneDrive — and in Use Case #2 you’ll use a third route, where Cowork finds the file itself and you never name a location at all.

Paste the following prompt into the message input and press Send:

 Create a draft email in my Outlook mailbox addressed to Dewain Robinson summarizing the five most urgent operational issues from the attached hotel performance report. Use the Outlook draft tool — do not just write the email text in chat.

 For each issue, include in one short bullet: the symptom, the root cause, the estimated financial impact, and the matching recommendation (Section 16 R-number).

 Address the email "Hi Dewain," and sign it from "The Operations Team". Keep the total email under 400 words. Use the PDF as the only source.

[!TIP] Cowork executes this as a multi-step task: (1) reads the attached PDF, (2) looks up “Dewain Robinson” through Work IQ, (3) drafts a new email in your Outlook mailbox, (4) reports back in chat when done. Unlike Researcher, Cowork rarely asks clarifying questions — when the prompt is clear, it just acts, and typically completes in ~2–3 minutes.

Observe how the Cowork agent:
- Streams execution updates (e.g., “Reading PDF”, “Searching for Dewain Robinson”, “Drafting email in Outlook”)
- Confirms the recipient resolved correctly (e.g., “Drafted email to Dewain Robinson”)
- Reports back inline in chat with a summary of the email it created and ends with “Open it in Outlook to review, edit, or send”

Verify the draft in Outlook

Open the app launcher (the 3×3 dot “waffle” icon at the top-left of the page) and select Outlook. Outlook opens in a new browser tab.

[!IMPORTANT] On your first Outlook visit, a “Your privacy matters” prompt may appear — click Continue to dismiss it. After that, the Outlook UI is ready for use.
In the Outlook left rail, click the Drafts folder. Find the email Cowork just created at the top of the list — the subject will mention the Contoso Grand Hotel performance report and the urgent operational issues (Cowork phrases the subject conversationally, so the exact wording varies). Click it to open.
Review the draft:
- Recipient: Dewain Robinson (resolved as a contact pill — hover or click the pill to see the SMTP address)
- Subject: mentions the Contoso Grand Hotel report and the urgent operational issues (Cowork-generated wording — exact text varies)
- Body: five bullets, each covering symptom + root cause + financial impact + recommendation R-number
- Sign-off: “Best regards, The Operations Team”
- Total: approximately 300–400 words
From here you can edit, send, or delete the draft as you would any other Outlook email. For this lab, leave it as a draft (or delete it) — no need to actually send.

[!TIP] Cowork appends a Sent by Copilot Cowork footer to drafts it creates. You can remove that line before sending if you prefer a clean signature.

[!TIP] By now, head back to the Researcher exercise in Lab 1 and check whether Researcher has finished. If it has, compare the two outputs side-by-side: Researcher gives you a deep analytical breakdown, Cowork gives you an actionable email ready to send. Each is the right tool for a different job.

Congratulations! You’ve used Cowork to draft an executive email from a PDF report!

Test your understanding

Key takeaways:

Cowork takes agentic action — It doesn’t just summarize. It reads a document, resolves a person in your org, and creates real artifacts (an Outlook draft, a Word doc, a Teams message) that are ready for you to review.
No clarifying-question round-trip — When the prompt is clear and directive (“Draft an email to X about Y, address as Z, sign as W”), Cowork proceeds without asking follow-ups. The cost of being specific is a faster, more deterministic result.
Cross-app integration — The result lives in Outlook, not in the chat. Cowork pivots the M365 experience from “answer in chat” to “complete the task in the right app”.
Parallel work pays off — Cowork is a great companion to Researcher: while Researcher reasons in the background, Cowork drafts a real artifact you can ship in a fraction of the time.

Challenge: Apply this to your own use case

What weekly emails do you draft from the same source data? Could Cowork generate the first draft?
Which Microsoft 365 documents would you ask Cowork to read — project status reports, meeting notes, customer feedback summaries?
Beyond email, Cowork can draft Word documents and Teams messages — what scenarios in your work would benefit from that kind of agentic drafting?

Use Case #2: Build an interactive sales dashboard from SharePoint and draft the summary email

Use Case #1 handed Cowork a file you uploaded and asked for one artifact. This one gives it neither. You don’t say where the file is, and a single instruction has to carry Cowork across four surfaces — find, extract, build, draft.

Use case	Value added	Estimated effort
Build a sales dashboard and draft the summary email	Cowork locates the workbook through Work IQ, extracts the data, builds an interactive HTML dashboard, and drafts an email with a graphic attached	20 minutes

Summary of tasks

In this section, you’ll give Cowork one instruction that spans four surfaces: it locates a sales tracker workbook in SharePoint using Work IQ, extracts the data, builds an interactive HTML dashboard, and drafts an Outlook email to a named colleague with a chart from that dashboard attached.

Scenario: You’re a sales operations analyst. The sales tracker lives somewhere in SharePoint, and Dewain Robinson needs a readable summary with a sales visual he can preview without opening and interpreting the source workbook. Rather than building the charts yourself and assembling the email in Outlook, you’ll delegate the whole chain in one prompt and watch Cowork work through it.