Use-case library

78 practical Copilot and Power Platform use cases for awarding organisations. Open a use case to see details and confirm whether it works in practice.

Disclaimer: Always follow your organisation's internal guidance and policies regarding AI usage. The suggestions in this guide have been created to the best of accuracy, but Microsoft licensing, pricing and feature availability change frequently — treat them as a planning baseline, not a procurement quote.

Showing 78 of 78 use cases

Tier 5Medium to high - shared agents need testing and ownership risk

Use Computer use where no connector exists

Use an agent to navigate a legacy interface for repetitive work when a suitable API or connector is unavailable.

AI requiredCredits may apply

Where: Copilot Studio / Agent Builder

Tier 1Medium risk

Consolidate data from multiple files

Bring together tables or structured information from several files and ask AI to create one combined dataset or consistent summary.

AI required

Where: Excel / Analyst / Copilot Chat

Tier 4Medium to high - production tools need ownership and controls risk

Build an internal case-management app

Create an internal app to manage records, status, evidence, actions and ownership in one place.

AI optionalCredits may apply

Where: Advanced business tools

Tier 4Medium to high - production tools need ownership and controls risk

Monitor a web page for changes automatically

Check a specified web page on a schedule, compare it with the previous version and alert people when something changes.

AI optionalCredits may apply

Where: Advanced business tools

Tier 6High - shared or unattended services need stronger controls risk

Run unattended validation checks

Run scheduled or unattended checks against records and flag exceptions for review without requiring a person to start the process.

AI optionalCredits may apply

Where: Advanced enterprise guidance

Tier 6High - shared or unattended services need stronger controls risk

Run periodic access and lifecycle health checks

Periodically review Copilot licences, Cowork access, agents, connectors and automations to remove stale access, confirm owners and retire work that has ended.

AI optionalCredits may apply

Where: Advanced enterprise guidance

Tier 0AMedium - extracted values need checking where accuracy matters risk

Extract information from documents

Ask Copilot to pull out specified facts, dates, names, actions, values or other fields from one or more documents and present them in a structured list or table.

AI required

Where: Copilot Chat / Word

Tier 0ALow to medium risk

Ask questions about a document

Open, upload or reference a document and ask Copilot questions about what it contains, where something is mentioned or how different sections relate.

AI required

Where: Copilot Chat / Word

Tier 0AMedium - source information can be mapped incorrectly risk

Complete a template from source material

Open an existing template or structured document, reference one or more source documents and ask Copilot to draft content into the relevant sections.

AI required

Where: Copilot in Word

Tier 3Medium - AI output needs checking where errors matter risk

Classify incoming messages or documents

Use AI inside a workflow to label or route incoming content by topic, type or category.

AI requiredExtra credits needed

Where: Power Automate / AI Builder / prompts

Tier 0AMedium - information can be omitted or merged incorrectly risk

Consolidate multiple documents into one

Provide several source documents and ask Copilot to bring their information together into one structured draft.

AI required

Where: Copilot in Word / Copilot Chat

Tier 0Low risk

Have a voice conversation with Copilot

Use voice to ask questions, think out loud, explore ideas or discuss work without typing, where voice is available.

AI required

Where: Copilot voice-enabled experiences

Tier 6Low risk

Choose between Chat and delegated multi-step work

Use Chat for an interactive question or quick task; consider Cowork or another delegated capability when you have a defined multi-step job with a clear outcome.

No AI needed

Where: Advanced guidance / Copilot

Tier 0Low to medium - summaries can omit detail risk

Summarise content

Ask Copilot to shorten a long document, email thread or other content into the key points, actions or themes you need.

AI required

Where: Copilot Chat / Microsoft 365 apps

Tier 6Low risk

Diagnose a missing Copilot feature

Work out whether a missing feature is caused by licence, rollout, admin policy, permissions, region or billing configuration.

No AI needed

Where: Advanced guidance

Tier 6Low risk

Understand what your Copilot access includes

Check which capabilities are included in your current Microsoft 365 setup and which depend on a paid licence, admin enablement or usage-based capacity.

No AI needed

Where: Advanced guidance

Tier 1ALow to medium risk

Turn information into a plan

Give Copilot an objective plus relevant background and ask it to create a sequence of tasks, milestones, dependencies or next steps.

AI required

Where: Copilot Chat / Pages

Tier 1Medium risk

Create charts and explain what they show

Ask AI to create a suitable chart from a dataset and explain the main patterns, changes or outliers in plain language.

AI required

Where: Excel / Analyst

Tier 3Medium - AI output needs checking where errors matter risk

Extract information and file documents automatically

When a document arrives, use AI to extract required fields, write them to a table or system, rename the file and move it to a processed location.

