\ Flowchart. The New Diagram window is displayed. Note: You can also add a Flowchartactivity to the Main panel to create a new flowchart workflow. ( 2. In theName field type a name for the workflow, such as “First Flowehatt;” and } click Create. The Main panel is updated accordingly. 3. Create two Int32 variables (intRandomNumber, intGuessNumber) and a String one ( (strMessage). 4. Set the default value of the strMessage variable to “Guess a number from 1 to 999.0" TheintRandomNumberstores a random — number between 1 and u ——$—$$ ‘QUALITY THOUGHT" worwfacebookcom/qthought T wnvarqualnythoughtin PH NO: 7675827899, 040-48526948 “0 mal: nfo@qualiythoughein n &QUALITY THOUGHT UiPath Material 999, intGuessNumber stores the user's guess, and strMessage stores the message that is going to be displayed to prompt the user. Name | vaitre ype | Scope Detaut infrdomNumber tea Main ‘eter a VB expression inGuestumber sms Main reer 0 VB expres sunvesage sting Main "Guess. a rune from 110 98. ‘Add an Assign activity to the Main panel, and connect it to the Start node. In the Properties panel, in, the To field add the intRandomNumber variable. In the Value field, type new Random().Next(1,999), Note: This field uses the Random()function to generate a random number between I and 999, 8. Add an Input Dialog activity to the Main panel and connect it to the Assign one. 9. Inthe Properties panel, in the Label field, add the strMessage variable. 10. In the Result field, add the intGuessNumber variable. This activity asks and stores the user's guesses in the intGuessNumber variable. 11. Add a Flow Decision activity and connect it to the Input Dialog. This activity enables you to tell the user if he correctly guessed the number or not. 12.In__ the Properties panel, the Condition field, type intGuessNumber = intRandomNumber. This enables you to verify if the number added by the user is the same as the randomly-generated one. 13. Add a Message Box activity and connect it to the True branch of the Flow Decision. 14. In the Properties panel, in the Text field, type "Congratulation! You guessed correctly! ‘The number was " + intRandomNumber.ToString + ".”. This is the message that is going to be displayed if the user correctly guessed the number. 15. Add a new Flow Decision activity 2nd connect it to the Falsebranch of the previously i added Flow Decision. 46.In the Properties panel, in the Condition field, type intGuessNumber > intRandomNumber. This activity enables you to check if the number the user added is bigger than the randomly-generated one. 17.In the DisplayName field, type Comparison. This enables you to easily to tell the difference between the two Flow Decisionsused. 18, Add an Assign activity and connect it to the True branch of the Comparison activity. 19.In the To field, type the strMessage variable, and in the Value field, type a message indicating that the guess was too high, such as "Too big. Try again.” 20, Select the Assign activity and press Ctrl+C. The entire activity and its properties are copied to the Clipboard. 21. Press Ctr+V. A duplicate of the previous Assign activity is displayed. 22. Connect it to the False branch of the Comparison activity and, in the Properties panel, inthe Value field, type “Too small. Try again.”. ed (QUALITY THOUGHT. + wwnwfacebook.com/qthought + www.qualitythoughtin PH NO: 7675827899, 040-48526948 at Email ld: info@qualitythoughtinQUALITY THOUGHT UiPath Material 23.Connect the Assign activities created at steps 18-22 to the Input Dialog. A loop is, created, asking the user to type a smaller or bigger number, until he guesses correctly. ‘The final workflow should look as in the screenshot below: a e +7 tone! ~ oO _ : } State Machines A state machine is a type af workflow that uses a finite number of states in its execution. It can go into a state when it is triggered by an activity, and it exits that state when another activity is triggered. Another irmportant aspect of state machines are transitions, as they also enable you to add conditions based on which to jump from one state to another, These are represented by arrows or branches between states. ‘There are two activities that are specific to state machines, namely State and Final State, and they are found under Workflow > State Machine. Note: You can only create one initial state, yet it is possible to have more than one Final State. ‘The State activity contains three sections, Entry, Exit and Transition(s), while the Final State only contains one section, Entry. Both of titese activities can be expanded by double- clicking them, to view more information and edit them. QUALITY THOUGHT = wwwfacebook.com/qthought = wwwaqualityehoughtin, PH NO: 7675827899, 040-48526948 42 Email ld: info@qualitythoughtinQUALITY THOUGHT UiPath Material The Entry and Exit sections enable you to add entry and exit triggers for the selected state, while the Transition(s) section displays all the transitions linked to the selected state. {Tin see, cae P MessageBox a “Congatulations You guessed correct! The number w 1 Guess No © Enty ) ImputDiatog a “Guess the Number “Add a number between ¥ ans 106 % Transiton(s) Ty Smaller —> Destination: Try Smale M559 Correct Guess —» Destination: Finalstate Ty Higher “> Destination: Try Higher Misg SS (QUALITY THOUGHT: = wwwéacebook.com/qthought = www.qualitythoughtin PH NO: 7675827899, 040-48526948 a Email ld: info@qualitythoughtinQUALITY THOUGHT UiPath Material ‘Transitions are expanded when you double-click them, just like the State activity. They contain three sections, Trigger, Condition and Action, that enable you to add a trigger for the next state, or add a condition under which an activity or sequence is to be executed. ‘Sty Sater Sure: Guess Wumoee Thggee “Ty Smaies a Conssiticn itn infandornNumk action 1 MessageBox a our guess 100 big. Try a sinaier value >» Destination: Guess Number ‘Add shores goer transition Example of How to Use a State Machine ‘To exemplify how to use a state machine, we are going to build the guessing game we did in the previous chapter, only we will try to guess a number between 1 and 100. 1, Create a blank workflow and, on the Design tab, in the Filegroup, select New > State Machine. The New Diagramwindow is displayed. Note: You can also add a State Machineactivity to the Main panel to create a new state machine workflow. OOO ee’ ‘QUALITY THOUGHT = wwwfacebook.com/qthought + wwwqualitythoughtin PH NO: 7675827899, 040-48526948, 44 Email ld: info@qualitythought inQUALITY THOUGHT UiPath Material 2. Create two integer variables, intGuess and intRandomNumber. The first variables stores your guess, while the second stores the random number. 3. ‘Add a State activity to the Main pane and connect it to the Start node. This is the intial state, and it is used to generate the random number. 4. Double-click the activity. This State activity is displayed explanded in the Main panel. 5. In the Properties panel, in the DisplayName field, type Initializing Random Number. This enables you to easily tell states apart. 6. Inthe Entry section, add an Assign activity. 7. Inthe To field, add the intRandomNumber variable. 8. In. the Value field, type new Random().Next(1,100). This expression generates a random number. 9, Return to the main workflow view and add a new State activity. 10. Connect it to the previously added activity. 11. Double-click the last added State activity. This activity is displayed expanded in the Main panel. 12.In the Properties panel, in the DisplayName field, type Guess Number. This state is used to prompt the user to guess a number. 13. In the Entry section, add an Input Dialog activity. 14.Select theInput Dialog, and inthe Properties panel, add an appropriate Label and Title to prompt the user to guess a number between 1 and 100. 15.In the Result field, add the intGuess variabie. This variable stores the user's guess. 16, Return (0 the main workflow view and create a transition that points from the Guess Number state to itself. 17. Double-click the transition. The transition is displayed expanded in the Main panel 18.In the Properties panel, in the DisplayName field, type Try Smaller. This message is displayed on the arrow, enabling you to ran through your workflow easier 19. n the Condition section, type iniGuess > intRandoraNumber. This verities if the user's guess is bigger than the random number. 20. In the Action section, add a Message Box activity. 21.In the Text field, type something similar to "Your guess is too big. Try a smaller number.” This message is displayed when the user’s guess is bigger than the random number. 22,Return to the main workflow view and create a new transition that points from the Guess Number state to itself. 23, Double-click the transition. The transition is displayed expanded in the Main panel 24.10 the Properties panel, in the DisplayName field, type "Try Bigger.”. This message is displayed on the arrow, enabling you ts tun through your workflow easier. 25.In the Condition section, type intGuess < intRandomNumber. This verifies if the guess is smaller than the random number. 26.In the Action section, add a Message Box activity. 27.In the Text field, type something similar to "Your guess is too small. Txy a bigger number." This message is displayed when the users guess is smaller than the random. number. 28, Return to main workflow view and add a Final State activity to the Main panel. 29. Connect a transition from the Guess Number activity to the Final State. 30. In the Properties panel, in the DisplayName field, type Correct Guess. SS (QUALITY THOUGHT = www facebookccom/qthoughe + wwwwaqualityhoughtin PH NO: 7675827899, 040-48526948 5 Email ld: info@qualitythoughtinQUALITY THOUGHT UiPath Material 31, In the Condition field, type intGuess = intRandomNumber. This which this workflow steps to the final state and end. 32, Double-click the Final State activity. It is displayed expanded in the Main panei. 33. nn the Entry section, add a Message Box activity. 34,In the Text field, type something similar to "Congratulations. You guessed correctly! ‘The number was * + intRandomNumber.ToString + ".". This is the final message that is to be displayed, when the user correctly guesses the number. the condition on The final workflow should look as in the following screenshot. Gi : fis. Sate Madioe @ Sutocire ‘aoa 8 Cote © FE sing anton tn oO ¥ " Bl Foastate Giese ° ‘ a : | se “Vattbies Aegurens imports @Pom HE 35, Press F5. The workflow is executed correctly. A QUALITY THOUGHT * _-www.acebook.com/qthought * ‘www.qualitythoughtin PH NO: 7675827899, 040-48526948 46 Email Id: info@qualitythoughtinQUALITY THOUGHT UiPath Material lessageBox x | Congratulations. You guessed correctly! The number was 8. 3.Yariables Managing Variables Managing Variables In UtPath Studio, variables are used to store multiples type of data. Another key aspect of variables is that their value can change so that you can, for example, control how many times the body of a loop is executed ‘The data stored within a variable is called a value, and it can be of multiple types. In UiPath, we support a large amount of types, ranging from generic value, texi, number, data table, time and date, to UiElements. Creating Variables Note: Variables cannot be created if theMain panel does not contain at least one activity. From the Design ribbon: 1. On the Design ribbon tab, in the Variables group, sclect Create Variable > [Type of variable}. The Create Variablewindow is displayed. Create Number Variable iris [variabter Defautt Valve "0 Global Variable E71. : [Ceancer J ce QUALITY THOUGHT * www.facebook.com/qthought 7 www qualitythoughtin PH NO: 7675827899, 040-48526948 47 Email Id: info@qualitythoughtinQUALITY THOUGHT UiPath Material 2 I in the required fields and click OK. The variable is created and you can view and edit it in the Variables panel From the context menu or with a keyboard shortcut: UiPath Dialog Activities InputDialog EID | searen [ 3 Common i] Clear | DisplayName ‘nputciatog i Input | IsPassword Qo Label Type 8 number. Options Tite Secona Numver [= | © Mise Private © output real Variable, cr F reperties FE Outine 4 Output 1. In the Properties panel of any activity, right-click a field that can be edited, and select Create Variable from the context menu, or press Ctrl+K. A Set Name field is displayed. 2. Fill in the name and press Enter. The variable is created and you can view and edit it in the Variables pancl. The scope of activities created like this always belongs to the smallest container itis part of. Note: When creating variables like this, the type is automatically generated, depending on the selected property, SS ‘QUALITY THOUGHT + www.acebook.com/qthought + www.qualitythoughtin 48 PH No: 7675827899, 040-48526948 Email Id: info@qualitythoughtinQUALITY THOUGHT UiPath Material From the Variables panel: Name Vaiabletype Scope eta inser in aia ite 018 eesion ineconumber In Wain te <> Arguments npr Wem RE 1. Inthe Main panel, click Variables. The Variables panel is displayed. 2. Click the Create Variable line. 4 new variable with the default values in displayed. Note: By default, all new variables are of String type if you create them from theVariables panel Removing Variables + Inthe Variable panel, right-click a variable and select the Delete option. + Inthe Variable panel, select a variable and press the Delete key. Note: If you want to undo this action, press Ctrl+Z, You can also remove all the variables that are not used in your currently opened workflow: 1. On the Design ribbon tab, in the Variables group, select Manage Variables > Remove Unreferenced. Note that the Variables panel only contains the variables used in your ‘workflow. Browsing for .Net Variable Types To search for types of variables that are not displayed by default in the Variable Type list, do the following: 1. In the Variable panel, from the Variable Type drop-down list, select Browse for ‘Types. The Browse and Select a Net Type window is displayed. re ‘QUALITY THOUGHT = wwwfacebook.com/qthought * woww.qualitytnoughtin PH NO: 7675827899, 040-48526948 49 Email Id: info@qualitythoughtinQUALITY THOUGHT UiPath Material Browse and Select a Net Type | Twentame: [cel _ | : [4 — fs ¢ | 4 UiPatn.excet (1.000) t | 4 UiPathBxcel | ) Exceléaceptien lhl ( 4 vismybctaenes | 4 UipathExceLAciaties i ExoetAppendtarce | | ExcevappicatiorScope | I ExcelDereteCoi | ExcebfiterTabe | | ExeelGertabetinge | ExcelinsertColurn | Exoelinteropactvty | ExcelReadet EnceiResdel le Excelead ExcefRencs ExcelReadRo ExcelSelect2ans \ { ExcatSo: Tab \ Feral’ a — 2. In the Type Name field, type a keyword for the variable you are looking for, such as excel. Note that the result section is updated, displaying all the Net variable types that ( contain your keywatd. 3. Select one and click OK. A new variable is created with the selected type and is displayed in the Variables panel. Note: After using a type of variable from theBrowse and Select a Net Type window, displayed in the Variable Type drop-down list, in the Variables panel Promoting Variables to Global Scope Some variables, when created directly in an activity (from the context menu of an activity), ( are automatically given the smallest scope they belong to. To make them available in your entire workflow, do the following: t 1. Click the smallest container in a workflow. ( 2. On the Design ribbon tab, in the Variables group, select Manage Variables > Promote to Global Scope. All the variables used in the selected container now have a global r scope, Naming Best Practices ee ‘QUALITY THOUGHT Tworwacebookcom/aahoughe ‘rorw quallgythoughein t PH NO: 7675827899, 040.48526948 50 Email: info@qualitythoughtin (QUALITY THOUGHT UiPath Material When creating very large workSlows, it can be very easy to forget what every vatiable does. That is why it is important to have a good naming system in place, We recommend that you always use descriptive names, such as userName for a variable 1 that stores the name of a user. Additionally, you might want to keep track of the type of variable you create, and that is why adding a short descriptor in the front of each variable name can be useful, such as int ) for integers. Finally, we recommend that you write variable names in camel case, so that you can read them easier. Example of how to name your variables: ence ce |__ Generic V genVariableName | strVariableName_ Number “intVariableName } [True or False | boolVariableNam: __Date and Time | __timVariableName_ é) [Data Table _ ‘datVariableName i ‘The Variables Panel ‘The Variables panel enables you to create variables and make changes to them, Field “Desc Mandatory. The name of your variable. If you do not add a name to a variable, one is automatically generated. For more information on how to name your variables, see Naming Best Practices. Name Mandatory, Variable Enables you to choose the type of variable. The following options are available: Type + Boolean ) + In32 —————eeEeEEE—E—EEEEE————eee ) ‘QUALITY THOUGHT + wwwfacebook.com/qthought * wwwaualitythoughtin PH NO; 7675827899, 040.49526948 Bf Email I: info@qualitythougntinQUALITY THOUGHT UiPath Material ‘String Object Generic Value Array of [T} ‘Browse for Types Mandatory. Scope The area in which a variable is available, such as a specific activity. By defauh, they are available in the entire workflow. Optional Default The default value of the variable. If this field is empty, the variable does not have a default value. ty Ss Generic Value Variables ‘The generic value variable is a type of variable with a wide range that can store any kind of ata, including text, numbers, dates and arrays, and is particular to UiPath Studio. Generic value variables are automatically converted to other types, in order to perform certain actions. However. it is important to use these types of variables carefully, as their conversion may not always be the correct one for your workflow. Example of Using a Generic Value Variable To demonstrate how a generic value variable can be converted and used, let's create a workflow that displays in the Output panel the sum of two numbers, using generic value variables with different types of values. 1. Create a flowchart. 2. Create three generic value variables, genNumber, genString and genSum. 3. In theDefault column for the genNumbervariable, type 2, and _ for the genString variable, type"2." The first value is interpreted as as integer, and the second one as a string LS ‘QUALITY THOUGHT = www.facebookcom/qthought =~ www.qualitythoughtin PH NO: 7675827899, 040-48526948 52 Email 1d: info@qualitythoughtin (QUALITY THOUGHT one center ae ‘essen ars gens Ingots ars Wile ese Sescie \eoete oO UiPath Material soe Deut od Foc owe HP 0% |. Add an Assign activity to the Main panei and connect it to the Start node. In the Properties panel, in the To field, enter the genSumvariable, In the Value field, type genNumber+gensString, Add a Write Line activity and connect it to the Assign one. In the Properties panel, in the Text field, enter the genSumvariabie. Start ‘ae6 Assion gensum = genNumber + gen’ BB write line Text genSum | 9. Press FS to execute your workflow. Note that, in the Outputpanel, the sum of the two numbers is displayed QUALITY THOUGHT. PH NO: 7675827899, 040.48526948 ‘www facebook.com/qthought 53 ‘wwrwqualitythoughtin Email Id: info@qualitythoughtinQUALITY THOUGHT UiPath Material 19:11:20 4 19:11:20 Generic Value execution ended in: 00:00:00 F tespenies ‘Outline el Gurpur ‘This means that UiPath Studio knows that the genNumber is an integer and knows how to transform the generic value genStringvariable to an integer, so that it can add it to the first one. However, keep in mind that this was cur goal from the beginning. 1f we wanted to display the two variables in the Output panei as strings using this exact method, it would not have worked. Text Variables A text or string variable is a type of variable that can store only strings. These types of variables can be used, for example, to store names, passwords or information extracted froma table, Note: All strings in UiPath Studio have to placed in between quotes. Example of Using a Text Variable ‘To exemplify how you can work with text variables, we are going to create a workflow that asks for the user's name, stores it and displays only the frst letter of his name i the Output panel. 1, Create a sequence. 2. Create two simple string variables, strFullName and strFirstLetter. fre weabemme Soe Dest sane svg Nein Feros ‘sone, sting Wain | eo opresen - 3. Addn Input Dialog activity to the Main panel, ed QUALITY THOUGHT * _ wwwsfacebook.com/qthought + wwwaqualitythoughtin PH NO. 7675827899, 040-48526948 54 Email 1d: info@qualitythought.inQUALITY THOUGHT UiPath Material 4, Inthe Properties panel, in the Label field, type "ype your full name please.” In the Titlefield, type "What is your name?” 6. inthe Result field, add the StrFullName variable. This variable stores whatever the user writes when prompted with the Input Dialog activity. 7. Add an Assign activity wader the Input Dialog one. 8, Inthe Properties panel, in the To Geld, add the strPFirstLetter variable. 9. In the Value field, type strFullName.Substving(0,1). The strFirstLetter variable is assigned the new value created by the strFullName Substring(0,1}expression. Note: This field uses the Substring()function to find the first character from the string added by the user in the Input Dialog. 10.Add a Write Line activity under the Assign one 11.In- the Properties panel, in the Textfield, enter _the strFirstLetter variable. The Output panel is going to display the first letter of what the user wrote in the Input Dialog. The workflow should Jook as in the following screenshot. ey Main 1 input dialog » “What is your name?’ “Type your full name please. fe8 Assign strFirstLetter = stiSuliName.Substr | re tne Text | strFirstLetter in a QUALITY THOUGHT = www.facebook.com/qthought = wwwqualitythaughtin PH NO: 7675827899, 040-48526948 55 Email Id: info@qualitythoughtinQUALITY THOUGHT UiPath Material ——— 12. Press FS. The What is your name winclow is displayed. 13.Type your name in the text field and click OK. In Uipath Studio, in the Output panel, note that the first letter of your name is displayed. 180047 N 18:00:47 Generic Value execution ended in: 00:00:33 | | | } F Properties True or False Variables The true or false variable, also known as boolean, is a type of variable that oniy has two possible values, true or false. These variables enable you £0 make decisions, and thus have a better control over your low Example of Using a True or False Variable To exemplify how you can work with true or false variables, we are going to create a workflow that asks the user for his name and gender, and displays the results in another window. 1. Create a new workflow. 2. Create two string variables, strName and strGender. The first is going to be used to store the name of the user, and the second to store the user’s gender, 3. Create a boolean variable, boo!Male. This variable is used to verify ifthe user is a male. tne — ene Soe Dut fore Sy se tc yin Keto oy Win Eee iBegin belle Ai Mais foe 2 8 epson ‘QUALITY THOUGHT > www lacebookcom/qthoughe PH NO: 7675827899, 040-48526948 56 PAQUALITY THOUGHT UiPath Material 4. Add an Input Dialog activity to the Main panel and connect itto the Start node. 5. Inthe Properties panel, in the Label field type "What is your name?” 6. Adda title and, in the Result field, add the strvame variable. 7. Add another Input Dialog activity and connect it to the previous one. 8. 9 1 In the Properties panel, in the Label field type "What is your gender? Adda title and, in the Result field, add the strGendervariable. 0. Add a Flow Decision activity to the Main panel, and connect it to the second Input Dialog, 11. In the Properties panel, in the Condition field, type strGender = "Male" or strGender = “male”. This activity checks if the user is a male or female. 12. Add two Assign activities. 13. Connect one to the True branch of the Flow Decision activity. 14. In the Properties panel, in the To field enter the boo!Male variable. 15. In the Value field, type True. This assigns the True value to the boolMale variable when the strGender = "Male" or strGender = "male" condition is met. 16. Connect the second Assign activity to the False branch of che Flow Decision. 17. In the Properties panel, in the To field, enter the boolMalevariable. 18.In the Value field, type False. This assigns the False value to the boolMale variable when the strGender = "Male" or strGender = "male" condition is not met. 19. Add a new Flow Decision and connect the previously added Assign activities to it. 20. inthe Properties panel, in the Condition field, type booiMale = True. 21. Add a Message Box activity and connect it to the True branch of the Flow Decision. 22. In the Properties panel, in the Text field, type stName + " is a” + strGender +". This message displays the name of the user and its gender, if boolMale is true. 23.Add another Message Box activity and connect it to the Falsebranch of the Flow Decision. 24. In the Properties panel, in the Text field, type strName + "is a" + strGender + ".". This message displays the name of the user and its gender, if boolMale is false. ‘The final workflow should look like in the fol;owing screenshot. SS ‘QUALITY THOUGHT = wwwfacebook.com/qthought + wwwaqualitythoughtin PH NO: 7675827899, 040-49526948 57 Email ld: info@qualitythought.inQUALITY THOUGHT UiPath Material Start T ’ (3 Input dialog Double to view ’ 1D) Inpit dialog Heck ie ’ Decision sev Assign we Assign bootMale = Tne booiMale false Tue False i , ’ Message box (i Message box Double-click to view Double-click to view 25.Press F5. The workflow is executed. Note that the final Message Box displays the message as expected. QUALITY THOUGHT = wwwfacebook.com/qthought * ‘www.qualltythought in PH NO: 7675027899, 040-48526948 58 Email ld: Info@qualltythoughtinQUALITY THOUGHT UiPath Material ————__————————— Message box x Karen is a Femate. Number Variables Number variables are also known as integer or Int32, and are used to store numeric information. They can be used to perform equations or comparisons, pass important data, and many others. Example of Using a Number Variable ‘To exenplify how you can work with number variables, we are going to create a workflow that asks the user for the year in which he or she is born and displays the age in a window. Create anew sequence Create two Int32 variables, intBirthYear an year and the second, the user's age ‘Add an Input Dialog activity to the sequence. In the Properties window, type an appropriate title and label. In the Result field, add the intBirthYear variable. Add an Assign activity under the input Dialog. Jn the Properties panel, in the To field, add the intAgevariable. In the Value field, type 2016 - intBirthYear. This assigns the value of the subtraction (2016 - user's birth year) to the intAge variable. ‘Add a Message Box activity under the Assign one. 19.In the Properties panel, in the Textfield, type "Congratulations! You are * + intAge.ToString +”.”, intAge. The first stores the user's birth euanaw Note: The .ToString method converts the integer stored in the intAge variable to a string and display itas such. The final workflow should took as in the following screenshot SS ‘QUALITY THOUGHT = www:faceboak.com/qthought * www.qualltythoughtin PH NO: 7675827699, 040-48526948 59 Email 1d: info@qualitythought.inQUALITY THOUGHT UiPath Material Mains Co Tapat aiaieg » "Birth Year" “What year were you born in?’ es Assign intage = 2016 - intBirthYear a Message box a “Congratulations! You are” - intAge.ToString +." = 11. Press F5. The workflow is executed. Note that the Message Box displays your age, as, expected. Message box x Congratulations! You are 26. QUALITY THOUGHT __www.acebook.com/athought PH NO: 767582789, 040-48526948 60 ‘worw.qualitythoughtin Email Id: info@qualitythoughtinQUALITY THOUGHT UiPath Material Array Variables The array variable is a type of variable which enables you to store multiple values of the same type. UiPath Studio supports as many types of arrays as it does types of variables. This means that you can create an array of numbers, one of strings, one of boolean values and so on. Example of Using an Array Variable To exemplify how you can work with array variables, we are going to create a workflow that asks the user for his first and last name and age, stores the information in an array and then writes it in a.txt file. Create a new sequence. 2. Create three string variables, strFirstName, strLastName and strAge, in which to store the information gathered from the user. 3. Create an array of strings variable called arrStringNameAge. nave wwomenpe sore Ort answeghnetce seo Nin x10 eoressoe sane seg tea stacthne srg men , sige sung in ae Sle 4, Add an Input Dialog activity to the Main pane 5. Inthe Properties pane; fill in the Label and Title fields to ask for the user's first name. 6. In the Result field, add the strFirstName variable. This variable stores the first name of the user. 7. Add another Input Dialog activity under the previous one. 8. Inthe Properties panel, fill in the Label and Title fields to ask for the user’s last name. 9. In the Result field, type the strLastName variable. This variable is going to store the last name of the user. 10. Add another Input Dialog activity under the previous one. 11. In the Properties panel, fill in the Label and Title fields to ask for the user’s age. 12.In the Result field, type the strAge variable. This variable is going to store the age of the user. Note: We use a string variable and not an integer to store the age, so that we do not have to convert it later on, when we add it to the string array variable. 13. Add an Assign activity under the last Input Dialog. 14.1n the Properties panel, in the To field, type the arrStringNameAge variable, a ‘QUALITY THOUGHT *_ wwrwifacebook.com/qthought + www.qualitythoughtin PH NO: 7675827899, 040-48526948 Gi Email: info@qualitythoughtinQUALITY THOUGHT UiPath Material 15.1n_ the Value field, type {strFirstName, strLastName, steAge}. This Assign activity enables you to store all the values from the initial string variables in the arrStringNameAge one. 16. Add a Write Text File activity under the Assign one. 17.In the Properties panel, in the FileName field, type the path of the file you want to write to between quote marks, such as "C:\Users\MADa\Desktop\array_vatiable.tst” Note: If the file does not exist at the provided path, it is created. 18.In the Text field, type arrStringNameAge(0) +" " + arrStringNameAge(1) + " " +arrStringNameAge(2) +”. Note: By adding the index number of the array items you can access their values and \write them, in this example, co a text file. ‘The final workflow should look as in the following screenshot. J. input diate OB » | (2 wenames a Age we Assign arStringNameAge |=! (strFirstMomestla [D Weite ext tite A “CAUsers\MADA\Deskaap\array variable te | arstringniameageo) + arrsuingNameage() = SS ‘QUALITY THOUGHT =” www-facebook.com/qthought * www.qualitythoughtin 62 PH NO: 7675827899, 040-48526948 Email Id: info@qualitythought.in anQUALITY THOUGHT UiPath Material 19. Press F5. The workflow is executed, 20.Navigate to the file provided at step 17 and double-click it. A Notepad window is displayed with the information you added at step 20. | Blanayvariable-.. — Qo x File Edit Format View Help Bob smith 43 | Date and Time Variables The date and time variable is a type of variable that enables you to store information about. any date and time. This type of variable can be found in the Browse and Select a .Net ‘Type window, under the System namespace (System.DateTime). For more information, see Browsing for.Net Variable Types. For example, they can be used to append dates to invoices or any other documents you may be working with and are time-sensitive. Example of Using a Date and Time Variable "To exemplify how you can work with a date and time variable, we are going to build a workflow that get the current date and time, subtracts a specified amount of time and writes the result to a Microsoft Excel spreadsheet. Create a new sequence. Create two DateTime variables, timToday and timLastTime. Create a TimeSpan variable, called timSpan, and in the Default field type 1.02: Note: the default value attributed to thetimSpan variable uses the day.hh:mm:ssformat. 4. Add an Assign activity to the Main panel. 5. In the Properties panel, in the To field, add the timTodayvariable. 6. In the Value field, type Now. This gives you the date and time when the workflow is executed, in the dd/MM /yyyy and hh:mm:ss formats. 7. Add another Assign activity under the previous one. (QUALITY THOUGHT ‘www facebook com/qthought + wwwaqualitythoughtin ‘PH NO: 7675827899, 040-48526948 63 Email 1d: info@qualizythoughtinUU QUALITY THOUGHT UiPath Material ee 8, In the Properties panel, in the To field, add the timLastTime variable. 9, In the Value field, type timToday.Subtract(timSpan}. This is going to subtract the default value of the timSpanvariable from the current date and time, stored in the timToday variable. 10. Add an Excel Application Scope activity under the last Assign one. Note: If you do not have Excel activities installed on your version of UiPath Studio, use the Manage Packages functionality to get them, 11. In the Properties panel, in the WorkbookPath field, type the path of the Excel file you want to write to, between quotation = marks. = In. our case, "C:\Users\Username\Desktop\urgent invoice.xisx”, Note: Ifthe ile does not exist at the provided path, itis going to be created. 12. Add a Write Value activity in the Excel Application Scopeactivity. 13.In the Properties panel, in the Range field, type the coordinates of an Excel cell between quotation marks. In our case, "G3." 14. In the Sheet Name ficld, type the name of the sheet in Which you want to write. tn our case, “Invoice’. Note that if the sheet does not exist, itis going to be created, 15.In the Value field, type timLastTime-ToString, This transforms the value of the timLastTime variable to a string and writes it to the coordinates previously given. The final workflow should look as in the following screenshot. ‘QUALITY THOUGHT = wwwfacebookcom/athought *worw.qualitythoughtin PH NO: 7675827899, 040-48526948 64 Email Id: info@qualitythoughtinQUALITY THOUGHT Man oe Assign {umtoaay woe Assign ‘ymtastime B) bie application scope Users MADE\Desk Do + Write Value “Invoice timLastTime ToStiog 16. Press FS. The warkflow is executed. UiPath Material -lNow = timToday Suoract, & co 17. Navigate to your Excel file and double-click it. Note that the time and date information is displayed in the cell you pointed towards QUALITY THOUGHT * PH NO: 7675827899, 040-8526948 ‘www facebook.com/qthought * 6s www.qualitythoughtin Email Id: info@qualitythoughtinQUALITY THOUGHT UiPath Material ism) ieee oe Bee se Bcetsye- ‘gala ee | yet Ne Sy [x vf ebasco16 5:08.29 9m : apa io: (Siena 6 ae F ° Ws Parker Tech invoice | ‘etna Gon ane i Chr tte, 4102 \ (12 6670 } sits: ce Dale uns Gren ane « poeta (on eer a sa feats Cove 221 Description Amount service Appotient rts ad Labor 2.50 suotoat an Tex Rate ve Ba | Total due Data Table Variables Data table variables represent a type of variable that can store big pieces of information, and act as a database or a simple spreadsheet with rows and columns. They can be found in the Browse and Select a .Net Type window, under the System.Data namespace (System Data.DataTable). For more information, see Browsing for Net Variable Types. ‘QUALITY THOUGHT * -wwwsacebookcom/qthought * ‘wwwqualitythoughein PH NO: 7675827899, 040.48526948 66 Email Id: info@qualitythoughtinoo QUALITY THOUGHT UiPath Material These variables can be useful to migrate specific data from a database to another, extract information from awebsite and store it locally in a spreadsheet and many others. Example of Using Data Table Variables To exemplify how you can use data table variables, we are going to create a workflow that reads only two out of multiple columns from an Excel spreadsheet, and then transfers them to another spreadsheet that already contains other information ‘The initial file is a database of people, their age, location and e-mail address. In this example, we are going f0 extract their names and e-mail addresses and append them to an Excel spreadsheet that already contains similar information, Create a new sequence. 2. Add on Excel Application Scope activity to the sequence. This activity is required for most of the Excel-related activities. Note: If you do not have Excel activities installed on your version of UiPath Studio, use the Manage Packages functionality to get them. 3. Create two data table variables, datNamesList and DatMailList. These are going to be used to store information from the initial Excel spreadsheet. 4. In the Properties panel, in the WorkbookPath field, type the path of the initial Excel file to be used, between quotation marks. 5. Add two Read Range activities and place them one under the other, in the Excel Application Scope activity. These are used ta get information from the initial spreadsheet. 6. Select the first Read Range activity and, in the Propertiespanel, in the Range field, type "A2:A21.", These are the Excel table coordinates that tell UiPath Studio from where to extract information. 7. Inthe SheetName feeld, do not make any changes as the name of our sheet is the default one, Sheet. 8. Inthe DataTable field, type the name of the frst data table variable, datNamesList. This variable stores all the information available between the A2 and A21 rows. 9. (Optional) Change the value in DisplayName field to Read Names, so you can easily tell apart this activity from the second one. 10.Select the second Read Range activity, and in the Propertiespanel, in the Range field, type "D2:D2.” These are the Excel table coordinates that contain the e-mail information we want to extract. 11. In the DataTable field, specify the datMailL st variable. T! information we require. 12. Add a Write Range activity to the Main panel, under the Excel Application Scope. This activity is used to write the stored information to another Excel file. variable retains all the mail ‘QUALITY THOUGHT ‘wwwfacebook.com/qthought + wwww.qualitythoughtin PH NO: 7675827899, 040-48526948 a Email la: info@qualitythoughtinQUALITY THOUGHT UiPath Material Note: The file used with the Write Rangeattivity has to be closed when you run the workflow. Ifit is not closed, an error is displayed and the workflow execution stops. 13. n the Properties panel, in the WorkbookPath field, type the path of the Excel file to be used to store all the information gathered at the previous steps. 14. In the DataTable field, type the datNamesList variable. 15.In the SheetName field type Database, and in the StartingCell, type "C21." This is the starting cell in which information from the initial file is to be added. 16, Adel another Write Range activity and place it under the first one. 17.In the Properties panel, fill in the WorkbookPath and SheetName fields as for the previous Write Range activity. 18. In the Starting Cell field, type "D21." 19. In the DataTable field, type the datMailList variable. G bce spotcanion veope 1 secwence a | | | | waite ange a“ ‘QUALITY THOUGHT = wwwifacebook.com/athought + www.qualitythaughtin PH NO: 7675827899, 040-48526948 68 Email i: info@qualitythoughtin) QUALITY THOUGHT UiPath Material 20. Press FS. The workflow is executed. 21. Double-click the final Excel file, Note that the copied information is available, and correctly updated. BRE SR en Bent zon ay ke SSE $20) romnamie — Bowe: DO ew. BE Feasye Brome #* coed sr signin ae oes cat | eng A nt b 7 [Flor ose Bruce cusumano@ gmail.com (caer Coen Gara saneeyshoo com rin Mccoy Dan Totiegnsizom ings at] thea Hosen tre rodoccom = — Foe rapione@r Iearak@rtewrne com Suen ors lef Dikwatar@cumpanaso Roser com [Setanta iynnoed velo OL cm Josh end Madonna Vanegas mid com Inve some [Care actebeeh@oriosk am | Myra Duhe@® dukes Rene slama@radie.com Lost Massey ——FRobt usbanacanamie.com (cares Greene Shir.£scret@vebleom ike Corie | Sophietrocha@hoff er Beet Garber StefaniNeptune@ index com, Marcel Chandos “TomnPi@emsrk com. fee ae Cartes Gararane®yshoo.com Dano [ban Tefi@gmai.com acest Thomo, Hotes Tore Hosea oro@rodoe com oe Mog tolamagione k Ee Pea ae > i - 1+ wn Managing Arguments Arguments are used to pass data from a workflow to another. In a global sense, they resemble variables, as they store data dynamically and pass it on. Variables pass it to other activities, while arguments pass it to other workflows. As a result, they enable you to reuse workflows time and again. SS QUALITY THOUGHT *_ wwwfacebookcom/athought + wwwqualitythoughtin PH NO: 7675827899, 040-48526948 68 Email ld: info@qualitythoughtinath Material QUALITY THOUGHT UiPath Studio supports a large number of types of arguments, which coincide with the types of variables. Therefore, you can create generic value, string, boolean, object, array, data table arguments and you can also browse for .Net types, just as you do for variables. Additionally, ‘Srguments have specific directions (In, Out, In/Out, Property) that tel the application where the information stored in them is Supposed to go. Creating Arguments To create a new argument: 4, Inthe Main panel, click Arguments. The Arguments panel is displayed. Nae Direction fagumert yee etait aie aes » st09 Vanier gure: impos ao HE 2. Click the Create Argument line. A new argument with the default values is displayed. Note: By default, all arguments are of typeString and have an In direction. Removing Arguments To remove an argument: + Inthe Arguments panel, select an argument and press Delete. + Inthe Arguemtns panel, right-click an argument and select the Delete option. www.qualitythoughtin ‘QUALITY THOUGHT > werwfacebook.com/qthought * 70 ‘Email ld: info@qualitythought.in PH NO: 7675827899, 040-48526948QUALITY THOUGHT UjPath Material ‘Name Sterelu Cte gmt Variables Arurertslnpats Vem RA Naming Best Practices To easily reuse workflows, it is important to have a good naming system in place for your arguments. We recommend that you always use descriptive names, such as UserName for an argument that stores the name of a user. Additionally, you might find it useful to use title case for all your arguments, so that you can read their names with ease and tell them apart from variables. The Arguments Panel ‘The Arguments panel enables you to create arguments and make changes to them. ian Mandatory. Name The name of your argument. Ifyou do not add a néme to an argument, one is automatically generated. For more information on how to name your arguments, see Naming Best Practices. Mandatory. Direction bs SS ‘QUALITY THOUGHT = wwwfacebookcom/athought = wwwqualltythoughtin PH NO: 7675827899, 040-48526948 a Email I: info@qualitythoughtin\ | ! QUALITY THOUGHT UiPath Material Select a direction for your argument. The following options are available: + In- the argument can only be used within the given workfow. + Gut the argument can be used to pass data outside of a given workflow. + In/Out - the argument can be used both within or outside of a given workflow. + Property - not currently used. Mandatory. Choose the value type you want your argument to store. The following options are available: + Stir Argument > Ine3z Type. object + Array of [T] + Browse for Types Ifyou select a Net type from the Browse and Select a Net Type window, itis added to the Argument Type drop-down list. Optional Default Vala ‘The default value of the argument. If this field is empty, the variable does not have a default value. Using Arguments Due to the nature of arguments, you are going to use them a lot in relation with the Invoke Workflow File and Launch Workflow Interactive activities. They can be found in the Activities panel, wnder Workflow > Invoke and they enable you to browse for a workflow, and import and edit their arguments, Example of Using an Argument ‘To exemplify how to use an argument in a workflow with an Invoke Workflow File activity, we are going to create two separate sequences. A very simple one in which to assign a value to an argument, and a second that invokes it and displays the value in a message box. eel ‘QUALITY THOUGHT + www.acebookcom/qthought + wwwe.qualitythoughtin, PH NO: 7675827899, 040-48526948 n Email Id: info@qualitythoughtinL QUALITY THOUGHT UiPath Material Create a new sequence. In the Arguments panel, create an argument, StoreValue, From the Direction list, selectut, and do not change the Argument ‘Type from String. ‘Add an Assign activity to the Main pane. In the Properties panel, in the To field, add the StoreValue argument. In the Value field, type a string, such as "How does one use an argument?". ane ‘The first workflow should look as in the following screenshot. Main wa Assign StoreValue = “How does one use 7. Create a new sequence. 8. Create a string variable, strFinalValue. 9. Add an Invoke Workflow File activity to the Main pane 10.0n the activity, click the Browse (...) button and browse for the previously created sequence. 11.Click Import Arguments. The Invoked Workflow’s Arguments window is displayed. Note that the argument of the first sequence is displayed here. 42.1n the Value field, add the strFinalValue variable and click Ok. The argument is imported and the value from it is going to be stored in the current workflow through the strFinalValue variable. 13. Add a Message Box activity under the Invoke Workflow File. 14.In the Properties panel, in the Text field, type strFinalValue + " This is how”, for example. ‘The second workflow should look as in the following screenshot. OE ETT ae SNRs ‘QUALITY THOUGHT = www.acebook.com/qthought * www.qualitythoughtin PH NO: 7675827899, 040-48526948 73 Email Id: info@qualitythoughtinr JUALITY THOUGHT i ein D> rwake worttow file a “Argument loam - ait Arguments || Import Arguments a Meseage box a sseFinalvalue + ~ Ths stow 15. Press F5 in the second sequence. The workflow is executed correctly and the message box displays the desired text. 8 teessage box x How Coes one use an argument? This is how 6.mported Namespaces About Imported Namespaces \VBNet namespaces in UiPath Studio represent containers that store different types of data. ‘They enable you to define the scope of your expressions, variables and arguments, For example, if you have the SystemDatanamespace imported, you can further use DataTable, DataView, DataColumn, DataRow and other classes that are available in it, without having to always type System Data DataTable and so on. All imported namespaces are displayed in the Imporés panel. Note that some namespaces are automatically imported when you browse for a .Net type variable or argument, for example. To open this panel, click imports in the Main panel. —_————$ ‘QUALITY THOUGHT www facebook.com/athought *-www.qualitythoughtin PH No: 7675827899, 040-48526948 4 Email Id: info@qualitythoughtinQUALITY THOUGHT UiPath Material SS nad 290 aT : Tex.vnabe ‘pm Coupe “Whats yo ame “pe you tl vane please” stoslener = etfulanesome 1 Witeie ‘parted namespaces Mesosfsaasc icrsef.Vswas cies System Sytemctivies ‘Stem Aves Express Spe actitiesStaterests Sstemactvtasnation About imported Namespaces VB.Net namespaces in UiPath Studio represent containers that store different types of data. They enable you to define the scope of your expressions, variables and arguments, For example, if you have the System.Datanamespace imported, you can further use DataTable, DataView, DataColumn, DataRow and other classes that are available in it, jout having to always type System.Data.DataTable and so on. All imported namespaces are displayed in the Imports panel. Note that some namespaces are automatically imported when you browse for a .Net type variable or argument, for example. To open this panel, click Imports in the Main panel SS QUALITY THOUGHT * -wwwlacebook.com/qthought + www.qualitythoughtin PH NO: 7675827899, 040.48526948 5 Email ld: info@qualitythoughtinQUALITY THOUGHT UiPath Material Ss ey Object AAARARETAESEY - Test Vanabie 2 Cotapse At “Whats you came?” “Type you ful name pease” hi | swiinteter —— syfllName Sut, Wt te pened namesces arose iui ert vanes: ‘System Sytem dees Sytem ates Eapesons Sem Actes Siemens Stem Actives tiation Stemcttesdamineg on Stems Shemale eerie Sytemconfigurtion smemData ‘erties Amen Namespaces To add new namespaces to your library: 1. Open the Imports panel, 2. In the Enter or Select namespace field, start typing the namespace that interest you. Note that suggestions are provided while you type, in case you are not exactly sure what you are looking for. eel QUALITY THOUGHT * —_wwwfacebook.com/qthought = worwqualtythoughtis PH NO: 7675827899, 040-48526948 76 Email 1d: info@qualitythoughtin= C QUALITY THOUGHT UiPath Material Vertis Arrests ingors WF om - RE 3. (Optional) Click the drop-down arrow to view and browse all available namespaces. 4, Select the desired namespace. The namespace is added to the imported Namespaces list To remove a namespace, select it and press Delete. Note that namespaces can only deleted if they are invalid. For example, you can delete a namespace if the assembly that vontains it is no longer referenced by the project. About Control Flow An important aspect of successfully working with UiPath Studio is understanding and knowing how to control your workflow. As in computer science, in UiPath this concept is referred to as control flow. A proper control flow can be achieved through the intelligent use of variables, and of certain activities All of these activities can be found in the Activities panel, under Workflow > Control Flow. QUALITY THOUGHT PH NO: 7675827899, 040-48526948 www qualitythoughtin ‘wwwfacebook.com/qthought 7 Email Id: info@qualitythoughtinQUALITY THOUGHT UiPath Material Activities ao ao = [2 searer” b Programming 4 Workflow 4 Controt Flow *B Assign Cancellation Scope Delay Do White uf 3008 2 2 Parallel é Parallel For Each With Body Factory e © Pick i Sequence Switch i White For Each Gata Break 1 Flowenart BS Activities | CP Liprary CF Project They enable you to define rules and automate decisions for a given workflow, through if_.else or for each statements or loops, as well as add delays so that you can perfectly time wo activities. Loops represent an important part of workflows as they enable you to easily check dependencies between variables, activities and conditions. They are created once and enable you to iterate data a specified number of times, until a condition is met, once for each item in a collection or indefinitely, The Assign Activity ‘The Assign activity is a pretty important activity that is going to be used quite often, as it enables you to assign a value to a variable. Oe QUALITY THOUGHT, + wavwlacebook.com/qthought = www.qualitythoughtin 78 PH NO: 7675827899, 040-48526948 Email 1d: info@qualitythoughtin —QUALITY THOUGHT UiPath Material ————— ea Assign | [ stfirstLetter = sifullName.Substr You can use an Assign activity to increment the value of a variable in a loop (see the example in the Do While Activity chapter), sum up the value of two or more variables and assign the result to another variable (see the example in theGeneric_Value Variables chapter), assign values to an array (see the Array Variables chapter) and so on. By default, this activity is also included in the Favorites group. To remove it, right-click it and select Remove. The Delay Activity The Delay activity enables you to pause the workflow for a custom period of time (in the hh:mm:ss format). This activity proves itself quite useful in workflows that require good timing, such as waiting for a specific application to start or waiting for some information to be processed so that you can use it in another activity, Example of Using the Delay Activity To exemplify how you can use the Delay activity, lets create a workflow that writes two ‘messages ta the Output panel, with a delay of 20 seconds between them. Create a new flowchart. Add a Write Line activity and connect it to the Start node. Select the activity, and in the Text field, type "This is the start time. Add a Delay activity and connect it to the previously added activity. Select the activity, and in the Properties panel. in the Duration field, ty; is the 20 seconds delay that is going to be between the two logged messages. Add another Write Line activity and connect it to the workflow. In the Text field, type "Message delayed by 20 seconds.". aaeNe 10:00:20. This ‘The final workflow should look as in the following screenshot. OO TST oe el ‘QUALITY THOUGHT + wwwfacebook.com/qthought _wwwqualitythoughtin PH NO: 7675827899, 040-48526948 79 Email Id: info@qualitythought.in Cc— QUALITY THOUGHT UiPath Material SS Se © Start & wiite line Text | “This is the start time @ Delay IE Write tine Text “Message delayed by 20 sece 8 Press FS. The workflow is executed. Note that, in the Outputpanel, the two messages added in the Write Line activities are written twenty seconds apart. n E iz Ae Ge Be Be ~ Search © 06/27/2016 12.27.48 This i time. — ® 06/27/2016 17:28:08 Message detayed by 20 seconds. 06/27/2016 17:28:08 Generic Value execution ended in: 00:00:20 e start | oamcel Calontsre) F Properties SS (QUALITY THOUGHT * -www.facebook.com/qthought = wrww.qualitythoughtin PH NO: 7675827899, 040-48526948 80 Email Id: info@qualitythoughtint ! C QUALITY THOUGHT UiPath Material The Do While Activity The Do While activity enables you to execute a specified part of your workflow while a condition is met. When the specified condition is no longer met, the workflow exists the oop. This type of activity can be useful to step through all the elements of an array, or execute a particular activity multiple times. You can increment counters to browse through array indices or step through a list of tems. Note: Do While activities are evaluated only after the body has been executed once. Example of Using a Do While Activity To exemplify how to use a Do While activity, let's create a workflow that increments an integer variable from 0 to 10, and displays a message every time it is incremented. 1. Create a new sequence. 2. Create an integer variable, intCounter, with a default value of 0. 3. Add a Do While activity to the Main pattel. 4, Select the Assign activity, and in the Properties panel, in the To field, add the intCounter variable. In the Value field, type intCounter + 1. This inelps you increment the value of the variable with one, ,. Add @ Write Line activity, under the Assign one. In the Text field, type "The counter is” + intCounter-Tostring. This writes the value of the counter in the Output panel each time itis incremented 8. In the Condition section of the Do While activity, type intCounter < 10. The body of the Do While activity is repeated until the value of the intCounter variable is bigger than 10. ry ‘The final workflow should look as in the following screenshot el QUALITY THOUGHT *_ wwwfacebookcom/qthought + www qualitythoughtin PH NO: 7675827899, 040-48526948 a1 Email Id: nfo@qualitythoughtin