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

2022-10-25 • 17 min read

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

Environment Variable caching in Power Automate

2022-02-22 • 9 min read

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

Setup a Service Principal in Power Automate

2022-01-04 • 8 min read

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

Create custom connector for own API

2021-12-30 • 17 min read

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

Create and fill an Excel file dynamically with Power Automate

2020-09-27 • 14 min read

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