Microsoft Copilot & SharePoint + Azure: Autonomous blog writer​

In my new video, I demonstrate how I built an autonomous blog writer using Agent-Flow, a Copilot Agent, SharePoint, and Azure together. My solution uses an agent flow to trigger a Copilot agent every day in the morning. The agent is responsible for doing the following tasks:

• Write a Blog post
• Provide keywords as tags
• Search for an image
• Write blog data in a SharePoint list
• Inform me by E-Mail about new blog post (Agent-Flow step)

I, as the human in this loop, check the new blog post entry in the SharePoint list. If everything is fine, I mark the entry in the list as approved. Otherwise I have the opportunity to modify and adjust the content.

To display the blog posts, I used my new website, www.m365insights.net, and read the SharePoint list data via an Azure function. The Azure function itself uses the Graph API and an Entra app registration to read and provide the SharePoint list data.

In the video I explain all the individual components of the solution.

Check out the created blog post on my website: SharePoint / M365 - Knowledge Source and Portal