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

I would like to share my recent experience with loading a CSV file via Dataflow to Dataverse with you. Today, I downloaded the list of leads from the conference we sponsored last week. There is no better way to load it to my sales app on Dataverse – it’s a Dataflow way! At least for…
-

As you know I am a very big fan of Dataflows. The biggest ask from me was always the ability to trigger the Dataflow refresh on demand from a Power App. Initially, Dataflows you could only run from the maker portal. You need all sort of “powerful” security roles and permissions to do so. As…
-

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…
-

It’s very easy to query SQL table-valued function to retrieve the result with Dataflows. This is how we do this. Let’s connect to a database. It will work via gateway as well. Select your function. Pass the parameter if required. Now you can use this table to merge with other tables or map and load…
-
![โค 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…