AI Automation

Microsoft 365 Copilot & AI Playbook Hub - SharePoint, Outlook & CRM

AI & Microsoft 365 Automation Architect (Copilot Studio & Claude)

Business summary
Project Delivery & Commercial Knowledge Operations • Microsoft 365 Copilot Studio, Claude Team rollout & automated pre-filled standard forms catalogue
  • Rolled out Microsoft 365 Copilot Studio & Claude Team with strict Entra ID security trimming and AI governance policy
  • Built an automated catalogue of 18 standard project & commercial forms pre-filled (80%+) from SharePoint and CRM data
  • Co-authored shared project manager prompt playbooks and tracked 91% weekly team adoption in Power BI

What I built

Designed and rolled out an enterprise AI knowledge and form-automation hub combining Microsoft 365 Copilot Studio, Claude Team, and Power Automate across project management and commercial teams. Indexed governed SharePoint SOP libraries, project templates, and standard form catalogues with strict Entra ID security trimming so sensitive financial workbooks remained protected. Built automated Power Automate + AI flows that triage inbound Outlook enquiries, pre-fill standard project and compliance forms from live CRM/project records, and surface weekly adoption and time-saved metrics in Power BI.

Tech stack

Microsoft 365 CopilotCopilot StudioPower AutomateClaude AISharePoint OnlineClaudeOpenAISharePointMicrosoft TeamsOutlookEntra IDAI GovernanceDocument AutomationPrompt PlaybooksPower BI
Deep Dive Case Study

Microsoft 365 Copilot Studio, Claude AI & Automated Form Playbooks

Enterprise AI rollout, Microsoft 365 Copilot Studio agents, SharePoint knowledge-base grounding, and automated standard form pre-filling across project and commercial teams.


Snapshot

Role AI & Microsoft 365 Automation Architect
Stack Microsoft 365 Copilot · Copilot Studio · Claude Team / API · Power Automate · SharePoint Online · Microsoft Graph API · Power BI
Domain Project delivery, commercial operations, and enterprise knowledge management
Primary Users Project Managers, Commercial Estimators, Operations Leads, and Executive Leadership
Outcome Cut standard form preparation & project document lookup time by 65%; established company-wide AI governance policy and shared prompt playbooks

The Problem

Project managers and commercial leads were spending hours every week hunting through SharePoint folders, old email threads, and PDF specifications to answer routine project questions or fill out repetitive compliance, variation, and site-handover forms. At the same time, staff had started pasting company data into personal AI accounts without governance, creating both security risks and inconsistent outputs.


What I Built

1. Enterprise AI Governance Policy & Entra ID Data Boundaries

Before enabling AI tools across project data, I partnered with leadership to establish a clear, practical AI Use & Data Governance Policy:

  • Configured Entra ID security trimming and SharePoint sensitivity labels so Microsoft 365 Copilot and internal AI agents could only retrieve documents the querying user already had permission to view (strictly isolating HR, board, and confidential commercial pricing folders).
  • Set up the organization's managed Claude Team and Microsoft 365 Copilot workspaces with zero data-training retention enabled.

2. Custom Copilot Studio Agent & Shared Project Manager Playbooks

Built a domain-specific Microsoft Copilot Studio assistant grounded in the company's governed SharePoint SOPs, project templates, and historical lessons-learned library:

  • Co-designed a library of shared prompt playbooks with project managers for high-frequency tasks: summarizing weekly site progress notes, drafting client variation notices, extracting risk items from contractor emails, and checking tender compliance checklists.
  • Integrated custom Power Automate actions inside Copilot Studio so users can ask the assistant to look up live project metadata or log an action item directly into the project tracker.

3. Catalogue of Standard Forms with Automated Pre-Filled Answers

Replaced manual Word/Excel form filling with a Standard Forms Catalogue powered by SharePoint, Power Automate, and Claude/OpenAI structured extraction:

  • When a project manager selects a standard form (e.g., Site Inspection Checklist, Subcontractor Onboarding Pack, Client Handover Certificate), a Power Automate flow pulls the canonical project details, site address, contractor register, and key dates from the master project table and pre-fills 80%+ of the document automatically via Word Online merge templates.
  • For inbound email enquiries or PDF attachments, an AI extraction step pre-populates draft answers for human review before final sign-off.

What Did Not Work Initially (and How I Fixed It)

  • AI Hallucinations on Outdated Draft Documents in SharePoint: When Copilot first indexed the raw project folders, it surfaced figures from superseded v1_DRAFT spreadsheets alongside final signed documents. Fix: Created a clean Published-Approved SharePoint document view using metadata tags (Status = Approved) and restricted Copilot Studio's knowledge source strictly to approved, current revisions.
  • Low Initial Adoption Among Busy Site Managers: A blank chat prompt intimidated non-technical site staff. Fix: Replaced open-ended prompting with 1-click Adaptive Card buttons in Microsoft Teams and pre-built prompt templates ("Summarise this week's site blockers", "Pre-fill Form 04 for Scheme B") that require zero prompt-writing skill.

Deliverables & Handover

  • Company-wide AI Use Policy & Entra ID / SharePoint data-boundary configuration
  • Production Microsoft Copilot Studio agent + Claude Team shared prompt playbook library
  • Automated Catalogue of 18 Standard Project Forms with pre-filled SharePoint/CRM data
  • Power BI adoption & time-saved telemetry dashboard tracking weekly active usage by department