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 in...
APPS FOR EVERYTHING! APPS FOR EASY LIFE! With Microsoft Power Platform, we can build three different types of Power Apps: 1. Canvas App 2. Model-Driven App 3. Power Portal POWER APPS Let's consider that we have to build an application that just allows us to View, Edit, Add and Delete data that is available in the back-end database. Traditionally, we would have to design the look of the app, define the schema of the database, we have to pick a programming language, and develop it, which would take months. If you only care about the data and procuring the app quickly for your enterprise needs, then PowerApps is for you! CANVAS APP Canvas app can be created for web, mobile or tablet screen size. The components like the textbox, buttons, dropdowns can be dragged, dropped and re-arranged on the empty canvas. The components can also be connected to different datasources like the Dataverse Tables and Cloud Flows (Instant Flow) can be used for the automation on the said data. MODEL...