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…
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….
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…
One of my personal takeaways from Nordic Days of Knowledge 2022 is definitely the integration of Power Automate in Microsoft Dynamics 365 Business Central. Since one of the latest releases, I’m now able to run my Power Automate Flows direct with the context of an existing record. Amazing! You might wonder, what is so special? I have such feature already for my Model Driven Apps. Furthermore, there are already Power Automate Flow triggers for the common Business Central events like:…