Class 7

Mini-Cases in Automation: Part 1

Monday, April 20, 2026

Class Overview

Why is this important?

The cases in this class are end-to-end examples that collect, join and loop through data, these are some of the most fundamental steps in any RPA solution.

What will we do?

This class is set around two mini-cases that work with loops to automate the processing of spreadsheet data. The first covers data retrieval from a web source and filters the data to a spreadsheet output. The second case joins two spreadsheet sources together using a loop.

How this relates to other classes:

In the last class, we discussed design principles for automation workflows and covered concepts relating to the level of autonomy in a process, the role of agents versus RPA bots and humans-in-the-loop. In this class we will work through two cases that apply some of these design principles and concepts, but focus on the implementation of loops to process data.

This class extends the discussion by working directly with cases that require loops to process data. All of the steps in these example cases are deterministic, and do not require the use of an agent.

Materials and Preparation

Class Materials
  • Link: Download the UiPath Cloud Starter File for the Conditional Loops Case.
  • Link: Download the UiPath Cloud Starter Files for the Example Join Case (as a zip file).
  • Slides: PowerPoint or PDF
  • Automation Tools: UiPath Studio Web, For Each, If/Else statements
  • Automated Tasks: Spreadsheets, DataTables
  • Suggested Pre-Class Preparation
    There is no suggested preparation for this class.
  • Class Plan
    1. After a brief review, we will work on the first case. This case will gather data from a web table on wikipedia, filter it, clean it up and output a spreadsheet with numerical values. Finally, in this case, we will work through adding some calculations.
    2. The second case will join two spreadsheets together using a loop. This is a common task in many RPA solutions, and is often done using a loop to compare values across two spreadsheets and output a joined spreadsheet based on the results of the loop.
    3. We will work through some sections as a class and some independently.