- Getting started
- Administration
- Designing automations
- Creating an automation from an idea
- Creating a project
- How to start an automation
- Managing project files and folders
- Connecting automations to your accounts
- Configuring activities
- Managing the activities in a project
- Passing values between activities
- Iterating through items
- Managing the data in a project
- Configuring a project to use your data
- Using file and folder resources
- Using UI Automation for browser interactions
- Running and testing your projects
- Managing automations
- Studio Web API
Iterating through items
Iterating refers to repeating one or more activities in your automation project for each individual item in a collection of items. To iterate through items, add one of the available For Each activities in which you define the collection, and then add the activities to repeat inside the For Each. When you configure the activities to repeat, indicate that an activity should use data from each item in the iteration by using a variable and selecting the current item option for the For Each activity from the variable selector.
A generic For Each activity is available in the Control category, and various For Each activities are available for specific types of data. For example:
-
For Each Email (Microsoft 365 and Google Workspace) - Repeat one or more activities for each message in an email folder. The current item option is
CurrentEmail. -
For Each File/Folder - Repeat one or more activities for each file or folder in a OneDrive or SharePoint folder. The current item option is
CurrentItem. -
For Each Row in Workbook and For Each Row in Spreadsheet- Repeat one or more activities for each row in an Excel workbook and Google Spreadsheet respectively. The current item option is
CurrentRow. -
For Each Sheet in Workbook and For Each Sheet in Spreadsheet - Repeat one or more activities for each sheet in an Excel workbook and Google Spreadsheet respectively. The current item option is
CurrentItem.
