Copilot in SharePoint · 2 prompts

Copilot in SharePoint writes your weekly project update

If you've ever hunted through SharePoint folders, opened three versions of the same document and still couldn't tell what was going on, this is for you. Two prompts pull together where your project stands and turn it into an update you can share with your team.

Pamela in the video: Say what? Copilot is now available inside SharePoint?
The prompts

Two prompts, one team update

In the video I said to comment SHAREPOINT. This is that guide. You'll need a Microsoft 365 Copilot license from your work account.

  1. Open your project's document library in SharePoint, then open the folder that holds the project's files. If you'd rather not open it, select the folder in the library.
  2. Open Copilot. Select the Copilot button at the bottom right of the page and choose Ask a question. You can also open it from the agent icon at the top right. If another agent opens, pick Copilot in SharePoint from the dropdown next to its name.
  3. Paste the first prompt. Copilot reads the files in that folder and builds the update.
  4. Paste the second prompt to turn it into a short update for your team.
  5. Check the sources and make any corrections. Open the files Copilot points to, check every owner and deadline, and fix anything it got wrong before you share it.
  6. Check where each point came from. If Copilot doesn't link a file, ask: "Which files did you use for each point?" and open them before you share the update.
Prompt 1: the project update
Review the documents in this folder and create a weekly project update. Include progress, decisions, blockers, and next steps. Add owners and deadlines where they're documented and link to your sources. If anything is missing or conflicts, flag it. Don't guess.
Prompt 2: the team update
Turn this into a team update under 250 words. Start with what needs attention, then progress and next steps. Keep the source links.

Keep it to the project folder

What Copilot reads depends on what you have open. In the library with nothing selected, it looks at the whole library. With a folder selected, it looks at that folder. With files selected, it looks at those files, up to five at a time. Microsoft counts review across a very large set of documents as advanced work, which uses Copilot Credits your company pays for separately. Pointing it at one project folder keeps it focused.

Questions people ask

Quick answers

Can Copilot summarize a folder in SharePoint?

Yes. Open the document library, select the folder and open Copilot in SharePoint. With a folder selected, Copilot works from the files in that folder. With nothing selected it looks at the whole library, and with files selected it works from those files, up to five at a time.

What license do I need for Copilot in SharePoint?

You need a Microsoft 365 Copilot license. Everyday use, such as asking questions about your files and creating Word or PowerPoint files, is included. Work across very large sets of content, or AI automations that run on a schedule, uses Copilot Credits, which your admin turns on separately.

How do I open Copilot in SharePoint?

Select the Copilot button at the bottom right of a SharePoint page and choose Ask a question, or select the agent icon at the top right. If a different agent opens, choose Copilot in SharePoint from the dropdown next to its name. If you don't see it, your admin may have turned it off for that site.

Can Copilot in SharePoint write a weekly status report?

Yes. Ask it to review the documents in your project folder and create a weekly update with progress, decisions, blockers and next steps, with owners and deadlines and links to the sources. Then ask it to shorten that into a team update under 250 words. Check every owner and date against the files before you send it.

Can I reuse a prompt in Copilot in SharePoint?

Yes, by saving it as a skill. Ask Copilot to create a personal skill, describe the steps, review the draft and confirm. A personal skill is stored in your OneDrive and works on any SharePoint site you can open. Run it with Run [skill name] on this folder.

Free bonus

Keep every update with the project

One prompt that saves the team update as a Word file in the project folder, so last week's update is always one click away.

That didn't go through. Check your email address and try again.

Your bonus unlocks right here. You'll also get my newsletter now and then. Unsubscribe any time. Privacy

◆ Unlocked

Once the team update reads right, save it next to the documents it came from. Making a Word file from Copilot in SharePoint is included with the Microsoft 365 Copilot license.

Save the update as a Word file
Save this team update as a Word document in this folder. Name it [Project name] update [date]. Keep the headings and the source links.

Next week, run the same two prompts and save the new update the same way. The folder becomes your project history.

Keep going

More free guides

Prompts, step-by-step guides and checklists you can put to work today.

See all guides