Category: Power Platform

In this category, you will find all the posts related to the Power Platform. The great Platform we all love to work with.

There are posts in this category.

Async onSave preventDefault with external call

2023-03-20 • 3 min read

One of our current projects is the migration of an onPrem Dynamics 365 to the Cloud. Part of that is refactoring existing JavaScript implementation. The current implementation had an onSave function which prevented the save process based on a call to the WebAPI. It took me some time to...

Read-only nested editable grid

2023-02-22 • 7 min read

One of my colleagues recently approached me regarding a requirement she had. In one of our customer projects, we needed to show a subgrid with information from a table two relations away. In this blog post, we will learn how to create a read-only nested editable grid in dataverse....

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

Export Dataverse data to SQL using Data Lake and ADF

2022-10-10 • 14 min read

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

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