Browsed by
Category: Dataverse

AWS DynamoDB as Virtual Table with CRUD in Dataverse – Part 2

AWS DynamoDB as Virtual Table with CRUD in Dataverse – Part 2

AWS DynamoDB as Virtual Table in Dataverse sounds initially impossible, but it isn’t. The key is to set up an OData service with CRUD functionality. Today I show you how I apply full read and write access from Dataverse to my AWS Data. To shorten a long story, firstly I setup a DynamoDB table as database in AWS. Secondly, I attach this database to my serverless AWS Lambda function, which host my OData API service. Afterwards, I implement create, read,…

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

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

Transforming API Responses

Transforming API Responses

Custom connectors are amazing to consume external APIs in Canvas Apps or Power Automate Flows. But what are you doing, when the external API response does not fit for you? To be honest, this week I had the same issue with an own API. I set up my custom connector and everything was fine. The connector worked as expected and my operation provided a response. So far so good… But, on the second look, I found out my response won’t…

Read More Read More

Dataverse Summit 2022

Dataverse Summit 2022

Wondering how to access data in Business Central from Dataverse? There are a many ways to combine these two worlds. Join my session to learn how quickly you can connect and transfer data using either connectors or virtual tables. Join my session “Let’s connect: Dataverse & Business Central” during the Dataverse Summit 2022!

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

Professional ALM for Citizen Developers

Professional ALM for Citizen Developers

In one of my last blog posts, I have shown you my ALM process optimized for my Citizen Developers. I have used a solution based on a Power App and some Power Automate Flows to run a fully automated solution export and import in Dataverse. You remember also my simplified process focused on the needs of a Citizen Developer: This slim process is great for Citizen Developers to get started with ALM. But I’m a Pro Developer – I need…

Read More Read More

Write Less Code – Create reusable Components!

Write Less Code – Create reusable Components!

Component development is not a big deal for me as a Pro-Developer. On the other hand, I recognized during my session at PowerApps Developer Bootcamp our citizen developers need help and examples. For that reason I want to share one example presented in my session. To cut a long story short: Write less code by creating reusable components! The reason is obvious: During development, we generate lots of copy & paste content in our canvas apps. And yes, I also…

Read More Read More

Application Lifecycle Management for PowerApps: Citizen Developers

Application Lifecycle Management for PowerApps: Citizen Developers

It took me a while to realize, my Citizen Developers need a simple approach of an Application Lifecycle Management process. In detail, I can’t talk about Git repositories & branches, Azure DevOps, build and release pipelines. This is to technical and out of scope for my Citizen Developers. In conclusion, a classic Citizen Developer ALM process must be simple. For instance, as a Citizen Developer, I develop my Power Apps and Power Automate Flows. Afterwards, I create my release by…

Read More Read More