Using AWS S3 buckets from Microsoft Power Platform is limited when you use standard connectors. In other words, you can list buckets and read the content of objects. But you can’t move your data to an AWS S3 bucket with the standard connector. So, what can I do? Right, a custom connector for AWS S3 is the solution. But my journey to a working connector was not so easy as expected. In other words, I faced challenges and solved a…
Transforming objects in Power Automate is mostly a challenge. Here is an example for you. Let’s imagine, I want to convert a JSON array of key-value pairs into an object in my Power Automate Flow. Correct, I want some kind of pivoting. In detail, here is my JSON array which I want to pivot: The result should be a single object: Ok, let’s start. JSON Array pivot into an Object as Power Automate Flow First, I’m creating a new Power…
You know the story, sometimes other things are more important and you forget to clean up. What happen is, after a while you get an email from Microsoft. Right, this email reminds you about the automated cleanup of my inactive Power Platform environments. This is good, because it helps to reduce unneeded resources. I got this email from one of my Demo Environments: In detail, I use this Dataverse Environment to simulate Application Lifecycle Management for Power Platform. In this…
Today, I’m excited to introduce you to a new feature that addresses a common challenge faced by both Citizen Developers and Pro Developers. Yes, you guessed it – we’re delving into the world of creating custom connectors. But I’m not talking about the usual tasks like setting up requests, responses, or authentication. No, the real test comes when we venture into coding within our custom connectors.See more here at Microsoft Docs: Write code in my custom connector. Moreover, there’s a…
I can’t say this often enough, I love to automate manual repetitive tasks. An automated process save time and reduces mistakes. For that reason, I want to share a new example with you. Moreover, I use the Microsoft Power Platform together with AWS cloud in perfect harmony. So here is the story: some days ago, I stumbled upon a terraforming process for new AWS Accounts. The initial idea was, to prepare reusable and preconfigured building blocks. In other words, my…
After creating my Microsoft OpenAI powered Intelligent Assistant canvas app was still one open question for me, “Can I install and uses my Intelligent Assistant also in Dataverse for Teams?” You might also have the question, “Why would you consider bringing your Intelligent Assistant into DataVerse for Teams?” Well, integrating my Intelligent Assistant into DataVerse for Teams offers several advantages. One of them is that canvas apps empower users to create intuitive and tailored interfaces for data management, enhancing collaboration…
In my last blog post I showed you, how fast you can setup and build your own Intelligent Assistant. I used OpenAI in Azure and implemented a very simple user interface in a canvas app. That was done in less than 30 minutes. Nevertheless, the first approach is rarely the optimal one. There is always room for improvement, as the following example shows. When I ask my Intelligent Assistant to give me a C# example, following happens: Yes, the answer…
In this post, I’ll show you how you can use AWS Cloud to analyze your Dynamics data. As you may know, Dynamics data captures important information about your customer interactions, sales, and other key business processes. Furthermore, analyzing this data can provide valuable insights into operational efficiency, customer behavior, and business performance. Before diving into how to bring Dynamics data into AWS, it’s important to understand why you might want to do so. After all, Microsoft already offers tools like…
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…
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…