Browsed by
Category: Power Automate

Adding GitHub Reviewers with Power Automate

Adding GitHub Reviewers with Power Automate

As a software developer or a team lead, you know the importance of code reviews in ensuring the quality and maintainability of your codebase. However, managing and assigning reviewers for your GitHub pull requests can be a time-consuming and tedious task, especially if you have a large team or multiple projects to manage. In addition, assigning reviewers by policy is not always sufficient, and manually assigning special reviewers does not scale. That’s why I want to introduce you to Power…

Read More Read More

Build a Microservice for Power Platform

Build a Microservice for Power Platform

Building microservices instead of a monolithic system is state of the art. These also apply to Power Platform, PowerApps, and Power Automated Flows. You don’t have to solve every problem with the same technology! In other words, sometimes it’s better to build a microservice for Power Platform to improve your apps and flows. This is especially true if your PowerApps or Power Automated Flows require additional power in terms of speed or functionality for a certain data processing. Here, one…

Read More Read More

Extract IDs as Array in Power Automate

Extract IDs as Array in Power Automate

I want to share a solution that I recently discovered in Power Automate Flow and Logic Apps. It’s a simple yet powerful technique that can help you extract IDs from a JSON object and convert them into an array of numbers. In my case, I needed this array to use as parameters for another Power Automate Flow action. So, if you’re facing a similar challenge, read on to learn how to solve it. In other words, I needed something like…

Read More Read More

Analyse your Solution Dependencies in Dataverse

Analyse your Solution Dependencies in Dataverse

Did you ever try to remove a managed solution from your TEST or PROD environment? Yes? Then you know how to discover solution dependencies in Dataverse. In other words, you are familiar with the challenge of figuring out which solution contains dependencies on another solution to unlock the uninstall process in productive Dataverse environments. And yes, this can be a cumbersome job to collect all these solution dependencies. On the other hand, you get some help from Dataverse. To do…

Read More Read More

Environment Variable Values in Dataverse for Teams

Environment Variable Values in Dataverse for Teams

Where do I change my environment variable values in Dataverse for Teams? Yes, I stumbled upon this simple question last night. I tried to change the values of my environment variables in the usual way. But, I learned again Dateverse for Teams is a little bit different. Long story short: I prepared my session “ALM for Citizen Developers & Admins” for the Global Power Platform Bootcamp 2023. I was importing my solution in Dataverse for Teams within my prepared Power…

Read More Read More

AWS Data in Dataverse with Virtual Table – Part 1

AWS Data in Dataverse with Virtual Table – Part 1

Be brave, be curious, explore new worlds! That’s why I took a look outside of Microsoft. I’m sure it won’t surprise you, but there are other competitors like Amazon and Google that provide cloud offerings. This is one reason why data integration is so important for modern digital enterprises. For example, users often need information from other systems in their business process to make decisions. For Dataverse it doesn’t matter, where these data exist. That’s because I can use more…

Read More Read More

Business Central in Dataverse with Virtual Tables

Business Central in Dataverse with Virtual Tables

In my session at Dataverse Summit 2022 I also introduced Business Central’s feature, the virtual tables in Dataverse. Virtual tables complement the possibilities such as Data Sync and Connectors to connect both worlds. In my opinion, virtual tables are the best way of integration. Unlike data synchronization, you do not copy the data from one system to another. Furthermore, virtual tables in Dataverse are similar to physical tables in usage and this is a clear advantage in contrast to connectors….

Read More Read More

Transforming Data from a Blob Storage File

Transforming Data from a Blob Storage File

I recently had a Power Automate Flow challenge where I wanted to access and transform my data. Sounds like a simple task, but it took me a while to figure out the solution… My data was generated by Azure Synapse and stored in an Azure Blob Storage. As you can see, each record is stored as JSON in a single row: Furthermore, all records are stored line by line in the whole file. Well, this shouldn’t be so hard to…

Read More Read More

Power Automate Flows as API

Power Automate Flows as API

Did you ever create an API based on Power Automated Flows as endpoints? You might be wondering, why would you do that? Trust me sometimes there is a reason. Furthermore, with the growing Citizen Developer Community and the amount of Power Platform solutions being created, this will become increasingly important in the future. If you have joined my session Power Automate Flows as API at the Azure Developer Community Day 2022 at Microsoft in Munich, you already know the story….

Read More Read More

Using Many to Many in Power Automated Flows

Using Many to Many in Power Automated Flows

Ohh – what a challenge before I found a very simple solution for a common problem. I was searching, how I can access my related records from a many-to-many relationship in my Power Automate flow. I was googling and found extremely difficult stuff. Someone have resolved the records by using “FetchXml”, calling APIs, or some Xrm “black magic” with Plugins. No – this is definitely to complicated. Finally I was wondering: Isn’t there a simple way to access my records…

Read More Read More