This video tutorial will teach you how to learn UiPath RPA. If youβre a beginner this is the course for you. Anders Jensen will teach you everything you need to know about UiPath in order to start building your own RPA robots as an advanced UiPath user.
π« Course materials: https://andersjensen.org/uipathbeginners
—
π¨βπ©βπ§βπ¦ Join the Discord family: https://discord.gg/d8KQpTUvFD
—
Follow me on:
π LinkedIn: https://www.linkedin.com/in/andersjensenorg
π Twitter: https://twitter.com/andersjensenorg
π Instagram: https://www.instagram.com/andersjensenorg
π Facebook: https://www.facebook.com/andersjensenorg
π Email Newsletter: https://andersjensen.org/email-newsletter
—
π Best UiPath RPA Books (affiliate): https://andersjensen.org/rpa-book-recommendations/#uipath
—
0:00 Intro
Welcome to the UiPath Beginners Course. Make sure to open UiPath and all the exercises with me. By the end of this course, you will be an RPA Developer.
1:08 Install UiPath and connect to Orchestrator
Go to uipath.com and download your free version of UiPath. We install with the standard settings. Remember your login, as you will use it a lot in the future. Having installed UiPath, we now connect to Orchestrator. The Orchestrator connection is simply done with UiPath Assistant and automatic authentication.
3:35 Start UiPath
Start UiPath Studio. If you can find the shortcut search for it in the Windows Start Menu.
3:58 Our first UiPath Robot
Having installed UiPath, we are now ready to create our first robot. We create a robot that automatically starts Notepad and does operations in it. A brief overview of the UiPath client is given. You are given an introduction to a Sequence and best practice about naming your activities. In our sequence, we open Notepad and type in the application. In our first robot, weβll also do clicks, have a Message Box and a Delay. We use a Message Box a lot as developers when we want our workflow to pause and inspect something.
22:24 Variables
Guide to the most common variables in UiPath. We talk about Strings, Integers, Doubles, Booleans, and DataTables. Conversion between variable types is covered, e.g. integer to string and how to output DataTables. A String can hold all characters, an Integer is a whole number, a Double is a number with decimals, a Boolean is a true/false variable and a DataTable is a table with rows and columns (think Excel).
40:30 If/While
We solve a simple use case (a guessing game) in order to easily learn about the two activities If and While. An If activity is very easy to understand and if you know programming is equivalent to an If there. Always specify a condition that can be answered either True or False. If itβs True we go to Then and if itβs False we go to Else. We donβt have to put activities in Then and Else. If that’s the case we just continue with our workflow without performing any activity. A While loop should simply just be seen as a workflow that runs over and over as long as the initial condition is true.
53:28 Excel and Data Tables
When we want to automate Excel in UiPath, we convert the Excel sheets to Data Tables using an Excel Application Scope and a Read Range. A Data Table looks exactly like an Excel sheet. The only difference is that they only exist in the memory of our robot. Having manipulated our data we can now write the data back to Excel. Make sure you understand this lesson, as this is the most important part of the course.
1:07:06 Applications and Selectors
Learn to automate in applications and do basic selector work. A simple example is presented with an application, where we need to type, click and modify the selector. In this lesson, you also learn to send hotkeys to applications and copy from the clipboard and save them to a string.
1:19:07 Browser Automation
We learn to automate in a browser, where we open a browser, fill in login details, log in, take a screenshot and save it to a folder. The default browser is Internet Explorer and we also see how we can work with Chrome, Firefox, or Edge.
1:32:02 File Handling
Now we go advanced. We find out how to create folders and sort files (move the files to the folders). We use the .NET method directory.getfiles to get the file names. Using a For Each we can work with each filename one by one. We then use an If and a Move File to move the files based on their type. You are also introduced to make a counter for a log message.
1:43:55 Web/Data Scraping to Excel
In this last lesson, we learn to do web/data scraping with UiPath RPA. We scrape data from a webpage (Amazon) and save the results to Excel. We learn to make it dynamically in order to scrape a lot of different pages based on Excel data input (For Each Row).
#uipath #rpa #roboticprocessautomation
