Fill Excel using Power Automate and Office Script
Över two years ago I wrote about how to “create and fill an Excel file dynamically using Power Automate“. I recently had a similar use case again. I discovered Office Script (Thanks to Tomasz Poszytek (LinkedIn, Twitter, Blog) for mentioning it to me), which I found to be a...
Read More 
Export Dataverse data to SQL using Data Lake and ADF
I recently had the challenge of exporting Dataverse data to an SQL Database. I ended up using an Azure Data Lake Gen2 in combination with an Azure Data Factory (ADF). Throughout the process of setting it up, I faced some issues. We will discuss those in this blog post....
Read More 
Environment Variable caching in Power Automate
In this blog post, we will talk about Environment Variable caching in Power Automate, what the problem is with it and how to work around it. I have attached both a managed and unmanaged solution containing the complete flow to this post. You can find the link furthure down...
Read More 
Connections and Connection References explained
In the last couple of weeks/months, I found myself explaining Connections and Connection References to several colleagues as well as community members while having conversations with them. Usually, questions about them came up along with other stuff we talked about. This made me think it might be interesting for...
Read More Release 2022 Wave 1 Summary
As I described in one of my previous posts (Explaining “One Version” – Dynamics MDA) Microsoft is releasing two “Waves” of new functionalities and improvements per year. Today, 25.01.2022, Microsoft has published the Release Notes for the Release 2022 Wave 1. Like the last time, it is overall a quite...
Read More