Skip to main content

Posts

Showing posts with the label Variables

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...
Post a Comment
Read more

Input/Output Variables - PAD

POWER AUTOMATE DESKTOP - INPUT & OUTPUT VARIABLES An input variable is used to send values into the desktop flow. An output variable is used to send back values from where the desktop flow was triggered. Learn how to use these. Pre-Requisite Power Automate Desktop should be installed in your PC. An account must be available in Power Platform. Step 1: Create a new flow. Step 2: Add actions you wish to add. Step 3: Create Input Variables and Use the Input Variables in the actions. Step 4: Create an output variable and assigned the result to output variable. Step 5: Calling this desktop flow in another desktop flow. Step 6: Calling this desktop flow from Cloud flow and seeing how to utilize this variables. Test Cloud Flow: Please leave a comment if you have any queries.
Post a Comment
Read more

Variables In Canvas Apps

 Variables In Canvas Apps GLOBAL VARIABLES Simplest variable to create and use. Can be used in any screen for any UI element, within the app. Can hold value of any datatype: String, Number, Boolean, Record, Table. Created using the function:  Set() CONTEXT VARIABLES Similar to Global variable, the context variable can hold value of any datatype: String, Number, Boolean, Record, Table. Can be used/referenced within the context of a screen, hence the name. UpdateContext() and Navigate()  functions can establish the context variable. When the app is started, all context variables are blank. COLLECTIONS Collections can hold value of datatype: Table. Can be used/referenced anywhere in the whole app. Create and set collections can be done using the function:  ClearCollect() or Collect() It is easy to update a collection Please leave a comment if you have any questions! QUICK READS:  Variables in Canvas Apps
Post a Comment
Read more

Power Automate Boolean Variable [Condition]

  BOOLEAN VARIABLE WITH CONDITION I promise this one is very simple and quick. We learn to use Boolean variable and the If condition in Power Automate Flows. As a first step, we have to be logged into  Power Automate  using the  Work-School Account  and create a new manually triggered cloud flow. In this demonstration, I create a small flow which tells us if we are going out for dessert or staying in and chilling! Let's get into it! STEP 1:  Expand "Manually trigger a flow". +Add an input. Select Yes/No and give it a name. STEP 2:  New Step > Initialize Variable. Give it a name and type String. STEP 3:  Add New Step. Search and select Condition from under Control. STEP 4:  Notice that 2 branches are automatically added for true and false condition. In Choose a value, give the variable we created in Step 1. Select "is equal to" from drop-down. Give "true" from the Expression tab in right-most textbox. STEP 5:  Set the appropriate value...
Post a Comment
Read more

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...
Post a Comment
Read more

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...
Post a Comment
Read more

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...
Post a Comment
Read more

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
Post a Comment
Read more

Power Automate Cloud Flow Variables - String

STRING VARIABLES AND ACTIONS The objective here is to learn to create and use String variables in Power Automate Flows. Pre-requisite Log In to your  Power Platform  or  Power Automate STEP 1:  Create an Instant Cloud 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 default value(optional). STEP 4:   Give the variable a name, select the "String" variable type, and assign an initial value. STEP 5:   Click on "+New Step". Search and select "Append to string variable". Select the String variable created earlier and append any value. STEP 6:  Now, let's see if the value got appended. We can use another variable to store the initial string. STEP 7:  We can use "Set Variable" to set a whole different value to any of the already created variables. Select a variable from the drop-down and give a ...
Post a Comment
Read more