Category: Power Automate

This category focuses on Power Automate. To be more specific I mainly write about cloud flows.

There are 7 posts in this category.

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

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

Setup a Service Principal in Power Automate

Every now and then I get the question on how to setup a Service principal in Power automate. This blog post intends to explain this common request. Background First of all, we have to talk about what a Service Principal is and why we should use it. What is...
Read More

Create custom connector for own API

Recently I have been in a project where we had to create a custom connector for our own API of the customer. The setup was not as straightforward as I would have expected and took me way longer than I would have liked it to be. Since I don’t...
Read More

Create and fill an Excel file dynamically with Power Automate

In this article, I will describe how to create an Excel file dynamically with Power Automate and fill it with data from the Common Data Service. Creating those dynamically can be a bit tricky. Therefore, I will provide step by step description of how to do that. As mentioned...
Read More