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...
First Things First Peeps! The good news is that we do not have to download/install any Client App to access Power Platform. It is a PaaS offering, so all we need is a work-school account created through Azure Active Directory to log in to the Power Platform. We have the option of exploring it for free with the 30-day trial plan. Using this plan, we can: Use the Office 365 suite Create & run Canvas App Create & run Model-driven App Create & manage Microsoft Dataverse Create automated workflows using Power Automate Create & manage Environments What happens when my trial expires? It can be extended up to 90 days (30 days each, 2 times) CREATING WORK-SCHOOL ACCOUNT Step 1 : Open 👉 Office 365 Plans 👈 in a new browser window/tab Step 2 : Try for free the Office 365 E3 plan Step 3 : Enter a personal email and click Next. Step 4 : Click Set up the account and fill in your details. Verify your phone number. Step 5 : Enter a username and domain name and se...