For each loop actions

  • 5 minutes

Use the For Each action to go through a list or table of items. It's common to use this action in tasks that contain these structures.

To demonstrate this action, the following section expands on the previous flow. Assume that each employee sends multiple email messages. You need to sum up the expenses in these messages before writing them.

First, add a new variable to hold the sum of each employee’s expenses:

Screenshot of the workspace loop example.

At this point, the flow retrieves all the email messages for a specific employee. Add a For Each action to go through these messages:

Screenshot of the For each loop action properties dialog.

When you configure the action this way, %CurrentItem% holds a different email message in each repetition of the For Each loop.

Within the loop, add actions to convert the email text into a number and add it to the employee’s total:

Screenshot of the for each loop example workspace.

Finally, change the value you write into Excel to the Expense Sum variable (action 11).