How to count the number of rows of SQL query result set?
Here’s how you can get the number of rows returned by SQL statement in Power Automate Desktop: %QueryResult.RowsCount%
Here’s how you can get the number of rows returned by SQL statement in Power Automate Desktop: %QueryResult.RowsCount%
Today, I was trying to figure out how to edit the Power Automate Desktop flows’ source code directly, because I had to do some changes… Read More »Power Automate Desktop script “source code”
Here’s a tip that I guess no one will ever use, but I find it interesting. I have never used the display custom form action… Read More »Use your own Adaptive Cards in Display Custom Form action (Power Automate Desktop)
NOTE: This approach only works when you have SQL authentication enabled on your Azure SQL server, which is not the recommended practice. However, I don’t… Read More »How to connect to Azure SQL with Power Automate Desktop?
Here’s an example of comparing multiple variable values in one IF statement on Power Automate Desktop. In this example, I check if the first number of… Read More »Compare multiple variables at once in an IF statement (Power Automate Desktop)
Here’s a list of things to be verified & recommendations when you are building Power Automate Desktop solutions: General tips The user credentials running the… Read More »Checklist for Power Automate Desktop
Anyone who has worked with any RPA technology knows that just when you think that your robot is stable, something strange happens and you spend… Read More »All the ways my robot has broken
Here’s a great cheat sheet for the Power Automate Desktop actions. I keep it close when building stuff with PAD. Available here: https://cheatography.com/vjr/cheat-sheets/power-automate-desktop-actions/ Great stuff!
For some reason, one of my client’s desktop automation’s suddenly broke down as the robot could not find a specific image on the screen anymore.… Read More »What’s the difference between basic and advanced image matching algorithm in Power Automate Desktop?