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

Business Applications, Common Data Service, Flow, Power Automate, Power Platform, Uncategorized

Import solution to CDS. Missing Connection references error…

In the morning i tried to bring back some stuff from UAT. When I tried to import my solution back to DEV I was getting errors. My solution contained Flows. Why do I use the classic admin interface to import solutions? Read this article: https://wordpress.com/block-editor/post/msolenacrm.blog/1608 I went the classic interface to import the solution. I've… Continue reading Import solution to CDS. Missing Connection references error…

Common Data Service, Flow, Power Automate

Power Automate: sum(field1, field2, field3, field4) is greater than 0.Easy?

The requirement is to summarize 4 number field values to determine if the total is greater than 0. What could possibly go wrong? You think it should be somewhere in the Expression under Math functions. Think again. The add only allows to summarise 2(!?) numbers. Not 3, not 4. It let me to add extra… Continue reading Power Automate: sum(field1, field2, field3, field4) is greater than 0.Easy?

Flow, Power Automate

Power Automate: Group/Ungroup in Advanced Condition

It's not even a post ... Just saying I was wondering how simple is to group or ungroup conditions in the Condition action block. Very simple! From Scratch For existing - Group For existing - Ungroup It seams pretty obvious but I wasn't sure it exists in a user-friendly manner. It does!

Business Applications, Flow, Power Automate

Power Automate: watch your (white)space!

Well, as per the title. Watch your whitespace. For example, I was getting this error on the checker and tried to figure out what is wrong with the reference name. Flow Checker error When you use expressions you have to type things in. This is where you have to extra careful. Typing in expressions may… Continue reading Power Automate: watch your (white)space!