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...
Automation makes for an "Interesting Work-Life"! TYPES OF FLOWS 1. Cloud Flows : Cloud flows can be created in the cloud version of Power Automate. It is used when you want to trigger automation either automatically, instantly, or using a schedule. 1A: Automated Flows: Automated Flows are triggered when an event occurs, like " Save attachment in OneDrive automatically, whenever you receive a mail with attachments " 1B: Instant Flows: Instant Flows are triggered when a button is pushed in Power Apps, accessed either in Desktop/Mobile. 1C: Scheduled Flows: Scheduled Flows are triggered on the set date and time, with varying frequency. 2. Desktop Flows: Desktop Flows are built in the "Power Automate Desktop", an application that is free to download and install on your PC. This is basically an RPA tool that can be used to automate UI, Web pages, or Windows applications. 3. Business Process Flows: Certain daily processes are strea...