Using Variables in Power Automate Desktop

Using Variables in Power Automate Desktop - Full Tutorial

Рет қаралды 16,998

Күн бұрын

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:
🔹 Next lesson (The Recorder): • The Recorder in Power ...
🔹 Complete Power Automate Desktop for Beginners: • Power Automate Desktop...
POWER AUTOMATE DESKTOP GROUPS:
👨‍👩‍👧‍👦 Discord: / discord
- 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!
👩🏻‍🎓 LinkedIn: / 12566435
👨🏻‍💻 Facebook: / 754059285247921
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: andersjensen.org/email-newsle...
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

Пікірлер: 41

@andersjensenorg Жыл бұрын

Thanks for all your likes and support 🙌🔥 The next lesson is here: kzfaq.info/get/bejne/ntanqMZpzZm1Y3k.html

@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!

@andersjensenorg Жыл бұрын

Thanks, Carlos! 🤗 Glad you find my videos helpful, even though you already know how to use variables. 🤖👨‍💻 Let me know if there are any specific topics you'd like me to cover! 💬

@kuagoo2837 Ай бұрын

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

@andersjensenorg 28 күн бұрын

Thanks a lot for the kind comment 😊🙌 Best regards, Anders

@dokn221 Жыл бұрын

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

@andersjensenorg Жыл бұрын

You're very welcome, @dokn221 - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html

@PitakYT Жыл бұрын

Thank you very much for your training video. ❤

@andersjensenorg Жыл бұрын

So kind of you, thanks, Pitak 🙂

@elcarryboo9344 Жыл бұрын

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.

@andersjensenorg Жыл бұрын

Thanks x 1000, El Carry Boo. That's a great idea and I saw it working in the UiPath Attended Framework. I will definitely try to come up with something (time is limited atm). Have a great day. Kind regards, Anders

@jatinnandwani6678 Жыл бұрын

Thanks so much

@andersjensenorg Жыл бұрын

My pleasure, Jatin! 🙂

@hernanmauricioperezmunoz4937 Жыл бұрын

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!

@andersjensenorg Жыл бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@mgtd1138 Жыл бұрын

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?

@andersjensenorg Жыл бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@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

@andersjensenorg Жыл бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@sree2838 4 ай бұрын

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.

@andersjensenorg 4 ай бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@ricardoluizmarcello 4 ай бұрын

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

@andersjensenorg 3 ай бұрын

@nareshkumar-qo9qy Жыл бұрын

Please do detail video on css selector.

@andersjensenorg Жыл бұрын

I have a 90 min ready script/plan ready 🙂

@elcarryboo9344 Жыл бұрын

@@andersjensenorg =)

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

@andersjensenorg Жыл бұрын

@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 + '%PersonDetails[0]['name']%'; } return names; }

@andersjensenorg Жыл бұрын

@Tigs62 3 ай бұрын

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 KZfaq 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?

@andersjensenorg 3 ай бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders