MS 365 business and Copilot integration with sharepoint not working

Question

I have a MS 365 business standard account. i want to build an agent to link data from my sharepoint library but it doesn't show up as an option when I try to build an agent.

Answer 1

Hi @Levin Schwartz

Thank you for sharing your concerns.

I understand that you are trying to build a custom agent in Copilot Studio and connect it to data from your SharePoint document library, however the SharePoint option (or your document library) is not appearing when you add a knowledge source. 

You could refer to the following AI guidance, with Microsoft 365 Business Standard, you can access Copilot Studio (provided your admin has assigned the Copilot Studio user permissions and credits). However, using SharePoint as a knowledge source for agents is considered enterprise data grounding, and this capability is subject to additional licensing or billing requirements. 

In particular, Microsoft 365 Business Standard does not include Microsoft 365 Copilot by default (Copilot is a separate add‑on license). When an agent needs to ground responses in SharePoint document libraries, Microsoft requires either a Microsoft 365 Copilot add‑on license, or Pay‑As‑You‑Go (usage‑based billing) enabled in the tenant. 

Without one of these, the “Create Agent” option in SharePoint may not appear. 

In Copilot Studio, SharePoint document libraries often do not show up when browsing knowledge sources, or appear in a limited way (such as recent items only, without full library selection or semantic search). 

If your goal is to build an agent that reliably uses SharePoint content with high‑quality semantic search (via Microsoft Graph), You could ask your Microsoft 365 admin to confirm Copilot Studio author permissions, and consider adding at least one Microsoft 365 Copilot add‑on license (Business Standard is eligible). Even a single Copilot license in the tenant can unlock and significantly improve SharePoint grounding and discovery for agents. 

Alternatively, your admin can enable Pay‑As‑You‑Go billing if you prefer a consumption‑based model instead of per‑user licensing. 

 

You can refer more via: Licensing and Cost Considerations for Copilot Extensibility Options | Microsoft Learn 

Please feel free to correct me if I misunderstood your request. If you have any additional concerns, feel free to comment below. I would be more than happy to assist. 

---

Note: Please follow the steps in [our documentation] to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 2

SharePoint-based agents and Microsoft 365 Copilot agents require specific Copilot licensing and permissions that aren’t included in Microsoft 365 Business Standard alone.

From the context:

• To create agents in SharePoint, a user must:
  1. Have a Microsoft 365 Copilot license or have pay-as-you-go for SharePoint agents enabled in the organization.
  2. Have edit permissions on the SharePoint site where the agent is created.
• Agent Builder in the Microsoft 365 Copilot app is part of the Microsoft 365 Copilot experience and is governed by Copilot licensing.

Because only a Business Standard license is mentioned, the SharePoint agent option and Copilot Agent Builder will not appear. Assigning an appropriate Microsoft 365 Copilot license (for example, Microsoft 365 Copilot or Microsoft 365 Copilot Business, as referenced in the context) or enabling pay-as-you-go for SharePoint agents is required before:

• “New → Agent” appears on a SharePoint site home page or document library.
• SharePoint content can be added as a knowledge source in Agent Builder.

After the correct Copilot license is assigned and has had time to propagate, and assuming edit permissions on the SharePoint site are in place, the options to build agents using SharePoint libraries should appear.

---

References:

• Create an agent in SharePoint
• Agent Builder in Microsoft 365 Copilot
• Agents FAQ for Microsoft 365
• Choose the right tool to build your declarative agent