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
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).
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)”.
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…
View original post 159 more words
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…
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?
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!
Something Awesome About ... Power Platform and BizApps..Dev and Ops 