Ticket system built with Microsoft 365 and Power Automate.

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

October 29, 2025 · 2 min · Jonas Kufner
Cover image for Ticket System Series – Part 2

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

October 14, 2025 · 4 min · Jonas Kufner
Create a ticket system yourself with Microsoft 365 and Power Automate.

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

October 4, 2025 · 6 min · Jonas Kufner
Custom OpenWeatherMap Connector in the Microsoft Power Platform

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

October 2, 2025 · 4 min · Jonas Kufner