Browsed by
Category: Power Automate

Databricks Service Principal in Power Automate

Databricks Service Principal in Power Automate

In the previous post, I built a Power Automate flow that uploads a document into a Databricks volume. It works. But it runs on my personal access token, and I called that a shortcut right away. Time to fix that with a Databricks service principal in Power Automate. Why does that matter? The token belongs to my user account. It expires. And if my access changes, the flow breaks. That’s fine for a demo. However, it’s not fine for a…

Read More Read More

Upload Files to Databricks with Power Automate

Upload Files to Databricks with Power Automate

In the previous post, I signed up for Databricks Free Edition and built a catalog, a schema, and a volume named dropzone. That volume is empty, though. Now it’s time to upload files to Databricks, and that’s where my two hats (Data Platform Architect and Power Apps MVP) actually have to talk to each other. My plan was simple: trigger a Power Automate flow from Dataverse, and have it upload a document straight into that volume. So I opened a…

Read More Read More

Extracting Unified Workflow Metadata

Extracting Unified Workflow Metadata

Recently I stumbled upon a question that kept nagging me: How can I get unified workflow metadata? This came up while I was working on my demo for the blog post Lightweight Workflow Monitoring. In that demo, I reused my Try-Catch-Finally pattern originally developed for Power Automate Flows. I applied this pattern to an Azure Logic App. So far, so good. But then I hit an unexpected twist. In Power Automate, I rely heavily on the workflow() expression to access…

Read More Read More

Workflow Troubleshooter Agent – My Supportive Super Hero

Workflow Troubleshooter Agent – My Supportive Super Hero

Ever had a critical workflow break at the worst possible moment? Picture this: an approval is stuck. A notification never arrives. The business is already waiting. And somewhere in the background, a workflow has silently failed. I’ve been there. You know something’s wrong, but finding the root cause feels like searching for a needle in a haystack. Logs are scattered. Errors are cryptic. And every minute of investigation adds more pressure. That’s when I decided I needed more than alerts…

Read More Read More

Lightweight Monitoring for Critical Workflows

Lightweight Monitoring for Critical Workflows

Some time ago, I built a larger Dataverse solution that included a whole bunch of automated workflow tasks. Everything worked fine during development. Then I deployed the solution and quickly realized a painful truth: all these workflows were running completely unobserved. I found myself waiting for a result that simply didn’t appear. I couldn’t see what went wrong in real time. I only got clarity at the end of the day when one of those delayed summary emails showed up….

Read More Read More

Agents, Agents, Agents

Agents, Agents, Agents

The Agents topic is everywhere and omnipresent. Everybody tells you; this is the next big thing. You need an army of agents that finish your work. But how do I build such agents? Should I go for pro-code or for low-code? Should I use AI Foundry or Copilot Studio. Furthermore, what is a good example of building an agent? This was also the billion dollar-question for me. Today, I will showcase a small example to you where I will build…

Read More Read More

Using AI for Data Correction

Using AI for Data Correction

How do you usually use Generative AI? That’s a question I get asked quite often. Most of the time, my answer is something like this: “I use it to summarize texts. I also draft ideas together with the AI, and it helps me write content more efficiently.” But this is just one piece of the puzzle. In automation scenarios within the Power Platform, I also utilize AI for data correction. Today, I will explain how this process works. In detail,…

Read More Read More

Pretty Print JSON within Flows

Pretty Print JSON within Flows

Some weeks ago I prepared my presentation about AI Foundry Content Understanding for the Baltic Summit 2025 at Gdansk, Poland. In detail, I have built a small model-driven app as frontend for my demo. My goal was to upload first my PDF file into my Dataverse table from my app. Next, I would start my automation scenario based on Power Automate flows. After completion of my content understanding analyzer, I would then show the resulting JSON in my app. So,…

Read More Read More

Content Understanding from Power Platform

Content Understanding from Power Platform

In one of my last blog posts I introduced my new friend AI Foundry Content Understanding to you. Here I have explained in detail how you can set up Microsoft’s new AI service offering for your documents. Furthermore, I showed you how I deployed my document analyzer in Azure. As result of this exercise, I got an endpoint that I can now use in one of my use cases. In other words, now I can start working with my custom…

Read More Read More