Browsed by
Tag: Power Automate

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

Let’s start with ALM!

Let’s start with ALM!

Are you a Citizen Developer and new to Microsoft Dataverse? Have you just created and shared your first PowerApps and Power Automate flows? Then the whole chapter of application lifecycle management is certainly completely new to you. That’s okay, because as a Pro Developer, it’s my responsibility to get you on the right track! In my session, I will explain why it makes sense to have a clear environment strategy. Furthermore I’ll show you, how I use solutions to pack…

Read More Read More

PowerApps in Visual Studio Code

PowerApps in Visual Studio Code

I love to create Canvas PowerApps! It’s easy and fast when you stay on basic functionality. On the other side, the effort increases when a PowerApp is growing up. You start using complex layouts in screens. This leads mostly into long function triggers. After a while you need to maintain the app or you want to see a diff between versions. Well, Microsoft has improved the tooling a lot. Unfortunately, it’s still hard to identify changes in your Apps or…

Read More Read More

Improving PowerApps by Centralized Processing

Improving PowerApps by Centralized Processing

PowerApps are promoted as Low-Code / No-Code platform to write Apps and this is right! Power users can easily adopt the “programming” language which is similar to the Microsoft Excel Formula language. On the other hand, when developing PowerApps, users tend to duplicate command snippets and code fragments. I did this until I found a way to reduce this redundancy of my code copies in my apps. Let me show you this on a very simple example:Calling a Power Automate…

Read More Read More

Avoiding Parameter Chaos in PowerApps

Avoiding Parameter Chaos in PowerApps

I love PowerApps! This technology gives me the freedom to create a portable user interface (UI) for my demos in a couple of minutes. Well, sometimes it takes a little bit longer, especially when… Direct before NAV TechDays 2019 I decided to create a PowerApp to demonstrate the power of our Intelligent ERP framework. To execute the needed API calls I attached a Power Automate flow to my PowerApp. During setup of the flow I played a little bit to…

Read More Read More