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
Copilot answers in Sharepoint search results?
I would really like to add a copilot AI answer in the Sharepoint search result page, mainly for the intranet hub, to help our users better find answers across the intranet and also make the search bar a more complete search experience. Something we could toggle on and maybe we could point out a specific agent we've created for the intranet. I feel people are quickly starting to expect to have an AI summary in their search. Would also make sense when so many use the search bar i Sharepoint to incorporate it there, instead of having to go to a different place to use Copilot. It would make search easier.AI- based Post Sorting
I have developed a Post and Comment module inside SPFx. where i have 3 sharepoint list:- Posts Comments Reaction here is the SPFX, with 2 posts and the first post has 2 comments:- Currently the Posts and their Comments will be shown sorted by the created date , here is the method to show the posts:- async getPostsPage(pageSize: number = 10, afterId?: number) { let url = `${this.siteUrl}/_api/web/lists/getByTitle('SocialPosts')/items` + `?$select=Id,Title,Body,Created,Author/Id,Author/Title,LikeCount,CommentCount` + `&$expand=Author&$orderby=Id desc&$top=${pageSize}`; if (afterId) url += `&$filter=Id lt ${afterId}`; const data = await this.getJson<{ value: any[] }>(url); return data.value.map(v => ({ Id: v.Id, Title: v.Title, Body: v.Body, Created: v.Created, AuthorId: v.Author?.Id, AuthorTitle: v.Author?.Title, LikeCount: v.LikeCount || 0, CommentCount: v.CommentCount || 0 })) as import('../Models/Models').Post[]; } and the comments:- // ---------- Comments ---------- async getComments(postId: number): Promise<Comment[]> { const url = this.commentsUrl() + `?$select=Id,Body,Created,Author/Id,Author/Title,LikeCount,Post/Id,PostId` + `&$expand=Author,Post&$filter=PostId eq ${postId}&$orderby=Created asc`; const data = await this.getJson<{ value: any[] }>(url); return data.value.map((v) => ({ Id: v.Id, Body: v.Body, Created: v.Created, AuthorId: v.Author?.Id, AuthorTitle: v.Author?.Title, LikeCount: v.LikeCount || 0, PostId: v.PostId ?? v.Post?.Id, })); } but the client is asking us if there is a way to order the items using AI algorithm so it show the most relevant posts and comments first? which approach i can follow? to allow order items inside SPFx using AI algorithm instead of Created date?? any advice?New blog: Do We Really Need to Buy More SharePoint Storage?
I’ve published a new blog post exploring a common question: Do we really need to buy more SharePoint storage? In this article, I cover: How SharePoint storage is calculated What counts towards your storage quota Practical strategies to optimise storage before purchasing more When it actually makes sense to buy additional storage 📖 Read the full post here: Do You Really Need More SharePoint Storage? | Optimisation Guide If you’re managing SharePoint Online or Microsoft 365 storage, this guide will help you make informed decisions and avoid unnecessary costs.SharePoint Knowledge Agent ExcludeSelectedSites max 100 urls
Hi All, just an FYI post about a Knowledge Agent preview powershell limitation. As a long time Digital Workplace specialist I've just tried out the Knowledge agent powershell (reference) , to try and test it on 2 of the 444 sites I have in my tenant, but I couldn't. The ExcludeSelectedSites setting for KnowledgeAgentScope has a limit of 100 urls in the KnowledgeAgentSelectedSitesList array. I found this out by running the following commands, where I had 442 urls in the $urlsToKeepKMagentTurnedOff array. Set-SPOTenant -KnowledgeAgentScope ExcludeSelectedSites Set-SPOTenant -KnowledgeAgentSelectedSitesList $urlsToKeepKMagentTurnedOff I know it is preview but unless we can test this out on real sites, prior to TURNING it on for every site we need to be able to test and trial it to build up our understanding so we can help our site / teams owners.
Microsoft Syntex: Turning Your Documents Into Digital Intelligence
In today’s workplaces, organizations generate an overwhelming amount of content—contracts, invoices, reports, emails, and more. Manually managing, classifying, and extracting insights from this information is not only time-consuming but also prone to errors. Microsoft Syntex, an AI-powered service within Microsoft 365, transforms the way businesses handle content. By automatically classifying files, extracting metadata, applying compliance policies, and even generating new documents from templates, Syntex brings automation and intelligence directly into familiar tools like SharePoint, OneDrive, and Teams. This blog explores how Microsoft Syntex helps organizations boost productivity, reduce operational costs, and unlock the true value of their content.
InfoPath Unable to Submit the Data
Hi Team I have the InfoPath form which is connected with SharePoint list in the list i have added the new column and also i have added the new textbox in the InfoPath designer but while submitting the data the column value is not storing to the DataSource. The DataSource is giving the Main in the InfoPath designer. Can you anyone give me the solution Please find the Images. Newly Added the Column which is Sample Data. Can any one suggest me the solution Please Thank You, SaiKrishna.Two connected lists
Hi I have a issue I need to solve. I will try to describe is as good as I can but it feels pretty delicate. I have 2 list lets call them just "List 1" and "List 2" to make it easy. In "List 2" i have a collumn with a lookup to add items from "List 1". So far no problems. But the thing is that when I add one ore multiple items from "List 1" in the "List 2" item i would like that a Automation updates the selected List items from "List 1" with the linked name from "List 2". This needs to work wich create a new Item in "List 2" and when modifing the item. I tried to have my CoPilot to do this for me but it failed big time. Hope that someone have an greate solution for me! Thanks in advance.Autofill Columns - Managed Metadata
I have a SharePoint document library that has 4 autofill columns, 1 of which is a Managed Metadata column. When I drop a document, the MMD column doesn't complete the first time even though the status says, Finished. If I manually chose AutoFill again, the MMD column completes. Is anyone else experiencing this? Am I doing something wrong or are the limitations with AutoFill MMD columns?
