Licensing Requirements for SharePoint Advanced Management
Please confirm Licensing Requirements for SharePoint Advanced Management? I ask because I believe there is a scenario where if I have one user account in my M365 Tenant (say this one user account was treated like a service/admin account) and this same user account was subscribed to the Monthly Copilot subscription; it could also therefore subscribe to the SharePoint Advanced Management subscription too? Afterwards, then this user account could do the SharePoint Advanced Management tasks. Sincerely, Joe BotelhoBook of Archimedes, Copilot and SharePoint Agents
1. Introduction The Book of Archimedes is a single PDF that contains all posts in the Microsoft Graph Data Connect for SharePoint blog. This includes 40 articles and nearly 400 pages, which is handy for searching for specific keywords quickly across the many articles. The PDF is provided as an attachment to the main MGDC for SharePoint article at https://aka.ms/SharePointData. You can also download it directly from Book of Archimedes. 2. Using the Book with Copilot Beyond searching inside the PDF, you can feed the Book of Archimedes as grounding to your favorite AI tool to get answers to your questions about MGDC for SharePoint. Let's look at an example. You can use this with Copilot or any AI tool that accepts attached files. In my case, I used https://copilot.cloud.microsoft/ to access my work Copilot, the secure and compliant Copilot integrated with my enterprise account. I start with the “+” button and then the “add content” button. Then I used the up-arrow icon to “upload from this device” and selected the local copy of the Book of Archimedes I downloaded earlier. After that, I added my question as a prompt. I tried “What is Project Archimedes?” I got a summary of Microsoft Graph Data Connect for SharePoint, including key scenarios. From there, I could ask any question. If the book contains the answer, Copilot will find it for you. Project Archimedes is the early codename for Microsoft Graph Data Connect for SharePoint. This project aims to deliver rich data assets to OneDrive and SharePoint tenants, enabling them to run their own analytics, derive insights from their data, and understand how they use these products. The data is transferred to an Azure account owned by the tenant, where tools like Azure Synapse, Power BI, or Microsoft Fabric can be used to transform this data into insightful reports and dashboards [1]. Key Scenarios of Project Archimedes: Security: Understanding permissions in SharePoint and OneDrive tenants to ensure content is properly protected. Capacity: Understanding site lifecycle, ownership, and storage used by SharePoint sites and OneDrives. Sync Health: Ensuring users are properly using OneDrive for Business to protect their files by synchronizing them with the cloud [1]. Datasets Provided: Sites: Information about SharePoint sites. Groups: Details about SharePoint groups. Permissions: Information about sharing permissions. Files: Data about files stored in SharePoint and OneDrive. File Actions: Details about actions performed on files. Sync Health: Information about devices running OneDrive Sync. Sync Errors: Details about errors encountered by OneDrive Sync clients [1]. Example Use Cases: Security Scenario: Answering questions about oversharing, external sharing, sensitive data sharing, and permissions. Capacity Scenario: Tracking storage usage, site lifecycle, and identifying large or inactive sites. Sync Health Scenario: Monitoring device health, folder backup status, and sync errors [1]. For more detailed information, you can refer to the Book of Archimedes which contains comprehensive guides, FAQs, and step-by-step instructions related to Microsoft Graph Data Connect for SharePoint [1]. [1]: Book of Archimedes.pdf The more impressive capabilities of Copilot are shown when you ask for something that is not just a direct quote from the Book. For instance, I asked about pricing for a specific scenario: "If a tenant has 1,000 SharePoint sites, how much would it cost to get the SharePoint Sites and SharePoint permissions for that tenant using MGDC?" To estimate the cost of getting the SharePoint Sites and SharePoint Permissions datasets for a tenant using Microsoft Graph Data Connect (MGDC), you can follow these guidelines: Pricing Information: SharePoint Sites and Permissions: The price to pull 1,000 objects from the available MGDC for SharePoint datasets (Sites, Groups, and Permissions) in the US is $0.75, plus the cost for infrastructure like Azure Storage, Azure Data Factory, or Azure Synapse [1]. SharePoint Files: This dataset is billed at $0.75 per 50,000 objects due to its typical high volume [1]. Estimating Costs: Number of Objects: Sites: The number of objects in your SharePoint Sites dataset will be equal to the number of sites in your tenant. Permissions: The average number of SharePoint permissions per site is around 61 [1]. Cost Calculation: Example Calculation: For a tenant with 1,000 sites: Sites Dataset Cost: $0.75 Permissions Dataset Cost: $45.75 Total Cost: $0.75 + $45.75 = $46.50 Additional Costs: Azure Storage: Costs for storing the data in Azure Storage. Azure Synapse: Costs for running pipelines to move the data. For more precise estimates, you can sample the dataset to get a total object count without pulling the entire dataset [1]. [1]: Book of Archimedes.pdf Copilot will also answer questions in other languages. You just ask the question in whatever language you want, and it gets detected… Here’s an example using Brazilian Portuguese. I asked "Quais são os datasets que fazem parte do cenário de segurança?" Os datasets que fazem parte do cenário de segurança no Project Archimedes são: Sites: Informações sobre os sites do SharePoint. Permissions: Informações sobre as permissões de compartilhamento. Groups: Detalhes sobre os grupos do SharePoint. Esses datasets ajudam a entender se o conteúdo está devidamente protegido, respondendo a perguntas como: Está ocorrendo compartilhamento excessivo? Está ocorrendo compartilhamento externo? Dados sensíveis estão sendo compartilhados? Quanto compartilhamento ocorre por rótulo de sensibilidade? Dados sensíveis são compartilhados com usuários externos? Quais domínios externos estão sendo compartilhados? Quais sites foram mais compartilhados? Quais níveis de compartilhamento estão sendo usados? Quais permissões um usuário específico possui? Quais extensões de arquivo são mais compartilhadas? Quanto compartilhamento ocorre no nível de Web, Pasta, Lista ou Arquivo? Esses datasets são fundamentais para garantir a segurança e a conformidade dos dados dentro do ambiente do SharePoint e OneDrive [1]. [1]: Book of Archimedes.pdf 3. Using the Book to create a SharePoint agent You can also use the book to create a SharePoint agent. This will make it easy to ask questions about Microsoft Graph Data Connect for SharePoint without having to upload the PDF every time. To start, upload the Book of Archimedes to a SharePoint document library. Next, select the file and use the option to “create an agent”. That’s it. Your agent is created, and you can start using it immediately. The agent shows up in the document library as a file with the “.agent” extension. You can simply open that file in SharePoint to run the agent. Once you open the agent, it offers you a text box to ask questions. Here is the agent response to “What are the main questions about SharePoint capacity that MGDC for SharePoint can answer?” The Book of Archimedes provides detailed answers to several key questions about SharePoint capacity using Microsoft Graph Data Connect (MGDC). Here are the main questions it addresses: Key Questions about SharePoint Capacity: How much storage is being used by SharePoint sites? This includes understanding the total size of the latest versions of files, previous versions, metadata size, and deleted files in the recycle bin 1. What are the different storage sizes reported for a SharePoint site? Storage Used: Includes all storage, metadata, previous versions, and recycle bins. Total Size: Includes metadata and previous versions but excludes recycle bins. Metadata Size: Storage used by file metadata. Total File Stream Size: Size of the latest versions of files. Previous Versions Size: Size of previous versions of files. Recycle Bin Size: Size of deleted files in the recycle bins 1. How can administrators check the amount of storage being used by SharePoint sites? SharePoint client UX: Viewing storage while using SharePoint as a site user or Site Collection administrator. PowerShell cmdlets: Using command-line tools to query site storage information. SharePoint Admin Center reports: Viewing usage reports in the Admin Center. Microsoft Graph Data Connect: Pulling detailed datasets for SharePoint sites and OneDrives 1. How can administrators create test sites to understand storage reporting tools? Creating different types of test sites (empty site, site with files, site with deleted files, site with previous versions) and analyzing how storage sizes are reported 1. How can administrators estimate Azure costs for MGDC usage? Estimating the number of objects (sites, groups, permissions, files) and understanding the billing rates for different datasets 1. How can administrators use MGDC to run detailed analysis of SharePoint and OneDrive storage metrics? Using detailed data in MGDC to analyze storage metrics and understand the impact of metadata, versions, and deleted files 1. Tools and Templates: Capacity Template: Includes instructions, ARM template, Azure Synapse pipeline template, and Power BI template to help administrators use MGDC datasets for capacity analysis 1. Conclusion: The Book of Archimedes provides comprehensive guidance on leveraging MGDC to gather, store, and analyze SharePoint data, ensuring effective data management and security. It is a valuable resource for administrators and developers working with SharePoint and OneDrive data using MGDC 1. Would you like more specific information on any of these questions or tools? 1: <File>Book of Archimedes</File> As we did with Copilot, you can also ask any question on a topic addressed in the book. You can also use languages other than English. You can experiment with editing the agent to rename it, change the description, add more sources, adjust its behavior, offer sample starter prompts, include specific instructions or even customize with Copilot Studio. Just use the option to "edit the agent". You can also share the agent just like you share any file in SharePoint. You can learn more about SharePoint agents in this YouTube video by Vesa Juvonen: https://www.youtube.com/watch?v=pYvK76SVEv4 4. Conclusion I hope you enjoy using the Book of Archimedes as grounding for your AI tools. As usual, remember that AI tools may make mistakes and you should always double-check the answers you receive. There is also a chance that a particular AI tool might not be able to handle a large document like the Book of Archimedes, currently weighing in at around 10MB.
Improve Feedback Portal - AI to consolidate similar feedback/posts
I've just posted feedback on the Microsoft Feedback Portal with regards to trying to improve it. Improve Feedback Portal - AI to consolidate similar feedback/posts · Community Below are the core issues. Feel free to go there and vote (if you want to) so that "hopefully" Microsoft makes some positive changes, and we start to get some of the core SharePoint issues resolved. "I've tried to use the Feedback portal (and previously UserVoice) over many years and give up each time as the feedback is lost after a day (pushed down the queue). The main issue is that Microsoft doesn't seem to perform any holistic analysis / consolidation across all feedback provided by their valued customers. Given Microsoft are fully invested in AI, can you (Microsoft) run some AI across the entire Feedback portal and consolidate all feedback into related questions and have these made available in a different vertical so we can see the consolidated/related feedback users are submitting. This will also give you (Microsoft) a true sense of what needs to be addressed, core issues affecting lots of your customers, etc. I'm also convinced that there isn't a dedicated team in Microsoft that is managing all the feedback that comes through (there's a lot of feedback but no action, comments, etc. I know from experience with my own posts). Given this is the channel we are pushed to for logging our feedback, there should be a dedicated team responding to the feedback posted."SharePoint Embedded: Coming Soon to a City Near You
SharePoint Embedded, the AI forward platform that lets you deliver Microsoft 365 document capabilities as part of any app, has been generally available for a year, and we are excited to see the many projects people are building with it. In celebration, we are increasing our investment in your success with enablement focused city tours, a total of seven more in-person hands-on education opportunities, this June. SharePoint Embedded is a new way to build a new kind of app, an AI forward platform for document centric apps, delivering rich Microsoft 365 capabilities like Microsoft Copilot AI, Microsoft Office collaboration, Microsoft Purview security and compliance, and a whole lot more. SharePoint Embedded can help you build both enterprise line-of-business apps and ISV apps, on any platform. Space is limited, so sign up today here. Our planned stops include: June 9, London June 11, Stockholm June 13, Madrid June 23, Chicago June 25, Atlanta June 27, Houston June 30, New York These half-day tech focused enablement sessions are designed for IT leaders, product owners, enterprise architects, and senior developers who want to get deep into how they can benefit from SharePoint Embedded. We’ll cover SharePoint Embedded essentials, AI agent development, Microsoft 365 integration patterns, one-click Office collaboration setup, and Purview capabilities. Plus, we’ll also get hands on with the technology, so you can see it in action yourself.
SharePoint Hackathon Winner - SharePoint Agents
We are excited to provide more details on the winners of the recent worldwide SharePoint Hackathon 2025. We had four different categories on this hackathon, which was available for everyone to join with different objectives for different roles from end user, designer, architect, or developer and more. We announced the nominees and winners for each of the categories in a separate blog post, but also wanted to provide more details on the winner submissions for each category. Winners in the SharePoint Agents category were Sudipta Kumar Basu, Kuntal Chakraborty, Pritam Mallick, and Snehasish Das from Capgemini. This category focused on demonstration of SharePoint agent use case on the distinct kinds of materials and source files which are used for the agents. Their submission was a great example on creating powerful agents with customer specific materials. You can find detailed demonstrations on their submission within the following video. Presenters - Sudipta Kumar Basu, Kuntal Chakraborty, Pritam Mallick & Snehasish Das Host - Vesa Juvonen (Microsoft) References to latest SharePoint Agents information: Agents in SharePoint Get started with SharePoint Agents Introduction to SharePoint agents Create a SharePoint agent for your site Getting started with SharePoint agents Get started with SharePoint agents IT governance and control Unlocking Efficiency: SharePoint Agents in Action | SharePoint Hackathon Thanks to all the participants on the SharePoint Hackathon 👏🙏🧡 Please provide us with input and feedback in the hackathon. Should we do this again? - https://aka.ms/sharepoint/hackathon/feedback Got feedback on the latest SharePoint features, SharePoint Hackathon or any other topics? Feel free to add comments and we'll get back to you.
Copilot Studio - Access SharePoint List
Hi There, for a testing prupose, I want to create an agent with Copilot Studio. I want to access SharePoint List via action="Get items" from SharePoint. I selected/entered in "Inputs" section: Site Address = http:// .... List Name = Employee List Top Count = 5000 Filter Query = Dynamically The list has employee information, around 10 columns, and 150 rows. When I submit such "Who is Jasmin?" or any other similar question such "Who is Jasmin Tailor?" Overall: I am searching about existing employee and not existisng in the list, ... I get always this error message: Error Message: The connector 'SharePoint' returned an HTTP error with code 400. Error Code: ConnectorRequestFailure Conversation Id: 3c0377a0-83c1-412b-9d1a-761f8202203a Time (UTC): 2025-04-15T16:49:08.414Z First time I run this agent with this action, I was asked to connect, which worked fine. However I still get this error message. I am the creator of the agent and I am also the owner of this sharepoint list. Any idea, what am I doing wrong? Or can I somewhere check if this "Get itrems" action or other actions are temporarily not working? THANKS ! Regards, Aykut
SharePoint Agents weirdness
We're looking at enabling SharePoint Agents to our Microsoft 365 Copilot users, however are running into some interesting issues while testing its capabilities and the whole implementation feels janky. For example: The agent returns answers or suggests prompts such as: What’s the latest from my manager, organized by emails, messages, and files? Provide a detailed summary of my Teams messages from this week about... Summarize my emails from this week. Why?! The agent is grounded to the SharePoint site's data and does not have access to other types of knowledge. Furthermore, a site member can move an agent file into the Approved folder in the Site Assets library to make it show up as approved for the site, with no involvement from the site owner.
