copilot in sharepoint
64 TopicsMicrosoft 365 Copilot licensing confusion
In the SharePoint Agent preview (ended in October 2025), Microsoft permitted unlicensed users to access SharePoint agents. I guess the reason for it was to enable organizations to evaluate agent functionality and provide feedback before licensing and billing requirements were applied (?). After the preview period concluded, it now seems that all users are required to have a Microsoft 365 Copilot Add-On license to interact with SharePoint agents. Users with, for example, a Microsoft 365 E3 license can only access the free version of Copilot (Copilot Chat), but do not have interaction privileges with SharePoint agents. A while ago, one of our CSP partners recommended us to buy a capacity pack and set up pay-as-you-go billing. In their opinion, this would replace the need for the Microsoft 365 Copilot Add-On license. However, we do not want to buy these expensive package unless we know for sure that this is the case. Can anyone answer the question: Does using a capacity pack and pay-as-you-go billing override user license requirements? Thank you ❤️Solved327Views2likes4CommentsCopilot searching SharePoint inconsistent
I realize that using SharePoint search to search SharePoint works great, but noticed that many times I ask Copilot for information that I KNOW is in our SharePoint, the results are poor. As test, I searched for a simple last name of one of our team from SharePoint and got 80 or so results. When I asked Copilot to "give me a list of every file where xxxx is found", it came back with 6 results. Why the discrepancy and how do we go about making this more reliable?327Views3likes3CommentsCoPilot Agents - Word Tables
Hi, We have been trying to create a CoPilot agent within the business that can read data in a referenced folder within SharePoint and output a summary. Now the prompt I'm using works perfectly when using the "Researcher" agent within CoPilot, but when I use it in the agent the output is very different. For added context. I have made a SharePoint site which has a folder for each project and then all the docs relating to that project within. The user says to the agent, "give me a project overview for QXXXX", what should happen is, the agent finds that folder, which it's seemingly doing and it provides all the info in the layout I've mentioned in the prompt. So it can find the right folder, and it gives a good overview of the project. But any information that's within a table in word, it doesn't retrieve, I've even told it what document has the content in the table it should be bringing back and it says it can't read tables in Word. When I've researched this it seems to be the way CoPilot interprets the data is different depending whether you upload the file or just reference it like my agent is doing. Then in Researcher alternatively, I copy and paste the prompt into the text box, attach cloud files and select the project folder and the output is perfect. It retrieves all the content, dates etc and it's exactly what we need. My aim was to make an agent that can do the same but doesn't require the user to attach the folder, they can just give it the project number and it does it's thing. I'm still pretty new to agents, and appreciate it's still slightly new, but it doesn't feel like it should be doing that. Would anyone with some expertise in agents be able to assist in me fixing this? And if possible, be available via email for me to ask some further questions? Happy to provide any further information if needed. Thanks67Views1like2CommentsOverview of Copilot solutions and Key Benefits
Copilot isn’t one-size-fits-all. Each solution addresses different organizational needs. Here’s what they do—and why they matter. Microsoft 365 Copilot Chat is a conversational experience on web and mobile that delivers quick, context-aware answers from organizational data. It provides quick, context-aware answers from organizational data, improving responsiveness across departments while supporting mobile work scenarios. Microsoft 365 Copilot is an AI assistant built into Word, Excel, PowerPoint, Outlook, and Teams. It accelerates document creation, data analysis, and presentations and helps you catch up on meetings and messages. Copilot uses the context you already have in Microsoft 365—files, emails, chats, and calendars—through Microsoft Graph and respects the same permissions, security, and compliance your organization relies on. Microsoft Copilot Studio is a platform for extensibility and customization. It lets you build custom copilots and extend existing ones without writing code. Copilot Studio allows businesses to tailor AI to unique workflows without heavy development investment, accelerating innovation. Key benefits for organizations Copilot delivers three core benefits that impact the entire organization: Benefit How benefit achieved Example scenario Boost productivity by automating repetitive tasks. Copilot automates repetitive tasks and accelerates content creation across teams. A marketing team might use Copilot in Word to draft campaign briefs based on brand guidelines, reducing turnaround time from days to hours. Improve decision quality with data-driven insights. Copilot provides fast, data-driven insights, enabling better decisions at every level. An operations team might use Copilot in Excel to analyze supply chain data and identify cost-saving opportunities before quarterly reviews. Strengthen governance with enterprise-grade compliance. Copilot respects enterprise security and compliance standards, ensuring sensitive data stays protected. When legal teams draft contracts, Copilot uses only authorized organizational data through Microsoft Graph, maintaining compliance with internal policies and regulatory requirements.388Views0likes2CommentsConnecting SharePoint Data to Copilot Insights A Complete Guide to Smarter Collaboration
AI is changing the workplace very fast than any other time. Using Microsoft 365 Copilot can help organizations get the true potential of their internal knowledge. SharePoint as the backbone of content and collaboration becomes even more powerful when connected to Copilot Insights. The integration between SharePoint and Copilot Insights gives the chance to users ask natural questions about their organization’s data and receive instant, intelligent answers, with no more digging through folders or chasing document versions. In this blog, we will walkthrough exploring why connecting SharePoint to Copilot Insights matters, how to configure your tenant for maximum success.118Views0likes1CommentMaking CoPilot Work for our Organisation
We're currently exploring how Microsoft Copilot can be used to support our bid writing process, and I’d really appreciate some insights or examples from others who’ve tried anything similar or just have a good understanding of CoPilot. What We’re Trying to Do We’d like Copilot to help us write and draft bid responses by referencing information already stored across our SharePoint libraries — including past bids, case studies, and company information — and then generate new content in our tone, structure, and style. In essence, we want Copilot to act like an “internal bid writer” that knows our history and can draw on it intelligently when producing answers. What We’re Trying to Understand I’m trying to get clarity on a few key things: What does GPT-5.0 actually bring to Copilot — is it just better reasoning and writing, or does it enable deeper integration with our Microsoft 365 data? What do we need to do (technically or in terms of setup) to let Copilot “see” our environment — e.g., access our SharePoint libraries and use that content effectively? I've saw some things around Microsoft Graph being enabled. What’s the practical difference between using Copilot and using ChatGPT for this type of work? We’ve also tried getting Copilot to fill in Excel sheets using data from SharePoint, but it doesn’t seem to behave as we expected. Is this something Copilot can’t currently do, or are we just approaching it the wrong way? What We’d Love to Learn What are the best practices for helping Copilot understand and use your SharePoint content effectively? Has anyone successfully used Copilot for bids, PQQs, tenders, or document generation? Any examples or use cases you can share of how you’ve made Copilot genuinely useful in a business context would be hugely appreciated. Thanks in advance — it’d be great to hear how others are making the most of Copilot in real-world scenarios.Solved207Views0likes3CommentsSharePoint Knowledge Agent Vs Power automate AI builder
If we want to classify, summarize and extract key info from documents uploaded/edited inside a SharePoint document libraries. seems we can do this using AI builder inside power automate which get triggered when add/edit a document or using the Knowledge Agent, mainly the "Organize this library" option. can any one advice when you use each?56Views0likes0CommentsSo many different CoPilots - confusing, unproductive
I think we have all learned that CoPilot is a brand, a suite of tools. That probably makes sense from Microsoft perspective, but it is confusing as heck for end users or people trying to roll out CoPilot in a company. Products include: Sharepoint agents CoPilot desktop app Copilot in Office apps -- different copilots for PPT, Word, excel, Outlook CoPilot Studio - custom copilots (which by the way turn into "apps"???) Teams Copilot Researcher and Analyst Agents Prompting Coach Visual Creator What is even more frustrating is they don't all work together or in the same environments. I want to call my Sharepoint Agent from my Copilot, nope. I want my Custom Copilot to use Researcher (or vice versa even), not happening (despite Copilot giving me instructions on how it should). Meanwhile, in Anthropic-land, I setup an MCP service to integrate Claude and my to do app. Not without hiccups, but it works now. The whole Copilot ecosystem needs to get a lot more consistent and quickly or you are going to continue to loose users. PS - as i went to post this, I needed to select Tags -- there were 20 Copilot products to choose from!628Views2likes7CommentsPre-Flight Check The 5 Non-Negotiable SharePoint Cleanups Before Deploying Copilot
Microsoft 365 Copilot is only as good as the data it can reach. Before you let this powerful assistant loose in your SharePoint environment, it’s crucial to make sure your data foundation is clean, secure, and well-governed. Think of it as a pre-flight checklist — a series of must-do cleanups to ensure your Copilot deployment takes off smoothly. Here are the five non-negotiable SharePoint cleanups every organization should complete before deploying Copilot. https://dellenny.com/pre-flight-check-the-5-non-negotiable-sharepoint-cleanups-before-deploying-copilot/54Views0likes0Comments