Ask Copilot to show your team’s open approvals and it hands you a paragraph. No buttons, nothing to click. You still have to leave the chat and open SharePoint to act on any of it. SharePoint Copilot Apps exist to close that gap, and once I understood what that actually meant, I wanted to build one rather than just read the announcement. Public preview shipped July 9, 2026. I picked a scenario nobody in the…
In Part 1, we built a Foundry agent with long-term memory that could remember user preferences, roles, and context across sessions without any custom embedding pipelines. If you haven’t read that post, start there. This one builds directly on top of that code. Memory alone is useful. It just doesn’t go very far on its own. Knowing a user prefers bullet-point summaries or works in finance is helpful context, but it doesn’t change what the…
In Part 1, we explored the fundamental shift from manual SharePoint indexing to Azure AI Foundry’s SharePoint grounding tool. In Part 2, we built a complete, production-ready SharePoint agent system with multiple agent types. Now it’s time to tackle the most critical aspect of enterprise SharePoint AI agents: proper identity passthrough and delegated permissions. This is where many implementations fall short in real-world scenarios, and where the true power of Microsoft 365 Copilot API’s identity…
I spent weeks building a custom indexing pipeline for SharePoint content: incremental updates, change tracking, governance controls, the works. Then I found out Microsoft had already shipped a tool that does most of it automatically. If you’re maintaining a RAG pipeline against SharePoint right now, you’ll recognize the problem before I finish describing it. Companies store thousands of policy documents, procedures, and knowledge base articles across multiple SharePoint sites. Building an AI agent against that…
There are many use cases which you need to call a service/web API from another Web API and it requires to propagate the delegated user identity and permissions through the request chain. OAuth 2.0 On-Behalf-Of flow helps you to authorize access from the gateway to the downstream APIs without losing trace of the user. In this post I will show you how to use a SharePoint Framework web part as a client application communicates with…