This guide explains how to recreate the MSP Operations Commander agent in your own Microsoft 365 tenant. No client tenant access is required — everything runs in the MSP's own environment.
⚠️ The public demo uses fictional client and ticket data only. Do not commit real client data, tenant IDs, or secrets to this repository.
- A Microsoft 365 tenant with Microsoft Copilot Studio access
- Permission to create SharePoint lists
- Microsoft Work IQ available in the tenant (Work IQ Mail, Calendar, and SharePoint)
The agent is grounded in two structured SharePoint lists.
| Column | Type | Purpose |
|---|---|---|
| Client Name | Single line of text | Primary key used by the Client Context Switcher |
| Industry | Single line of text | e.g., Wealth Management, Investment Advisory |
| Primary Contact | Single line of text | Main client contact |
| Environment | Single line of text | e.g., Full Cloud, Hybrid |
| Compliance Notes | Multiple lines of text | Client-specific rules (e.g., "Do NOT delete accounts") |
| Archiving Tool | Single line of text | e.g., Global Relay, Smarsh, Redtail |
| Special Instructions | Multiple lines of text | Anything the engineer must know before acting |
| Column | Type | Purpose |
|---|---|---|
| Ticket Number | Single line of text | Unique ticket identifier |
| Client | Single line of text | Links the ticket to a client |
| Subject | Single line of text | Short description |
| Priority | Choice | Critical / High / Normal / Low |
| Status | Choice | Open / Waiting on Client / Resolved |
| Resolution | Multiple lines of text | What was done |
- Create a new agent in Microsoft Copilot Studio.
- Disable general knowledge so responses stay grounded in your verified SharePoint data.
- Add the two SharePoint lists above as knowledge sources.
| Workflow | Trigger phrase | Purpose |
|---|---|---|
| Client Context Switcher | "Working on <client>" | Loads the active client profile + ticket history |
| Compliance Guard | "Can I <risky action>?" | Checks the action against client compliance rules |
| Morning MSP Triage | "Start my day" | Builds a prioritized day plan |
| Evening MSP Review | "End my day" | Summarizes the day and previews tomorrow |
Use a Global.ClientName variable so the active client persists across all topics.
Turn on the following Work IQ tools so the agent uses real Microsoft 365 work context:
- Work IQ Mail — email context
- Work IQ Calendar — calendar and scheduling context
- Work IQ SharePoint — organizational documents and knowledge
Publish the agent to the Microsoft 365 Copilot and Microsoft Teams channels.
Part of the MSP Operations Commander project — Agents League Hackathon, Enterprise Agents Battle, June 2026.