User Profile
johnjohn-Peter
Iron Contributor
Joined 2 years ago
User Widgets
Recent Discussions
SharePoint 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?SharePoint 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?Remove sub-folder urls if the parent folder url exists
I have an excel sheet with one column which contain urls from sharepoint, the urls looks as follow:- /sites/Marketing/Budget /sites/Marketing/Budget/2015 /sites/Marketing/Budget/206 /sites/maps /sites/Expesnes /sites/Expenses/2020 now i want to delete all the sub-folders if their parent folder exists? so for example the above rows should be as follow:- /sites/Marketing/Budget /sites/maps /sites/Expesnes is there any script i can run to do this cleanup? ThanksRefinableStrings managed properties are assigned to crawl properties only at the site level
I accessed the managed properties at a site level scope inside SharePoint online, and I found some refinable strings assign to crawl properties, but when I accessed the same refinable strings at the tenant level i found that those managed properties do not have crawl properties assign to them, here is a example for RefinableString06:- Site level Tenant Level Also the confusing issue is that inside the UI the ability to assign crawl properties to those managed properties are disabled on the site level, so how those got assigned?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?Create a file using SharePoint rest api will create a corrupted file
I have this formula to send multiple files from power apps to power automate:- ClearCollect( i, 0 ); ForAll( AttachFiles.Attachments As d, If(AddandRenameFile.Run( ClientDropdown.Selected.Value, MainCategoryDropdown.Selected.Title, SubCategoryComboboxCanvas.Selected.Title & (If( Last(i).Value = 0, "", Last(i).Value )), MainFolderDropdown.Selected.Value, d.Name, { name: d.Name, contentBytes: d.Value } ).result="Error",Notify("Error uploading file " & d.Name& ". Check if the file name already exsists.",NotificationType.Error),Notify("The File '"& d.Name& "' uploaded and renamed successfully.",NotificationType.Success,10000)); Collect( i, Last(i).Value + 1 ) ) here is the flow:- now the files will be added to sharepoint , but when i tired to open an image i will get this error:- and when i try to open a PDF i will get white pages without any content any advice?The requesting principal is not authorized to set group preferred data location
We have our tenant with 4 Geo locations. And inside power automate flow I am sending this Graph Api to create a new security group under specific Geo location:- but I am getting this error:- The requesting principal is not authorized to set group preferred data location. Now if i remove this parameter:- "preferredDataLocation": "AUS", the Office 365 group will get created under the default location, but I need to add it to the specific location. the service account running the graph Api call has SharePoint, group and teams admin permissions. any advice? ThanksCreating a Project through Graph API "msdyn_CreateProjectV1"
I want to create a new Project online plan using Microsoft Graph API, so i used this end point and action inside my flow:- now the action will run successfully, and it should have created a new Project with subject = "Subject Test from automate", as follow:- but i can not find the new project inside the UI:- any advice?Failed-Delete Message: Initiator (8:orgid:**) is not allowed to delete message
I am trying to delete a message inside Teams Channel using Graph API, the chat was generated using copilot agent. now i used this action to do the delete:- and this endpoint:- POST /teams/{teamsId}/channels/{channelId}/messages/{chatMessageId}/softDelete but we got this error message:- AclCheckFailed-Delete Message: Initiator (8:orgid:68******3ca) is not allowed to delete message Although the user who run the flow is teams owner + we have this setting enabled to allow owners to delete message:- any advice? ThanksRe: Questions about Copilot Agents created using copilot studio, that use SharePoint & data-verse
peterfoster Thanks for the reply. A1) So for SharePoint , copilot uses the classic search index to find info? A2) No, on the same source such as SharePoint site, we can get different answers if we ask the same question twice, and most of the time the second answer will be more accurate. A3) Clear thnks A4) so even if we correct the agent, it will not learn from our feedback, is this what you mean?
