Not sure where AI would pay off? Take the 3-minute opportunity check →
Productivity suite · Microsoft 365

AI automation for Microsoft 365

Most established service firms already run on Microsoft 365: Outlook for client email, SharePoint or OneDrive for files, Teams for internal chat, and Excel for everything that should have been a system. That makes it the most likely place for AI to help, and also the most likely place for AI to surface a file someone forgot was shared with the whole company.

InTheory is independent and not affiliated with Microsoft 365. Product names are trademarks of their owners.

Microsoft Copilot works inside Word, Excel, PowerPoint, Outlook and Teams. Microsoft describes it drafting emails and summarizing long threads in Outlook, and recapping meetings and action items in Teams. Microsoft also sells bundles such as Microsoft 365 Business Premium with Copilot. For cross-app workflows, Power Automate is included with many plans and is often enough before reaching for Zapier.

Practical automations

Shared inbox triage

Emails to info@ or service@ are categorized by request type, flagged for urgency and routed to the right person's folder, with a suggested reply for common questions.

Proposal and SOW first drafts

Staff ask Copilot in Word to draft a scope of work from a past proposal in SharePoint and the discovery notes. A senior person rewrites the pricing and commitments.

Long thread catch-up

Before a client call, Copilot in Outlook summarizes a long email chain with the client, including open questions and promised dates.

Excel report cleanup

Copilot in Excel helps build pivot tables and formulas for monthly job or utilization reports, so the office manager is not rebuilding the same sheet by hand.

Form to SharePoint list with approvals

A Microsoft Forms request, such as PTO or a purchase, lands in a SharePoint list and Power Automate routes it for approval, with an AI summary for the approver.

Internal policy Q&A

Copilot answers staff questions from the employee handbook and SOP documents stored in SharePoint, as long as those files are current and permissioned correctly.

Commonly connected to

SharePointPower AutomateDynamics 365HubSpotSalesforceQuickBooks OnlineClioZapier

Pitfalls to avoid

  • Rolling out Copilot before fixing SharePoint sharing, so it can surface salary sheets or client files to people who should not see them.
  • Buying licenses for everyone at once instead of piloting with the five people who write the most email.
  • Treating Copilot drafts of client advice or contract language as final.

When not to automate

If your files live on a local server or in personal OneDrive folders with no structure, Copilot will have little to work with and may find the wrong version. Fix file organization and permissions first. That project alone often saves more time than the AI.

Common questions

What should we fix before turning on Copilot?

Review who can see what in SharePoint, OneDrive and Teams. Copilot works within existing permissions, so anything overshared becomes easy to find. Clean up 'everyone' links, archive old sites, and label sensitive folders. Your IT provider can run an access report.

Copilot or Power Automate?

They solve different problems. Copilot helps a person write, summarize and analyze. Power Automate runs steps without a person, such as moving a form into a list and sending an approval. Many good workflows use both: Power Automate moves the data, Copilot drafts the summary.

How do we know if licenses are worth it?

Pilot with a small group for 60 days. Track time spent on email, meeting follow-up and first drafts before and after, and ask users weekly which tasks they actually used it for. Check current pricing with Microsoft, then decide who keeps a license.

Industries that use Microsoft 365

Next step

Bring one expensive workflow. Leave with a clear next step.

In 30 minutes we look at one recurring workflow, what it costs you today and whether there is a credible case to improve it. If there is not, we will say so.

Book a 30-minute workflow review Not ready to talk? Take the 3-minute check

30 minutes with Phil or Martin. No technical brief, no pitch deck. Phil or Martin replies personally, usually within one business day.

Book a 30-minute review