AI requiredExtra credits needed

Where: Power Automate / AI Builder / prompts

Tier 5Medium to high - shared agents need testing and ownership risk

Build a public FAQ agent

Create an agent that answers common questions from a deliberately limited set of approved public information.

AI requiredCredits may apply

Where: Copilot Studio / Agent Builder

Tier 0Low - check important facts and decisions risk

Ask questions and explore ideas

Ask Copilot to explain something, suggest options, brainstorm approaches or help you think through a problem.

AI required

Where: Copilot Chat

Tier 6High - shared or unattended services need stronger controls risk

Automate repetitive data entry unattended

Use unattended automation for repetitive system entry where APIs or modern connectors are unavailable and the process is suitable for automation.

AI optionalCredits may apply

Where: Advanced enterprise guidance

Tier 5Medium to high - shared agents need testing and ownership risk

Build an internal support agent

Create an internal agent that answers repeatable staff questions and can hand off to a person or support process when needed.

AI requiredCredits may apply

Where: Copilot Studio / Agent Builder

Tier 3Medium - AI output needs checking where errors matter risk

Draft a response inside a workflow

Use AI to create a draft reply or acknowledgement from incoming information before it is reviewed or sent.

AI requiredExtra credits needed

Where: Power Automate / AI Builder / prompts

Tier 6High risk

Continuous document intake

Process submitted documents and route exceptions

AI requiredExtra credits needed

Where: Power Automate + AI Builder

Tier 0Low to medium - meaning can change during rewriting risk

Rewrite or improve text

Paste or reference text and ask Copilot to make it clearer, shorter, more formal, friendlier or easier to read.

AI required

Where: Copilot Chat / Word / Outlook

Tier 0ALow to medium - comparisons can miss detail risk

Compare documents

Ask Copilot to identify differences, additions, omissions or conflicting information across two or more documents.

AI required

Where: Copilot Chat / Word

Tier 5Medium to high - shared agents need testing and ownership risk

Build a process-guidance agent

Create an agent that helps users follow a defined process, gathers the right information and prepares the next step.

AI requiredCredits may apply

Where: Copilot Studio / Agent Builder

Tier 6High - shared or unattended services need stronger controls risk

Monitor external sources for change

Watch selected external sources, detect changes and alert the relevant owners for review.

AI optionalCredits may apply

Where: Advanced enterprise guidance

Tier 3Medium - AI output needs checking where errors matter risk

Extract actions, dates and owners from documents

Use AI to identify actions, deadlines, names or other specified fields in documents and pass them to the next workflow step.

AI requiredExtra credits needed

Where: Power Automate / AI Builder / prompts

Tier 0Low to medium - generated content needs review risk

Draft new content

Ask Copilot to create a first draft of an email, document, FAQ, report, briefing or other piece of content from your instructions.

AI required

Where: Copilot Chat / Word / Outlook

Tier 6High - shared or unattended services need stronger controls risk

Prepare records for downstream processing

Validate, organise and prepare records automatically before they enter a downstream production or operational process.

AI optionalCredits may apply

Where: Advanced enterprise guidance

Tier 3Medium risk

Summarise a batch of incoming content

Use AI inside a workflow to group themes and summarise a collection of responses, messages or documents.

AI requiredExtra credits needed

Where: Power Automate / AI Builder / prompts

Tier 1Medium - analysis can be wrong or misleading risk

Analyse data and find patterns

Give Copilot a table or dataset and ask questions about trends, outliers, changes over time or relationships between fields.

AI required

Where: Excel / Analyst / Copilot Chat

Tier 4Medium to high - production tools need ownership and controls risk

Connect to a line-of-business system

Use premium or custom connectors to move data between Microsoft 365 and another business system.

AI optionalCredits may apply

Where: Advanced business tools

Tier 2Low risk

Run an approval or checklist workflow

Move a piece of work through a repeatable set of checks, approvals or status changes and notify the right people at each step.

No AI needed

Where: Power Automate / Microsoft 365

Tier 6High - unmanaged or poorly understood agents can create data, access and lifecycle risk risk

Build an agent inventory before setting policy

IT first uses the Agent 365 registry to discover the agents already present across the tenant, then records each agent's owner, publisher, purpose, status, usage, data sources and governance state before deciding what to restrict or retire.

No AI needed

Where: Agent 365 / Microsoft 365 admin centre

Tier 3Medium risk

Translate content inside a workflow

Use AI to produce a draft translation as part of a repeatable process, with human review where accuracy matters.

AI requiredExtra credits needed

Where: Power Automate / AI Builder / prompts

Tier 5Medium to high - shared agents need testing and ownership risk

