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