Collections

Collections are good for storing all sorts of lists. It is a special type of data item within Blue Prism that has the capacity to store multiple rows of data in a single table.

Typical types of lists that we may want the robot to work with include an entire Excel worksheet or a database table. As long as there are rows of data, the robot can be trained to read them and store the list in a collection.

Defining a collection

Earlier, in the Get List of items to purchase page, we created a blank collection named Output - List of Items to Purchase. It didn't contain any headers or rows. Let's proceed to define a table that looks as follows:

Item name

Low carb granola cereal

Cap'N Crunch breakfast...