User Profile
johnjohn-Peter
Steel Contributor
Joined Oct 29, 2023
User Widgets
Recent Discussions
usage price when adding Copilot chat-bot to our external web site
We have a public web site, where it contain some documentation in HTML pages and PDF files. now we want to develop a chat bot using copilot studio and embed this inside our public web site. but i have those questions:- Can external/anonymous users who visit our public web site, use the copilot chat-bot without having to login using Microsoft business account? 2. What about the usage price? how it will be calculated? RegardsSharePoint 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? Thanks
