UiPath Studio Web: A Beginnerâs Guide to Automation
10 Reasons Why UiPath Studio Web is a Game-Changer in Automation
Show Reasons
- UiPath Studio Web is an online tool that helps automate tasks on the internet, making work easier and more efficient.
- Itâs part of UiPath, a platform that mimics human actions on web applications.
- You can use UiPath Studio Web from any device, anywhere, since itâs based in the cloud.
- Itâs user-friendly and doesnât need any installation or setup.
- UiPath Studio Web can automate various tasks like customer service, accounting, order processing, employee onboarding, and web scraping.
- It works well with other tools like Microsoft 365, allowing smooth data transfer and synchronization.
- UiPath Studio Web uses features like Integration Service, Document Understanding, and Serverless Robots.
- It includes UiPath Autopilotâ˘, which uses AI to enhance productivity across the UiPath platform.
- UiPath Autopilot⢠for Assistant is an AI companion that helps with daily tasks, using both
Generative AI and Specialized AI securely. - UiPath Autopilot⢠for Assistant can discover and run existing automations, combining them for more complex tasks. If thereâs no pre-built automation, it can create new ones using AI on the spot.
Introduction
Start with UiPath Studio Web
Studio Web can be accessed via the Automation Cloud account or this direct link: studio.uipath.com. If you donât have an account, you can create it here.
Create a new project and assign an appropriate name for it.
Understanding development canvas
Data Manager
The Data Manager allows you to manage the data in an automation project. This data includes:
Variables - Store data and pass it between activities in a project.
Arguments - Store data and pass it into or out of a project.
Entities - Data stored in records from the UiPath Data Service, a centralized data modelling and storage service.
Connections - Links between your automation and external applications.
To access the Data Manager for a project, click the icon on the upper-right side of the page.
Run process
In the Design panel, click on the â+â icon to add a new sequence.
Click on the Run button in the Ribbon to execute your automation and check the Output panel for the message.
The use cases
1. Get the welcome message
View Solution
Solution:
- Create New project by providing the appropriate name and description
- We can perform this in two ways
- By using Log Message activity
- By using Write Line activity
- Create New project and search for desired activity
- In the Design panel, click on the + icon to add a new sequence
Solution 1:
Create A new project
Name *: welcome using Log
Description -
How to start the automation: Manually
Click create
click on the â+â below trigger
Search and Select Log Message activity
Message: âWelcome to vajrang.orgâ
Log level: select Info
Run Project
Verify message in output panel
Solution2:
Create A new project
Name *: welcome using WriteLine
Description -
How to start the automation: Manually
Click create
click on the â+â below trigger
Search and select WriteLine activity
Add Write Line activity
ext: âVajrang.org is now trending in automationâ
Run Project
Verify the message in output panel
2. How to Use WriteLine Activity in Studio Web
View Solution
- Create A new project
Name *: welcome using WriteLine
Description - How to start the automation: Manually
Click create - click on the â+â below trigger
- Search and select WriteLine activity
- Add Write Line activity
Text: âVajrang.org is now trending in automationâ - Run Project
- Verify the message in output panel
3. How to start Math Operations on two Numbers Using Studio Web (Addition, Subtraction, and multiplication)
View Solution
Create A new project
Name *: Perform Math Operations on two Numbers (Addition Subtraction and multiplication)
Description - How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
Add first variable
Select Set variable value activity to assign first value
Set value: 10 (give any integer number)
To variable: create variable of type integer (Ex: First Number)
Click on save as variable
Step2:
Add second variable
Select Set variable value activity to assign second value
Set value: 15 (give any integer number)
To variable: create variable of type integer (Ex: SecondNumber)
Step3: For Math operation
Select Set variable value activity to add logic to perform Math operations
Set value: Open expression Editor and provide the logic
(Ex:FirstNumer + SecondNumber)
To variable: create variable of type integer to store the result (Ex: Result)
Step4:
Log the result
Select Log message activity
Message: Provide the Result variable.
Log Level: Info
Step5:
Run the Project
Verify the output in the output panel.
4. How can you utilize or explore the features for managing date and time effectively within UiPath Studio Web?
View Solution
Create A new project
Add details to the project
Name *: DateTime
Description - How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
Select Set Variable Value activity
Set value: Open expression Editor and provide the logic (datetime.Now)
To variable: Create variable of type Date to store the current Date and Time (Ex: CurrentDateTime)
Step2:
Select Log message activity
Message: Select CurrentDateTime variable to display the current Date-Time
Log Level: Info
Step3:
Run the Project
Verify the output in the output panel.
5. Find the Leap year and display the message along with the Boolean conditions?
View Solution
Create A new project
Add details to the project
Name *: Check for Leap year
Description - Find the Leap year and display the message along with the Boolean conditions.
How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
Select Set Variable Value activity to store the Year
Set value: Enter any year (Ex: 2004)
To variable: Create variable of type integer (Ex: Year)
Step2:
If Condition to check whether the given year is Leap or Non-Leap
Select If activity
Condition: Provide the following condition for Leap
((Year mod 4 = 0 And Not (Year mod 100 = 0)) Or (Year mod 400 = 0))
Then :
Add Set Variable Value activity to set Boolean Value
Set Value: True
To variable: Create a variable to set Boolean Value as True (Ex:boolVal)
Add Log Message activity to Log a Leap Year
Message: Enter âboolValâ variable: âYearâ Variable and add âis a Leap Yearâ
Log Level: Info
Else
Add Set Variable Value activity to set Boolean Value
Set value: False
To variable: Provide boolVal variable
Add Log Message activity to Log a Leap Year
Message: Enter boolVal variable: Year Variable is Non-Leap Year
Log Level: Info
Step3:
Run the Project
Verify the output in the output panel.
6. How do you add two different variable types and perform the addition operation within a final variable using the Generic Variable type?
About GenericValue variable
- GenericValue variable is a type of variable that can store any kind of data, including text, numbers, dates, and arrays. This type is mainly used in activities in which we arenât sure what type of data weâll receive.
- GenericValue variables are automatically converted to other types, to perform certain actions.
- Please note that the first element in your expression is used as a guideline for what operation
Studio performs.
How GenericValue variable work?
When you try to add two GenericValue variables, if the first one in the expression is defined as a String, the result is the concatenation of the two.
Ex: Var1=â10â and Var2=6 (Both are of type GenericValue)
Var1+Var2=106 (Concatenates 10 and 6 and gives 106)
If it is defined as an Integer, the result is their sum.
Ex: Var1=9 and Var2=â3â (Both are of type GenericValue)
Var1+Var2=12 (Sumâs 9 and 3 and gives 12)
View Solution
Create New project
Add details to the project
Name *: Task on Generic Value
Description - Add two different Variable types and do the Add in final variable
How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
- Create a GenericValue variable with default Integer value (Ex: GenericNumber)
Step2: - Create a GenericValue variable with default String value (Ex: GenericText)
Step3: - Create a GenericValue variable to store the Result (Ex: GenericResult)
Step4:
When the First Element in the Expression is String
Add Set Variable Value to get Generic Result
Set value: GenericText+GenericNumber
To variable: Pass GenericResult variable
Step5:
Add Log Message to output the result
Message: Supply GenericResult variable
Log Level: info
Step6:
When the First Element in the Expression is Integer
Add Set Variable Value to get Generic Result
Set value: GenericNumber+GenericText
To variable: Pass GenericResult variable
Step7:
Add Log Message to output the result
Message: Supply GenericResult variable
Log Level: info
Step8:
Run the Project
Verify the output in the output panel.
8. How can you assign multiple values (numbers) and then display them through their respective indices?
View Solution
Create a new project
Add details to the project
Name *: Display Number Through Index
Description - How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
Add Set Variable Value activity
Set value: Configure the âSet Valueâ field with the desired numbers enclosed in curly braces and separated by commas. For instance: {9,6,12,3,15,21}.
To variable: Create a variable of the type âarray of numbersâ to hold the assigned numbers. (Ex:
arr_Num)
Step2:
Add Log Message activity
Message: Insert an expression that references the desired index of the array. For example, to display the value at index 3: âarr_Num(3)â.
Log Level: Set it to âInfoâ.
Step3:
Run the Project
Verify the output in the output panel.
9. How do you assign multiple values (names) and subsequently display these values using their respective indices?
View Solution
Create a new project
Add details to the project
Name *: Display Name Through Index
Description - How to start the automation: Manually
Click create
click on the â+â below trigger
2. Step1:
- Begin by adding a âSet Variable Valueâ activity
- Set value: Configure the âSet Valueâ field with the desired names enclosed in curly braces and separated by commas. For instance: {âVajrangâ, âSurabhiâ, âParvathiâ, âNarenderâ, âKrishnaâ, âSwathiâ}.
To variable: Create a variable of the type âArray of Textâ to hold the assigned names. (Ex: arr_Names)
Step2:
Add Log Message activity
Message: Insert an expression that references the desired index of the array. For example, to display the value at index 0: âarr_Num(0)â.
Log Level: Set it to âInfoâ
Step3:
Run the Project
Verify the output in the output panel.
10. How can you read the values stored in an array and then write them into a text file using the respective index values?
Before proceeding to process create a Text File and upload that in Storage Bucket in Orchestrator.
Solution:
View Solution
Create New project
Add details to the project
Name *: Write Data into Text File Through Indexes
Description - Read the values in Array and write into text file through the index values
How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
Add Set Variable Value
Set value: Configure the âSet Valueâ field with the desired fruit names enclosed in curly braces and separated by commas. For instance: {âVajrangâ,âSurabhiâ,âSushmaâ,âParvathiâ,âNarenderâ,âKrishnaâ, âSwathiâ}
To variable: Create a variable of the type âArray of Textâ to hold the assigned names. (Ex: arr_TeamData)
Step2:
Add Write Storage Text
Orchestrator Folder Path: Provide the Folder Path in which text file is available (Ex: Shared)
Storage Bucket Name: Provide the appropriate Storage Bucket Name (Ex: TextFiles)
File Path: Provide the Name of the Text File to write data into (Ex: Team.txt)
Text: Provide the following to write the values to the text file through indexes
arr_TeamData(0).ToString+Environment.NewLine+arr_TeamData(1).ToString+Environment.NewLine+
arr_TeamData(2).ToString+Environment.NewLine+arr_TeamData(3).ToString+Environment.NewLine+
arr_TeamData(4).ToString+Environment.NewLine+arr_TeamData(5).ToString+Environment.NewLine+
arr_TeamData(6).ToString)
Step3:
Run the Project
Verify the output in the output panel.
Check the Text File for data availability
11. How can you incorporate a selection of weekdays, sequences, debugging workflow techniques, and control flow statements into your UiPath Studio web project?
View Solution
Create a new project
Add details to the project
Name *: Switch Activity on Weekdays
Description - How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
Add âSet Variable Valueâ activity
Set value: Provide any case value to go to the switch statement, such as âMondayâ.
To variable: Create a variable named âWeekDayâ of type String to hold the switch case value.
Step2:
Add a âSwitchâ activity
Click the + icon to add child cases to the switch.
Provide a name for each child case and click âAdd Child.â For example, Monday, Tuesday, Wednesday,
and so on, corresponding to the weekdays.
Step3:
Add Log Message in Each Child
Inside each child case, add a âLog Messageâ activity.
Configure each activity as follows:
Message: Provide an appropriate Message for the specific day
(Ex: âTerrific Tuesday! Keep up the good work.â)
Log Level: Set it to âInfoâ
Step4:
Run the Project
Verify the output in the output panel.
12. How do you find the maximum and minimum values from a list of array of numbers?
View Solution
Create a new project
Add details to the project
Name *: Min and Max of Array
Description - Find Max and Min value from list of Array of Numbers
How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
Add Set Variable Value activity to assign array of integers
Set value: enter integer values ex: {5,60,2,10,100,1000,45}
To variable: create variable (ex: arr_intVal)
Step2:
Add Set variable value activity for Min of Array Values
Set value: int_values.min
To variable: create variable (ex: MinArrayVal)
Step3:
Add Set variable value activity for Max of Array Values
Set value: int_values.Max
To variable: create variable (ex: MaxArrayVal)
Step4:
Add Log message activity to display minimum of array values
Message: enter the variable name (ex: MinArrayVal) to display minimum value
(Click on + icon, Select Text builder, type required message and click on Insert variable and select the
required variable. (Ex: Minimum Array Value is MinArrayVal)
Log level: select the log level (Ex: Info)
Step5:
Add Log message activity to display maximum of array values
Message: enter the variable name (ex: MaxArrayVal) to display maximum value
Click on + icon, Select Text builder, type required message and click on Insert variable and select the
required variable. (Ex: Maximum Array Value is MaxArrayVal)
Log level: select the log level Ex: Info)
tep6:
Run the Project
Verify the output in the output panel.
13. How would you create a Google Spreadsheet and assign a specific name to the sheet being created?
View Solution
Create a new project
Add details to the project
Name *: Create_Spreadsheet
Description â Create the spread sheet and give sheet name
How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
Add Create Spreadsheet activity
Google Drive: Provide the email Id (ex: testtoday@gmail.om)
Folder: Select the Folder in which You want to create (Ex: My drive
Spreadsheet name: write the spread Name (If you do not give any name by default it will create as sheet1)
Step 2: Task
Write your name in A1 of the sheet created
14. Combine first, middle, and last names from an Excel sheet into a Full Name column using Excel and Data Tables Activities, with workflow debugging. Provide examples
Before proceeding to process integrate to Google workspace and Google Spreadsheet
View Solution
Create a new project
Add details to the project
Name *: Add Full Name to Excel
Description - Extract the data from Names Excel and print the results in the Excel
How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
Add Read Range activity to read the Spread Sheet with name information (I.e., First Name, Middle
Name, Last Name) that is available in Google Workspace (Ex: Google Drive)
Google Sheet: Select the domain which contains sheet (Ex:connection@gmail.com)
Spreadsheet: Select sheet which contains information (Ex: Test)
Range: Enter Sheet name (ex: Sheet1)
Has Headers: select true
Select Show additional options
Read range: Utilize the default variable provided by the activity or create a variable with an
appropriate naming convention to store the retrieved data (Ex: dt_readData)
Step2:
Click on the + icon to add For Each Row in Data Table
Data Table: Provide the output variable of the Read Range activity I.e., dt_readUserData.
Item: CurrentRow (Default, you can modify the name)
Click on Show additional options
Index: Create a variable to store the index value (Ex: CellId)
Step3:
Add Set Variable Value to concatenate First, Middle and Last Name
Set value: CurrentRow(âFirst Nameâ).ToString+" â+ CurrentRow(âMiddle Nameâ).ToString+â
"+CurrentRow(âLast Nameâ).ToString
To variable: Create a variable to store the result (Ex: FullName)
Step4:
Add Set Variable Value to get the position value
Set value: CellId+2
To variable: Pass CellId variable
Step5:
Add Write Cell activity to store FullName in the Full Name Column of Spread Sheet
Google Sheet: Select the domain which contains sheet (Ex: connection@gmail.com)
Spreadsheet: Select sheet which contains information (Ex: Test)
Sheet/Named range: Enter sheet name (Ex: Sheet1)
Cell: Select column and add CellId variable to it (Ex: âDâ+CellId.ToString)
What to write: Provide the âFullNameâ variable.
Step6:
Run the Project
Verify the output in the output panel.
Check the Excel for Data availability
15. How can you create a data table and transfer its contents to a spreadsheet using Data Tables Activities? Include examples and debugging the workflow as part of the process?
The âBuild Data Tableâ activity is unavailable in Studio Web. Here is an alternative process to
achieve the desired output without using the âBuild Data Tableâ activity.
View Solution
Create a new project
Add details to the project
Name *: Build and Write Data to Spreadsheet
Description - This automation aims to build a data table for student information and write it to a
spreadsheet.
How to start the automation: Manually
Click create
click on the â+â below trigger
Step1:
Begin by creating a DataTable variable to store student data. Letâs call it dt_StudentData.
Step2:
Use the âAdd Data Columnâ activity to create a new column, which will be referred to as Column1, to our Data Table.
Cloumn Name: Assign a header to Column1, for example, âStudentIdâ.
To Data Table: Specify the DataTable variable, which in our case is dt_StudentData.
Step3:
Extend the Data Table by using the âAdd Data Columnâ activity to introduce another column, referred to as Column2.
Cloumn Name: Assign a header to Column2, for example, "StudentNameâ.
Data Table: Specify the DataTable variable, which in our case is dt_StudentData.
Step4:
Continuing with the Data Table setup, employ the âAdd Data Columnâ activity to include another column known as Column3.
Cloumn Name: Assign a header to Column3, for example, "Classâ To Data Table: Specify the DataTable variable, which in our case is dt_StudentData.
Step5:
Now, utilize the âAdd Data Rowâ activity to insert data into the first row, representing Student1.
Data Table: Specify the Data Table variable, âdt_StudentDataâ.
Array Row: Click on + and select Collection builder
In the Collection Builder panel, click âAddâ and provide data for all columns. Repeat this step for each column value.
Step6:
Continue by using the âAdd Data Rowâ activity to add data to the second row, representing Student2.
Data Table: Specify the Data Table variable, âdt_StudentDataâ.
Array Row: Click on + and select Collection builder
In the Collection Builder panel, click âAddâ and provide data for all columns. Repeat this process for each column value.
Step7:
Proceed with the âAdd Data Rowâ activity to add data to the third row, representing Student3.
Data Table: Specify the DataTable variable, âdt_StudentDataâ.
Array Row: Click on + and select Collection builder
In the Collection Builder panel, click âAddâ and provide data for all columns. Repeat this procedure for each column value.
Step8:
Proceed with the âAdd Data Rowâ activity to add data to the fourth row, representing Student4.
Data Table: Specify the DataTable variable, which in our case is dt_StudentData.
Array Row: Click on + and select Collection builder
In Collection builder panel click on Add and data for all Columns. Click on Add for every column
value.
Step9:
Lastly, use the âAdd Write Range (Google Workspace)â activity to write the data from the Data Table into the spreadsheet (Ex: StudentData) available in your Google Drive
Google sheets: select workspace (ex: Yourmail@gmail.com)
Spreadsheet: Choose the Google Spreadsheet available in your Google Drive.
Range: specify the sheet (Ex: sheet1)
What to write: Specify the DataTable variable, which in our case is dt_StudentData.
Step10:
Run the Project
Verify the output in the output panel.
verify the spreadsheet to confirm the presence of data.
Coauthors: @Narender_Kalal @surabhi_uma