Repeat

Using the Repeat Control

1. In your automation, on the right-hand side panel, go to the Controls section.

   

2. Drag and drop Repeat in the workflow of your automation.

3. Select Repeat. The Repeat side panel appears.

   

   The Repeat control has the following parameters:

   • Starting value: Set a starting number where the iteration starts.

   • Ending value: Set an ending number where the iteration stops.

   • index: A number that starts at the set starting value, and increases by one with every loop until it reaches the set ending value.

4. Optional: Add an output parameter to the repeat control.

   

   1. Enter a name.(1)

   2. Set a value for the output parameter.(2)

5. Save your automation.

Use Case Example

The following use case demonstrates the use of the repeat control by setting values in an Excel file.

Prerequisite

You have created the automation My automation.

Procedure

1. In your automation, on the right-hand side panel, go to the Activities section.

2. Drag and drop the activity Open Excel Instance.

3. Drag and drop the activity Open Workbook.

   Write the path of your Excel file in the input parameters.

   

4. Drag and drop the Repeat control in your workflow.

   

5. Select Repeat. On the side panel, enter the starting and ending values in the parameters.

   

6. Drag and drop the activity Set Values on the repeat branch.

   

7. Select Set Values. In the input parameters of the activity:

   1. Click the  button to set the rangeDefinition.

      

   2. Enter the value Hello.

   

   With these input parameters, the automation sets the value Hello in a new cell with each iteration of the loop.

8. Drag and drop the activity Save Workbook.

9. Drag and drop the activity Close Excel Instance.

10. Save and test your automation.

Result

The value Hello is entered on the Excel worksheet in cells A2 to A5.