Scenario: My client generates a summary document for applications lodged online. The generated summary could be manually edited by an officer. At the final stage of the application processing, it's required to include additional information to the generated summary document regarding the outcome of the application. This information must be dynamically generated. This is a… Continue reading Power Automate w Word Online: generate document updates
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?
“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
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…
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?
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!