Build a change-impact agent

Create an agent that helps identify which documents, processes or teams may be affected when a source changes.

AI requiredCredits may apply

Where: Copilot Studio / Agent Builder

Tier 0Medium risk

Build a project note space

Keep sources, notes and draft actions for a qualification update

AI required

Where: Copilot Notebooks

Tier 3Medium risk

Read scanned documents with OCR

Use AI Builder or OCR to turn scans and images into machine-readable text for later workflow steps.

AI requiredExtra credits needed

Where: Power Automate / AI Builder / prompts

Tier 0Low risk

Convert chat output into a working page

Create an editable action plan from a Copilot answer

AI required

Where: Copilot Pages

Tier 2Low risk

Trigger a workflow when something changes

Start a workflow automatically when a file arrives, a record changes or another defined event occurs.

No AI needed

Where: Power Automate

Tier 4Medium to high - production tools need ownership and controls risk

Automate repetitive work in a legacy system

Use attended desktop automation or another supported approach to reduce repetitive data entry where no suitable API exists.

AI optionalCredits may apply

Where: Advanced business tools

Tier 6High - agents can surface information users are already permitted to access and can also be given additional governed identities, tools or connectors risk

Review agent access, knowledge sources and permissions

An administrator reviews a shared agent's knowledge sources, connectors, users, owner and effective access before wider publication, and repeats the review when the agent's purpose, owner or source data changes.

No AI needed

Where: Agent 365 / Microsoft 365 admin centre / Entra / Purview

Tier 5Medium to high - shared agents need testing and ownership risk

Build a public-information agent

Create an agent grounded only on selected public sources for consistent public answers.

AI requiredCredits may apply

Where: Copilot Studio / Agent Builder

Tier 2Low risk

Send scheduled reminders

Run a workflow on a schedule to remind people about dates, reviews, renewals or outstanding work.

No AI needed

Where: Power Automate / Microsoft 365

Tier 0Low risk

Create an outline or plan

Give Copilot an objective and ask it to turn the idea into a structured outline, agenda, plan or set of next steps.

AI required

Where: Copilot Chat / Word / Pages

Tier 6High - unknown ownership and unmanaged access increase operational and data risk risk

Find and triage unmanaged, ownerless and stale agents

IT uses the Agent 365 registry to identify unmanaged agents, agents without owners and low-activity agents, then checks business purpose and data access before deciding whether to assign an owner, block, retain or retire them.

No AI needed

Where: Agent 365 / Microsoft 365 admin centre

Tier 4Medium to high - production tools need ownership and controls risk

Build an operational dashboard

Bring together business data into a dashboard for monitoring volumes, status, performance or trends.

AI optionalCredits may apply

Where: Advanced business tools

Tier 3Medium risk

Check documents for missing information

Use AI to compare incoming documents with expected fields or sections and flag likely gaps for review.

AI requiredExtra credits needed

Where: Power Automate / AI Builder / prompts

Tier 5Medium to high - shared agents need testing and ownership risk

Operate a shared agent responsibly

Define owners, sources, testing, publishing, monitoring and review for an agent that other people rely on.

AI requiredCredits may apply

Where: Copilot Studio / Agent Builder

Tier 2Low risk

Track actions and remind owners

Store actions in a list or task system and automatically remind owners as due dates approach or pass.

No AI needed

Where: Power Automate / Microsoft 365

Tier 1Low to medium - verify calculations risk

Explain formulas and calculations

Ask Copilot to explain what a formula does, suggest a formula for a calculation or help diagnose why a result looks wrong.

AI required

Where: Excel / Copilot Chat

Tier 4Medium to high - production tools need ownership and controls risk

Ask AI to explain dashboard trends

Use AI to help interpret changes, patterns or anomalies shown in a dashboard.

AI optionalCredits may apply

Where: Advanced business tools

Tier 6High - shared or unattended services need stronger controls risk

Delegate a multi-step preparation task

Ask Cowork or another delegated capability to gather approved sources, create several draft outputs and prepare a defined deliverable across multiple steps.

AI optionalCredits may apply

Where: Advanced enterprise guidance

Tier 4Medium to high - production tools need ownership and controls risk

Build a document-checking app

Create an internal tool where users submit documents and receive structured checks or feedback before the next process step.

AI optionalCredits may apply

Where: Advanced business tools

Tier 0Low - use as challenge, not authority risk

Challenge an idea or plan

Ask Copilot to look for weaknesses, assumptions, missing questions, risks or alternative approaches in a draft idea or plan.

AI required

Where: Copilot Chat

Tier 3Medium risk

Summarise transcripts automatically

