Business Applications, dataflow, Dataflow, Dataverse, Flow, Power Automate

Getting data from a function in an on-prem SQL server via Gateway in Power Automate

Dataflow magic in Power Automate. SQL with Power Query in Power Automate. Did you know you can do this?

CloudMinded Blog

“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 data from a function in Power Automate.

Now problem, you can use SQL server connector, right?

Almost (but yes, if you read this post or knew before).

Set back #1

You cannot use “Execute a SQL query (V2)” with an on-prem gateway connection. Not supported!

Sure, let’s then use “Execute stored procedure (V2)”.

Set back #2

Apparently, you cannot return dataset from the function. Can call it if it was just a function or procedure without return value. But if it returns data – bad luck!

Panic mode on!

Wait, but what if…

Power Query to the rescue! Again.

View original post 159 more words

dataflow, Dataflow, Dataverse, PowerApps, Uncategorized

Dataflows for Power Apps: transform fixed-width text files

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… Continue reading Dataflows for Power Apps: transform fixed-width text files

Common Data Service, dataflow, Dataverse, PowerApps

Dataflows for Power Apps: cyclic reference error with multiple data sources when you start with empty query

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… Continue reading Dataflows for Power Apps: cyclic reference error with multiple data sources when you start with empty query

Common Data Service, dataflow, Power Platform

Dataflow for Power Apps: “section Section1;…” error on create

This error for me occured when I was copying scripts and using blank queries. This is not my image, not my database, so don't try to access it, please 😀 I found it in Internet to illustrate the point. section Section1; error This message is a little bit a lot not helping. If you deploy… Continue reading Dataflow for Power Apps: “section Section1;…” error on create

Common Data Service, dataflow, Power Platform, Uncategorized

❤Dataflow❤ with Power Apps: bulk update for CDS records

This article is using a test data because using customer data is wrong. The rest is very practical stuff. If you don't use Dataflow for Power Apps still I think you should. I am trying to solve a typical problem. We've got a Choice column Business Type for Account (for example). We need to remove… Continue reading ❤Dataflow❤ with Power Apps: bulk update for CDS records