Dynamic Mandatory Fields
In a SharePoint library, I have folders which are = a. Admin b. Events c. Furniture and Moves d. Janitorial and Maintenance e. Parking and Transportation f. Shipping and Receiving g. Supplies and Equipment h. Waste and Recycling I have Meta data across the library whose data type are all choices and are: a. Document Type = Contract, Financial, planning b. Building = Gym, Garage, Heating c. Asset Category = Office, Playground d. Fiscal Year = FY23, FY24, FY25, FY26, FY27 e. Vendor = Maple Leaf, Canadian Tire, Home Depot f. Status = Active, Pending, Not Active g. Retention Label = 3 years, 5 years h. Service Type = Admin, Events, Furniture and Moves, Janitorial and Maintenance, Parking and Transportation, Shipping and Receiving, Supplies and Equipment, Waste and Recycling Service Type and Retention Label are mandatory fields, with the Rule below for all the files in the various folders: IF Folder Name = Admin, then Service Type = Admin and Retention Label = 5 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Events, then Service Type = Events and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year, Building and Vendor IF Folder Name = Furniture and Moves, then Service Type = Furniture and Moves and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Building IF Folder Name = Janitorial and Maintenance, then Service Type = Janitorial and Maintenance and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Parking and Transportation, then Service Type = Parking and Transportation and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Shipping and Receiving, then Service Type = Shipping and Receiving and Retention Label = 3 years; the mandatory fields should be Document Type, Status IF Folder Name = Supplies and Equipment, then Service Type = Supplies and Equipment and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Fiscal Year IF Folder Name = Waste and Recycling, then Service Type = Waste and Recycling and Retention Label = 3 years; the mandatory fields should be Document Type, Status and Vendor I have used Column Default Value Settings for SharePoint to display Auto-Display the Service Type and Retention Label, but I cannot seem to perform the conditional mandatory fields using Validations setting for the other requirements. Please helpRecycle Bin and Site Content Hidden for Site Members and Site Visitors
I posted this before but made a mistake with my write up, so I am reposting. I have a requirement that the Recycle bin and Site Contents should be be hidden from the Site Members and Site Visitors. Please how can I achieve this because the Server Infrastructure activation is not working for me. Any workarounds? Please helpSharePoint & AI (Knowledge Agent)
In my tenant, I cannot use some of the basic AI features of the Knowledge Agent. I tried to use the "Create list" prompt, but every call failed with the message: "Something went wrong, and I couldn't complete your request. Please try again later." I have a Copilot license, and some other features are working as expected. I encountered many errors in the browser console that violate the following Content Security Policy directive: "script-src 'unsafe-eval'" (see attached image). "violates the following Content Security Policy directive: "script-src 'unsafe-eval'" I tried an inPrivate browser session already without any changes in the behavior.What Are the Best Practices for Implementing Microsoft Power Automate in a Growing Organization?
Hello Everyone, We’re planning to scale Microsoft Power Automate across our growing organization and would appreciate your expert insights. What are the best practices for implementing Microsoft Power Automate effectively — especially regarding governance, security, environment management, licensing, and user adoption? If you’ve implemented Microsoft Power Automate in a mid-sized or scaling company, please share: Key lessons learned Common mistakes to avoid Governance and CoE strategies Tips for managing citizen developers Looking forward to your valuable suggestions. Thank you!SharePoint Page Copilot Agent Overview | New AI Page Creation in Microsoft 365
🚀 Create SharePoint Pages Without Even Opening SharePoint? Yes — It’s Finally Here. Microsoft has introduced the SharePoint Page Copilot Agent, a new declarative AI agent that lets you create and refine SharePoint pages directly inside Microsoft 365 Copilot experiences like Teams, Outlook, and Word. This means you can generate structured content — meeting summaries, announcements, project updates — simply by describing what you want. Copilot handles the rest. A huge step forward for productivity and content automation in Microsoft 365. In my latest video, I break down: ✨ What the SharePoint Page Agent is ✨ How it works inside Copilot ✨ Rollout timelines ✨ Admin controls + compliance insights ✨ Why this matters for organizations and end users 📺 Watch the full breakdown here: https://youtu.be/dG_mi63z_qM If you’re exploring Copilot, SharePoint, or automation in M365, this update is worth your attention. Let me know your thoughts in the comments — will you enable this in your tenant? #Microsoft365 #Copilot #SharePoint #AI #Productivity #GiulianoDeLuca
Call SharePoint Server Subscription Edition REST API via App Only Authentication
Need to call SharePoint Server Subscription Edition REST API via App Only Authentication and found below article. https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs can i do this using TokenHelper.cs as suggested in the article? Seems request tires to access ACS because of below settings in TokenHelper.cs and requests timeout since the code is executed from a Server where no access to Azure ACS. private static string GlobalEndPointPrefix = "accounts"; private static string AcsHostUrl = "accesscontrol.windows.net"; Any support on how to do this for On-Prem SharePoint is really appreciated.
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, AykutCopilot 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?
