UiPath Healthstream
Can activities which require a Use Excel App container run on a machine w/o Excel installed?
No, these activities require Excel to be installed
Regular Expression (REGEX or regexp)
A specific search pattern that can used to easily match, locate and manage text. UiPath has a REGEX builder that simplifies the expressions. Typical uses: Input Validation, String Parsing, Data Scraping, String Manipulation
When creating a process w/ multiple nested decisions, you'd opt for the Flowchart layout?
True
Choose 2 activities you can use w/ existing .xlsx document w/o overwriting existing data. A Excel Append Range B Excel Write Cell C Workbook Append Range D Workbook Write Range
A & C
Benefits of Chromium API over Simulate
- allows sending hotkeys directly to browser, Simulate doesn't support hotkeys - clear before typing is natural with this method - click with modifiers actions are more efficient and reliable
Steps to start using reference type like Lists or Dictionaries
1-Declare a reference variable, ex System.Collections.Generic.List<T> 2-instantiate an object to be assigned as initial value using expression , ex new List(of String) 3-Assign object either by using Default value in variable panel or by using Assign activity
Steps for RPA Inplementation
1-Prepare RPA 2-Solution Design 3-Build RPA 4-Test RPA 5-Stabilize RPA 6-Constant Improvement
Which design experience does the Full Text Output method belong to?
Both Classic & Modern
By using the Table Extraction Wizard, you have already scraped the structured data with the required configuration. Later you realized that you didn't set a limit for the extraction. How can you solve that?
Accessing the Editing Extract Data option in the context menu of Extract Table Data Activity Edit the value in the properties panel of the Extract Table Data activity
Methods of object
Actions that an object can perform. Methods often have parameters that qualify how the action is performed. Ex: Username.Replace("John","Jack") returns "Jack Doe"
UiPath methods applicable to collections
Add to Collection, Remove from Collection, Exists in Collection and Clear Collection
Object Repository
Allows developers to store UI element identifiers in a repository, fine-tune them and share them w/ colleagues for much faster automation development and project update ONLY in Modern
Filter Data Table Activity
Allows filtering DataTable thru a Filter Wizard, using various conditions. Can be used to create a new DataTable for the output or to keep existing one and delete entries that do not match the filtering conditions
Table Extraction
Allows us to automatically extract structured data from apps and save it as a Data Table object If use Table Extraction Wizard the Extract Table Data activity is automatically generated
You are building an automation with Notepad. You want to perform a UI action on a specific Notepad file. To indicate the required Notepad file to be opened, which property of Use App/Browser Activity do you need to configure?
Application Arguments
Workbook Activities
Are executed in the background, do not require Excel to be installed, only works for .xls and .xlsx files not .xlsm files.
Properties of objects
Aspects of an objects behavior. Ex: the string class contains 2 properties. Chars and Length. So UserName.Chars returns the char (character) at a specified position in the string object. userName.Length returns length
What is the purpose of the Activate option in the Type Into activity?
Brings a specified UI element to the foreground
Activities that create DataTables
Build Data Table Activity; Read Range Activities; Read CSV Activity; Data Scraping Action; Generate Data Table from Text Activity
Contains string method
Checks whether a specified substring occurs within a string. Returns T or F Expression: VarName.Contains("text") Output datatype: Boolean
Input actions
Click, Send Hotkey, Type Into
Default input method
Clicks: the mouse cursor moves across the screen
Build Data Table window
Can rearrange columns and rows by dragging and dropping: click pencil icon to; select any data type; if Int32 can auto increment; mark unique to not allow duplicates, edit number of rows and columns and max length. Can rearrange columns by dragging and dropping.
Verify execution use
Check clicking the button, typing into field or hovering over a UI element Can set to verify if element appears, disappears, text changed or is visually changed
While
Checks if the expression is True and then executes the activities in the Body section
Dictionaries or Dictionary<TKey,TValue>
Collections of (key,value) pairs, data types for both have to be chosen when variable declared Actions often used: Adding and deleting (key, value) pairs, retrieving the value associated with a key, re-assigning new values to existing keys
Join Data Tables
Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the JoinType property
String.Join string method
Concatenation the elements in a collection and displays them as String Expression: String.Join("|",CollVarName1) Output datatype: String
Switch activity
Consists of a conditional expression (not Boolean) and a collection of cases (at least 3) with corresponding activities
4 types of UI Automation activities
Containers (select specific app or browser, ex Open Browser, Attach Browser, Open App, Use App/Browser) Input (send input to an app interface, ex Click, Check, Type Into, Send Hotkeys) Output (get output from app interface, ex Get Text, Get Structured Data) Synchronization (control your process flow based on the states of UI elements)
Activity properties
Control how the Robot executes an activity. Here you can control if you want Robot to wait before or after executing activity, what elements to execute activity on, how long to wait, etc.
String Conversion Method
Converts 1st letter of every word in a string to uppercase and the following letters to lowercase. Argument is string to be converted, conversion settings StrConv(City,VbStrConv.ProperCase)
String.Format
Converts the strings ( and inserts them I to another text Expression: String.Format("{0} is {1}",VarName1,VarName2) Output datatype: String
Else If activity
Enables your project to have multiple different courses of action, depending on whether a series of specified conditions are met
Input & Output methods
Define how what technology is used when sending input or getting output from a UI
Properties
Determine how activities behave
The body of a loop is executed at least once when this activity is used.
Do While
UI elements Highlighted in yellow in Target Selection
Duplicates found, might need another anchor
What happens if you use a Write Range activity and try to write data in an .xlsx fiele that doesn't exist?
It will create the file for you and write data in it
Do While
Executes the activities in the body section and then checks the expression
The workflow contains a Get Text Activity and the scraping method is set to Full Text. While running the automation, the application is minimized. What's the outcome of the Get Text activity?
Extract the correct required text Works in the background, is an output method so available with Get Text, doesn't extract position
Substring string method
Extracts a substring from a string using the starting index and length Expression: VarName1.Substring(startindex,length)
UI Synchronization activities - help handle complex situations
Find Element; Element Exists; Wait Element Vanish; On Element Appear; On Element Vanish; Text Exists
Which activity would be your first choice to loop through all the rows of a data table?
For Each Row
How Parallel activity performs its execution
From top to bottom, left to right, ansynchronously
Output Methods
Full Text - default method; fastest, can extract hidden text, 100% accurate, can work in background Native - compatible w/ apps that use GDI; doesn't extract hidden text, cannot work in background OCR (optical character recognition) - only output method that works with virtual environments and with reading info from images; cannot work in the background, cannot extract hidden text, speed by far the slowest
String.Concat
Joins two or more strings, and returns a new joined strings Expression: String. Concat(Variable1,Variable2) Output datatype: String
3 Output Methods in modern
Full Text- default, fastest, 100% accurate, works in background, can extract hidden text, doesn't capture text positioning and formatting Native Text - used for GDI & Microsoft API, slower, accurate for supported apps, cannot work in background, cannot extract hidden text, can capture text position and formatting OCR (optical character recognition) - only that works with virtual environment & reading text from image, by far slowest, variable accuracy, cannot work in background, cannot extract hidden text, can capture text positioning
Objects
Fundamental building block in Visual Basics. A variable holds an object. Ex: if UserName="John Doe" then the UserName variable holds the "John Doe" string object
Input Methods
Hardware Events - clicking, typing, does not work in the background, attendee user cannot touch mouse or keyboard during SendWindowMessages - replays window messages that target app receives when mouse/keyboard used, works in the background Simulate - uses technology of target app, fastest targeting method, works in background ChromiumAPI - allows direct communication w/ browser, based in Devtools protocol, works in background, only in Modern
Define how what technology is used when sending input or getting output from a UI Element
Help store and share UI element targets
Recorders & Scraping Wizards
Help you develop UI much faster by following your manual interaction with a GUI step by step and translating into Sequence in studio activities Modern - App/Web and Computer Vision recorders available, Table Extraction Wizard Classic - Basic, Desktop, Web, Image, Native Citrix & Computer Vision recorders; Data Scraping & Screen Scraping wizards available
Pause in Target Selection
Helps to adjust required settings in the application while indicating the Target
Hoverable Selection in Target selection
Helps to indicate hoverable elements
Targeting methods
Identify the UI element to take an action on
Excel Application Scope activity
In Classic, it is in a container and all the other Excel activities have to be in the container. When execution ends, workbook and Excel app are closed. Each Excel file needs its own Excel Scope activity.
3 truths about Switch activity
In the Case input field, quotation marks not used to write strings Useful when need at least 3 potential sources of action Uses a condition that isn't Boolean
Factors that complicate a potential automation
Inputs that cannot be standardized Number of decisions points in the business logic Legacy applications
Target
Is a goal for an activity, like a button to click or a text box to click into. It is a UI element you want to interact with whilst building a UI automation. Like giving your street address
Lookup Data Table
Is similar to vLookup in Excel, as it allows searching for a provided value in a specified DataTable and returns the RowIndex at which it was found, or can be configured to return the value from a cell with given coordinates (RowIndex and Target Column).
Merge Data Table
Is used to append a specified DataTable to the current DataTable. The operation is more simple than the Join Data Type activity, as it has 4 predefined actions to perform over the missing schema.
Build Data Table activity
Is used to create a DataTable using a dedicated window. This activity allows the customization of number of columns & type of data for each column
For Each Row in Data Table Activity
Is used to perform a certain activity for each row of a DataTable (similar to ForEach)
List or List<T> methods of manipulation
Lists allow us to add, insert and remove items unlike Arrays. Types of manipulation: Adding & removing items Searching for an element Looping through items & performing on each Sorting the objects Extracting items & converting to other types
Variable properties
Name: defines how the variable will be identified, Type: defines what kind of data can be stored in the variable, Scope: defines what part of the workflow the variable can be used in, Default Value: defines the value the variable is initialized with.
What activity can you use to write a data table to a string variable?
Output Data Table
Argument use (variable cannot do)
Pass information from one workflow file to another in UiPath Studio, have direction of In, Out or In/Out
For Each
Performs series of activities in the body section in each element of a collection. Can step thru arrays, lists, data tables or other types of collections and process each piece of information individually.
What is data manipulation?
Process of modifying, structuring, formatting, or sorting data in order to facilitate its usage and increase its management capabilities.
Which activity can be used to read an entire sheet from an Excel file?
Read Range
Benefits of Chromium API over Hardware Events
Reliability - events sent directly to browser vs hardware events which communicates w/ mouse/keypad then sent to browser Works in the background - hardware events needs elements to be on screen, Chromium works while browser is minimized or other tab is focused
Replace string method
Replaces all the occurrences of a sub string in a string Expression: VarName.Replace("original","replaced") Output datatype: String
Send window messages input method
Replays the window messages that the app receives when the mouse/keyboard are used (in background)
LastIndexOf string method
Reports the zero based index position of the last occurrence of a specified character or string Expression: VarName1.LastIndexOf("author") Output datatype: Int32
IndexOf string method
Returns the zero based index of the first occurrence of a specified Unicode character or string within this instance. Expression: VarName1.IndexOf("a") Output datatype: Int32
Which targeting method does the Unified targeting methods use to identify the Required UI Element?
Selector, Fuzzy Selector & Image -it cycles through all of the available targeting methods
Key Targeting methods
Selectors, Fuzzy Selectors, Image, Native Text
Split string method
Splits a string into substrings using a given separator Expression: VarName.Split(","c)(index) Output datatype: Array of String
You are running a classic design experience at studio level. What path would you use to enable the modern experience for all new projects?
Step 1 - Access the Studio Backstage View Step 2 - Click Settings Step 3 - Click Design Step 4 - Enable Use Modern for New Projects
Variable type used for lists
System.Collections.Generic.List of Type
UI elements highlighted in red in Target Selection
Target element not identified
Activities
Tell the robot what actions to take
Anchor
The UI element referred to as a reference to identify your target. Like the landmarks to help find an address.
What happens when a Find Element activity does not find the desired element within the set Timeout property?
The activity throws an exception and stops the execution
Check App State Activity can be used outside the scope of Use App/Browser Card. T/F
True
A job is executed from the Orchestrator. What was the type of Robot used?
Unattended Robot
Chromium API activities
Use App/Browser, Click, Type Into, Hover and Keyboard Shortcuts. Browser automation input method in modern, 100% compatible with chromium based browsers like Chrome & Edge
What container do you need to add to be able to use Modern Excel Activities?
Use Excel File ( Classic is Excel Application Scope)
Break activity
Used to stop the segment of automation that is repetitive at a chosen point, can use with While, Do While and For Each
AI Computer Vision
Uses neural network to identify elements on screen
Image Selection Mode in Target Selection
Uses only Image as targeting method to identify the Ui element
Simulate input method
Uses the technology of the target app (the API level) to send instructions
DataTable variable
Variable that can store data as a simple spreadsheet with rows and columns. Each piece of data can be identified based on its unique column and row using the zero-based index. A memory representation of an Excel worksheet
Output Data Table
Writes a DataTable to a string using the CSV format.
Which actions get captured automatically by App/Web recorder?
YES - Clicking Action, Typing text, sending keyboard shortcuts using your keyboard NO - Copying text, hovering over an element, highlighting an element