POWER AUTOMATE DESKTOP - DATABASE Pre-Requisites Power Automate Desktop Access to database Under the database action, we have only three sub actions, namely: Open SQL connection Execute SQL statement Close SQL connection Open SQL Connection The first step is to connect to the database. So, we will use the Open SQL connection action and provide a connection string to establish the connection (the connection string in the video is a sample). When the connection is successful, the connection details is stored in a variable during execution. Execute SQL statement This action can be used to execute SQL queries. Here, I am using select query and the result is stored in a variable of type datatable. Close SQL connection It is a best practice to always close the database connection once the required queries are executed. YAY! BONUS!š® How to execute a stored procedure using database action? Stored Procedure without arguments Stored Procedure with arguments (Comma separated incase of many a
Overview Of Canvas App Canvas App is a way for users to easily design a custom-app. We are provided with a Canvas, which are either Mobile or Tablet screen size. To the blank Canvas, we can drag-and-drop UI elements like Button, Textbox, Drop-down, etc. The look-and-feel of these elements can be formatted, like Height, Width, Color, etc. These elements also can be programmed different behaviors/logics and can access different data, by using Connectors and Excel-like formulae/expressions. Canvas Apps are mainly used when there is a requirement for Task-Based or Role-Based apps, where the user doesn't need to have access to the whole Microsoft Suite. Below are some pictures to get an idea about the Canvas App Editor. You may also Log-in to the Power Platform, Create a Blank Canvas App and play around yourself. [Note: You require a work-school account] A Tablet screen-sized blank canvas Insert Elements into the blank canvas from the Tree View Formatting element in the Canvas (Ex: Ch