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
SEARCHING THROUGH A GALLERY PRE-REQUISITE Login to your Power Apps Account Create a Canvas App or Open an existing one and add a screen Any data source which has a few data rows, that can be used as source in the gallery. OBJECTIVE Suppose, we have a gallery which has thousands of data, we wouldn't want to sit and scroll through everything until we get the one row we want. Instead, we want to search through the gallery using a search box. Let's see how to achieve that! Controls used: Gallery and Input Textbox Formulae used: Filter ( ), IsBlank ( ) MAKING IT HAPPEN😍 STEP 1: Insert control: Text Input, name it "SearchBox", remove the default value and format it as per your style/requirement. STEP 2: Insert a gallery, name it "galPizza", insert label into the gallery to display pizza names. Format it as you desire. Note: I added a Search Icon within the text input box, for a good look-and-feel. STEP 3: I will be using the Pizza Table, which is a custom ta