Using Variables in Power Automate Desktop - Full Tutorial

In this video tutorial, you'll learn how to use different types of variables to store and manipulate data in your Microsoft Power Automate Desktop workflows. Variables are like containers that hold different data types, such as text, numbers, and dates. Using variables, you can create automation workflows that can perform complex operations and make decisions based on the data stored in them.

You'll discover the different variables available, including Text, Numerical, Boolean, DateTime, List, DataTable, and Custom Objects. You'll learn how each type of variable works and see examples of how they can be used in your RPA workflows.

By the end of this tutorial, you'll have a better understanding of how variables work in Power Automate Desktop and be able to create more efficient and powerful flows. Let's dive into the world of variables in Power Automate Desktop!

VIDEOS FOR YOU:

POWER AUTOMATE DESKTOP GROUPS:
- Join my network with 6000+ Automation/RPA developers, where we solve Automation/RPA problems, network and help each other upgrade our careers. It's free!

FOLLOW ME:

00:00 Intro
This video tutorial teaches you all about variables in Power Automate Desktop.

00:19 Text
A text variable in Power Automate Desktop is a container that stores textual data, such as words or sentences. It can be manipulated and used in various actions and conditions. For example, to manipulate text in Power Automate Desktop, we can use the Crop Text or Replace text actions.

05:11 Numerical
Numerical variables hold numeric values, like integers or decimals, and enable the storage and mathematical operations on numeric data.

08:46 Boolean
A boolean variable in Power Automate Desktop holds a value that can only be either "true" or "false". Automation workflows frequently use this variable type in decision-making processes.

11:34 DateTime
Power Automate Desktop uses a DateTime variable to hold a specific point in time, including both date and time values. This variable type helps track event timing and perform time-based operations within automation workflows.

15:37 List
A list is a variable type that contains multiple values of the same data type. It helps store and process large sets of data.

22:12 DataTable
A DataTable is a two-dimensional table in Power Automate Desktop that stores data in rows and columns. Users can manipulate data in a tabular format, making it a valuable tool for organizing and analyzing large datasets.

32:43 Custom Object
Users can create custom objects in Power Automate Desktop containing properties and methods. These objects resemble dictionaries in other programming languages, as they are a collection of key-value pairs that can be accessed and manipulated using code.

#powerautomatedesktop #powerautomate #powerplatform

[andersjensenorg]

Thanks for all your likes and support 🙌🔥

[carlosaguilarc]

I have 1 year of experience using PAD as a process analyst and automation engineer and already know how to use variables. I still watch every video you make as I can learn tips, tricks and best practices. Thank you Anders!

[dokn]

i dont know why im here but i 100% sure i need this to make my life easier.

[kuagoo]

Thank you Anders, I am watching your videos for beginners step by step. This is great!

[PitakYT]

Thank you very much for your training video. ❤

[elcarryboo]

Very cool one for beginners and a good reminder for people like me :)
Nicely explained as always.

Well, I don't feel it exists yet but just in case, do you plan to explore the "Form" part of PAD ?

Because it's very nice to "configure" automations depending on what you need as parameters. I think it's a nice way to set parameters of your automations through a form.

[hernanmauricioperezmunoz]

Hi Anders thanks for video, I hope you can do a video where show the Terminal Emulation function using PAD, I've tried to implement it using AS400 and I can't do it. Best!

[mgtd]

Hi, great video!!! I have a copy and paste need from a specific column. How do you run through the list with a copy and paste need?

[steve_aventura]

Very good video. I had a problem that on the last page the Next button was present but disabled. No error occurred and the loop didn’t end until I stopped it. Any suggestions

[sree]

how do we clear variable data which captured in the main flow? I will have to use the same variable in the subflow but not the data.

[babaktirgar]

@andersjensenorg Thanks for the nice video.
I have a question which I couldn't find the answer yet.
The below code works fine for me in PAD javascript. but I can not find the right syntax to make the [0] of the %PersonDetails[0]['name']% as a variable like 'i'

function ExecuteScript() {
var names = '';
var number_of_people = %PersonDetails.RowsCount%;

for ( var i = 0; i < number_of_people; i++) {
names = names +
}
return names;
}

[nareshkumar-qoqy]

Please do detail video on css selector.

[ricardoluizmarcello]

Anders, PAD doesn’t recognize quotes in text when I use “REPLACE TEXT” function. Do you know how to solve this?

[wesleyio]

In power automate how do i get it to move on to the next page when there is not a next page arrow and the page address does not change on the 2nd and 3rd pages etc. I appreciate your help.

[Tigs]

I wanted to find a function similar to the MID(text, start, length) function that you find throughout other Microsoft products. I can't use a "Flag" method, because my text doesnt have a specific flag at the position where i need to make the cut. However, i could not find MID in Power Automate. Eventually, by looking at other YouTube videos i came across the "Get subtext" function, which looks suspiciously like MID. Honestly, why developers feel that they must re-invent the wheel is beyond me. Please could you include the "Get subtext" function in an update to this video?