Power Apps

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 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 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). ...

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. ...