Interesting facts, tips and tricks, projects and developments.
First-Level Support Agent with Microsoft Copilot Studio – AI-powered Ticket Handling in Microsoft 365
First-Level Support Agent with Microsoft Copilot Studio In this post, I show you how to build an autonomous first-level support agent with Microsoft Copilot Studio and integrate it into a ticket system based on SharePoint, Power Apps and Power Automate.
The agent works exclusively with a defined knowledge base, automatically answers recurring support questions and reliably hands over complex or unanswerable requests to human colleagues.
Why an Autonomous First-Level Support Agent? In many organizations, support teams receive identical or very similar requests every day, for example:
...
Ticket System with SharePoint, Power Apps and Power Automate – incl. Automated Status Workflow
Ticket System with SharePoint, Power Apps and Power Automate In this post, I’ll show you how to build a complete ticket system using SharePoint lists, a Power App and an automated workflow with Power Automate. The solution works entirely with Microsoft 365 standard licenses and can be flexibly expanded — even up to using an autonomous AI agent.
Goal of the Ticket System We are building a support system that, in this example, handles questions around Power Apps. The structure can easily be adapted to your company’s needs.
...
Digital Vacation Planning with SharePoint, Power Apps & Power Automate – Complete Approval Process Step by Step
Digital Vacation Planning with Approval Workflow – Efficient, Transparent, and License-Free If vacation planning in your company still happens in Excel or on paper, now is the perfect time to switch to a modern, digital solution.
In this post, I’ll show you step by step how to build a complete vacation planning and approval workflow using SharePoint, Power Apps, and Power Automate.
The best part:
You’ll be able to download the finished solution from my blog later (under Downloads).
...
Relate Rows in Power Automate – Easily Link Dataverse Rows
The Example I want to demonstrate how Relate Rows works with a small example:
There are two tables: Albums and Songs, where Songs has a lookup to the Albums table.
The relationship between Album and Song
The Flow The flow linking Album and Song
In the flow, the album and then the song are first loaded using their respective IDs.
...
Ticket System with Microsoft 365 – Part 2: SharePoint Reference List & Status Notifications
Note: This is human-written content. The logic described here has been tested and does not come from any “AI fantasy.” I hope you find insight and value for yourself or your organization. Enjoy reading.
Summary: Second part of the series on the ticket system with Microsoft 365 and Power Automate. You can find the first part here: Simple Ticket System with Microsoft Forms, Planner & Power Automate – Step-by-Step to a Quick Ticket Solution in Microsoft 365
...
Simple Ticket System with Microsoft Forms, Planner & Power Automate – Step-by-Step to a Quick Ticket Solution in Microsoft 365
Summary: This tutorial shows how to quickly build a simple ticket system using Microsoft Forms, Planner, and Power Automate – including Teams notifications when a ticket is created and a completion message when it’s closed.
Go to Part 2
Target Picture & Prerequisites Goal: A simple ticket system that automatically converts submissions from Forms into Planner tasks, sorts them into buckets, and notifies the requester in Teams. Upon completion, a feedback message is automatically sent.
...
Custom Connector for OpenWeatherMap in the Power Platform (Power Apps & Power Automate)
Video for this blog post: 👉 Watch the YouTube tutorial
Overview In this post, I’ll show you how to create a custom connector for the OpenWeatherMap API and then use it in Power Automate and Power Apps (Canvas).
We’ll go step by step: Test the API (Postman) → Create the connector → Define the action → Test the connection → Use it in flows and apps.
Why a Custom Connector? The Microsoft Power Platform includes many out-of-the-box connectors. But if your system or your API isn’t among them, you need a flexible solution.
With a custom connector, you can integrate any REST API — such as project management, accounting, or AI services. For this tutorial, we’ll use OpenWeatherMap as a simple, practical example.
...
