Olena's Dynamics Blog (post-AI)
Writing as a human
Category: PowerApps
-

Originally posted on CloudMinded: “We are screwed!” me at the moment of technology induced panic That was the feeling when I saw the below error messages. The client’s setup is an on-prem SQL server exposed to the cloud via an on-prem Gateway. It works perfectly fine for exiting Dataflow integration, but this time we needed…
-
![❤ Dataflows for Power Apps ❤: “The column ‘[Column_name]’ of the table wasn’t found.” error while loading multiple tables](https://msolenacrm.blog/wp-content/uploads/2021/01/notsofast.png.png?w=1024)
There is an option to load data to multiple table in one go in Dataflows. These tables can be related. Dataflow engine calculates the dependencies and determines the correct order for loading. It’s a very cool functionality, however, you have to be aware of some potential issues as well as available workarounds. Problem: I am…
-

Working with real customer’s deployment requires managing multiple environments – at least Test and Production or additionally a Dev environment. One of the common patterns we use in the solutions is to use Azure Functions as an effective, serverless extension of the point-and-click Power Automate flows. This pattern utilises a Custom Connector created to embed the function call and parameters into…
-

What is a fixed width text file? Data in a fixed–width text file is arranged in rows and columns, with one entry per row. Each column has a fixed width, specified in characters, which determines the maximum amount of data it can contain. No delimiters are used to separate the fields in the file. Could we load data from…
-

As simple as this: if you don’t believe in solutions with Dataflow and just copy queries across most likely you are going to get the following error: I had multiple data sources: Dataverse and CSV file. Because I didn’t go through the normal order for steps but just started with an empty query and just…