What Microsoft 365 integration connects to Dynamics 365
Mail and calendar
The Business Central add-in shows the sender's customer or vendor card, open documents and balances beside an email. It can also create a quote or invoice from it. Dynamics 365 Sales uses its own Outlook app and server-side synchronization to track mail and meetings against records.
- โContact insights beside each email
- โQuotes and invoices from the inbox
- โTracked mail against CRM records
Chat and collaboration
Paste a Business Central link into a chat and it expands into a card colleagues can read. You can link Dynamics 365 Sales records to Teams channels. So the account team shares files and conversation in one place.
- โShareable record cards
- โContact search from Teams
- โChannels tied to CRM records
Spreadsheets that post
Open in Excel exports any list with its filters. Edit in Excel goes further: users change lines and publish them back through the add-in, and Business Central still validates them.
- โJournal preparation in Excel
- โBulk price and item updates
- โFinancial reports exported with formulas
SharePoint and OneDrive
Business Central can save exported files and attachments to OneDrive. Dataverse apps can also store documents in SharePoint folders per record. So contracts and drawings stay out of personal drives.
- โRecord-level document folders
- โShared exports
- โMicrosoft 365 retention policies apply
Microsoft 365 integration setup nobody mentions in the demo
Each feature has an administrator step that is easy to miss. First, an admin must deploy the Outlook add-in for users or the whole organization in the Microsoft 365 admin center. Next, Teams policy must allow the Teams app. Also, an admin must switch on access through Microsoft 365 licenses in Business Central. Choose the permission set for those users with care. After all, it applies to every Microsoft 365 user in the tenant.
Dynamics 365 Sales needs a mailbox approval step before server-side synchronization will run. SharePoint document management needs a site structure agreed in advance. None of this is hard. But skipped steps are the main reason Microsoft 365 integration with Dynamics 365 sits unused after go-live.
The apps share sign-in too. Business Central, the Dynamics 365 apps and Microsoft 365 all use Microsoft Entra ID. So multifactor sign-in and conditional access policies you set once protect all of them.
Getting Microsoft 365 integration running in your tenant
- 1
Check the tenant
We confirm which Microsoft 365 plans you hold and who governs Teams and Outlook add-ins. We also check whether Business Central or Dataverse shares a tenant with your mailboxes.
- 2
Enable and secure
Together with your administrator, we switch on add-ins, Teams apps and document storage. We choose permission sets that show people what they need and nothing more.
- 3
Show each team its three features
Sales staff learn the Outlook pane, and accounts payable learns Edit in Excel for journals. Meanwhile, managers learn to share records in Teams. Short, role-specific sessions work better than one long demo.
- 4
Look at usage
A few weeks in, we check which features people use and fix whatever blocked the rest. Then we retire anything that is not earning its keep.
Everyday Dynamics 365 tasks that Microsoft 365 takes off the ERP screen
- โLooking up a customer's overdue balance before replying to their email
- โCopying an order number into a chat so a colleague can check it
- โRetyping a spreadsheet of journal lines into Business Central
- โSaving a signed contract to a desktop folder nobody else can find
- โForwarding a report as an attachment that is out of date by the next morning
- โChasing a manager by email for a purchase approval they could answer from Teams or Outlook

Microsoft 365 and Dynamics 365 questions
Do our Microsoft 365 users need a Business Central license to see data in Teams?
Not for reading. No, not to view it. Users with qualifying Microsoft 365 licenses can view shared Business Central data in Teams, once an administrator enables it and picks their permission set. Anyone who creates or changes records still needs a Business Central license. The admin setting and permission choice are part of our setup.
Can we keep using Excel for budgeting and journals?
Yes, and many finance teams should. Edit in Excel sends lines back through Business Central's own validation. So the data still has to be right before it posts. You can also export, adjust and import budgets the same way.
Does this work if Dynamics 365 is in a different tenant from our email?
Most of these features expect Dynamics 365 and Microsoft 365 to share one Microsoft Entra tenant. If they sit in different tenants, for example after an acquisition, several integrations will not work as designed. So we confirm the tenant setup first, and we recommend the cleanest route if you need a tenant move.
Where does Copilot fit?
Copilot features appear in Business Central, the Dynamics 365 apps and Microsoft 365, and Microsoft licenses some separately. They work best once the basic connections on this page are in place. That is because Copilot draws on the same data and permissions. Our Copilot page covers what each one does.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.