When a transcript becomes available, use AI to create a summary, action list or structured record for review.

AI requiredExtra credits needed

Where: Power Automate / AI Builder / prompts

Tier 6Medium - reduces risk of unexpected usage charges risk

Set Cowork spending limits before rollout

IT enables Cowork only for a pilot group, sets user or group-level spending limits and monitors Copilot Credit use before wider adoption.

No AI needed

Where: Microsoft 365 admin / Copilot Cowork cost controls

Tier 1AMedium - summaries can miss nuance risk

Summarise a meeting and its actions

Use available meeting content to produce a recap of key points, decisions, actions and open questions.

AI required

Where: Teams / Microsoft 365 Copilot

Tier 1ALow to medium risk

Catch up on what changed

Ask Copilot to help summarise relevant messages, meetings and files so you can understand what changed while you were away or focused elsewhere.

AI required

Where: Microsoft 365 Copilot

Tier 4Medium to high - production tools need ownership and controls risk

Measure AI value and ROI

Track time saved, quality, throughput, adoption, review effort and cost for selected AI use cases before scaling.

AI optionalCredits may apply

Where: Advanced business tools

Tier 2Low risk

Capture submissions into a list or table

When someone submits a form, automatically create a record in a List, table or another approved data store.

No AI needed

Where: Forms / Power Automate / Lists / SharePoint

Tier 6Medium - essential once agent numbers grow risk

Maintain an agent register

IT and governance teams keep a live register of every shared agent, its owner, source material, permissions, connectors, review date and retirement status.

AI optional

Where: Agent 365 / Microsoft 365 admin centre / governance register

Tier 1ALow to medium risk

Find previous decisions and context

Ask Copilot to help locate or summarise what was previously decided about a topic, using the work content you are permitted to access.

AI required

Where: Microsoft 365 Copilot

Tier 6High - these meetings can involve high-impact personal or case information risk

Decide when AI transcription and summarisation are appropriate for sensitive meetings

The AO sets a policy for sensitive meetings that distinguishes between permitted, restricted and prohibited uses of Teams transcription, Copilot summaries and meeting agents, based on the data involved, the purpose and the controls available.

AI optional

Where: Teams admin centre / Purview / governance process

Tier 2Low risk

Send automatic messages

When an event occurs, automatically send a confirmation, acknowledgement or notification by email or Teams.

No AI needed

Where: Power Automate / Outlook / Teams

Tier 6Medium - IT/security-only use case, not a general staff Copilot feature risk

Use Security Copilot for IT/security investigations

An IT/security team uses Security Copilot agents to support investigations across Defender, Entra, Intune or Purview, while monitoring included compute usage.

AI requiredCredits may apply

Where: Defender / Entra / Intune / Purview / Security Copilot

Tier 1AMedium - source quality and omissions matter risk

Research a topic

Ask Copilot or Researcher to investigate a topic, combine relevant sources and produce a structured briefing with source links.

AI required

Where: Copilot Chat / Researcher

Tier 1Medium risk

Explore trends in operational data

Combine or inspect operational datasets and ask Copilot to explain changes, peaks, recurring patterns or areas worth investigating.

AI required

Where: Excel / Analyst / Copilot Chat

Tier 2Low to medium - file rules need testing risk

Save, move or rename files automatically

Automatically save incoming files to the right location, rename them using a standard pattern or move them when processing is complete.

No AI needed

Where: Power Automate / OneDrive / SharePoint

Tier 1ALow to medium risk

Build a focused Notebook for a project

Bring selected files, notes and other relevant sources into one focused workspace so Copilot can help you explore the project without searching across everything.

AI required

Where: Copilot Notebooks

Tier 6Low risk

Choose the right Copilot surface

Match the task to Chat, an in-app Copilot experience, automation, an agent or delegated multi-step work.

No AI needed

Where: Advanced guidance

Tier 1ALow to medium risk

Prepare for a meeting

Ask Copilot to bring together relevant calendar, email, chat and file context so you can prepare questions, priorities and background before a meeting.

AI required

Where: Microsoft 365 Copilot

Tier 1ALow risk

Turn an AI answer into a shared working page

Take a useful Copilot response and turn it into an editable collaborative page for a team to refine together.

AI required

Where: Copilot Pages

Tier 1Medium risk

Use Analyst for deeper data analysis

Ask Analyst to explore one or more datasets, test patterns, create charts and produce a reproducible analysis for review.

AI requiredCredits may apply

Where: Microsoft 365 Copilot Analyst

Tier 0ALow to medium risk

Edit a document in place

Use in-app Copilot to change wording, structure, formatting or content directly inside the file you are already working on.

AI required

Where: Word / PowerPoint / Excel where supported