Skip to main content

Posts

Showing posts from March, 2022

Database actions - PAD

  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...

Canvas App - PowerApps

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 (E...

Power Automate Object Variable

OBJECT VARIABLE A variable is a storage space where we can store any type of value. Here, we are gonna explore how to create, manipulate and access an Object variable. For this post, I am going to create the below object (Key-Value Pairs): {     "FirstName":"Bugs",     "LastName":"Bunny",     "Location":"Earth" } Then I will update the "Location" Key to store the value "America" using "setProperty" function. Lastly, I will also try to access the value using the Key name. Pre-Requisite Please log-in to  Power Automate  or  Power Platform  with your Work-School account STEP 1: Create a manually triggered Instant cloud flow. STEP 2:  Add a new step > "Initialize Variable", to create an object variable. Give it a name, type as Object and an initial value. STEP 3:  Next, I will change the Location property of the Object, from Earth to America, using the Compose Action and setProperty() fun...

Power Automate Array Variable

  ARRAY VARIABLES A variable is a storage space where we can store any type of value. Here, we are gonna explore how to store & access Array variables. To understand how array variables work, let's use this example of an array: ["FRIENDS", "Money Heist", "Squid Game", "The Big Bang Theory", "Brooklyn 99"]   PRE-REQUISITE Please log-in to  Power Automate  or  Power Platform  with your Work-School account Let's get started! STEP 1:  Create an Instant Cloud Flow with a Manual Trigger. STEP 2:  Click on "+New Step". Search and select "Variable". STEP 3: To create a variable, select "Initialize Variable". Name: ShowsArray Type: Array Value:   ["FRIENDS", "Money Heist", "Squid Game", "The Big Bang Theory", "Brooklyn 99"] STEP 4:  Click on "+New Step". Search and select "Append to array variable". STEP 5: Select the Array variable an...

Power Automate Variables - Integer/Float

INTEGER/FLOAT VARIABLES What do you call a number that cannot stay still? A VariablešŸ¤£ The objective is to learn how to create and assign values to a variable in Power Automate Flows. Pre-requisite: Log in to  Power Automate  with your Power Platform account. STEP 1: Create an Instant Cloud flow with a Manual trigger. STEP 2: Click on "+New Step". Search and select "Variable". STEP 3:  Select "Initialize Variable" to create a variable, select its data type and give it a default value(optional). STEP 4 :   Give the variable a name, select the "Integer" variable type, and assign an initial value. STEP 5: Click on "+New Step", Search and select "Increment Variable". Increment means increasing the value in the variable. I am incrementing the Counter variable by 2. STEP 6:  Click on "+New Step", search and select "Decrement Variable". Decrement means decreasing the value in the variable. I am decrementing the Co...

Cloud Flow Variables

 POWER AUTOMATE FLOW VARIABLES A Variable is a named storage space where we can store values of any type. In Power Automate flows, variables can be created, assigned/re-assigned with any value, can be referenced in other actions or be appended with new value. A variable, when created within a Power Automate flow, can only be accessed within that flow. Types of variables that can be created: STRING  : Store alphanumeric characters INTEGER  : Store whole numbers that can be positive, negative or zero FLOAT : Store fractional values in decimal format BOOLEAN  : Store TRUE or FALSE values ARRAY  : Store list of multiple values of the same type OBJECT  : Stores pairs of 'Properties' and their 'Values', like in JSON Format Please leave a comment, if you have any doubts. MORE READS:   Power Automate Cloud Variables

Build Canvas App with Microsoft Dataverse

Time to build a Canvas App in Power Apps! Pre-requisite Log In to  Power Platform I will be using Pizza Table which I created in my previous article. You may  Create Pizza Table  or you may choose to use any other table available in the Dataverse. STEP 1 : Navigate to "Create" and click on "Microsoft Dataverse". STEP 2 : Create "+New Connection" STEP 3 : We are going to create a connection to the Microsoft Dataverse to fetch the Pizza table. STEP 4 : Search, select Pizzas Table and Connect. The Canvas App editor opens. STEP 5 : Take a look at the "Tree View", "Canvas", the Play Button on top, the Screen on the RHS with Properties, Adavanced and Ideas tab. In the Tree View, you can see three screens: "BrowseScreen1", "DetailScreen1" & ""EditScreen1". You may click on each of it and see those screens on your canvas. The play button can be used to use the app. The screen on the right side can be used ...

Instant Cloud Flow

Instant Flow - Button Click In this post, we are going to attempt triggering an instant flow by clicking on a button in the Power Automate mobile App! Pre-requisite Install  Power Automate for mobile  and log in with your  Work-School Account Log in to  Power Automate  to develop the Instant flow Requirement (For fun): When I click a button in my Power Automate mobile app, I want to receive a notification that displays the message "You Are Cute". This is a very simple exercise and an easy one to understand about how an Instant Flow works. Step 1: Create an Instant cloud flow in your Power Automate. Step 2: Name your flow, Choose "Manually trigger a flow" and click "Create". Don't hesitate to try out all the other triggers in the list. Step 3: Click "+New Step" to add new step. Step 4: Search "Delay" and select "Delay: Schedule" Step 5: Give a Delay of 10 Second. Add New Step. Step 6: Search Notifications and select "S...