/
3.07 For Each Action Configuration

3.07 For Each Action Configuration

Jun 17, 2024

What is a For Each Action?

The 

 action iterates over a set of records or list of values, and generates an output record for each one. It is most commonly used to split data, such as an array, into individual records, or it can be used in conjunction with a 
 action to firstly convert a user-inputted list into an array for the 
 action to process - see worked example below.   

Creating For Each Actions

  1. Click and drag the 

     icon from the toolbar onto the canvas

  2. Enter a name in the Create For Each Action window and select Create Action

  3. In the 

     action 
     on the right, populate the following:

Field

Description

Example Value

Field

Description

Example Value

Input Expression

The input expression provides the source of the data to be iterated over. Typically, this will be a simple expression pointing at an Input Attribute, using the syntax, Connector.AttributeName.

If an empty record set or empty list is provided then no output will be generated.

This field is mandatory (PhixFlow version 11.1 +).

// Receives a list of Invoice IDs, these are iterated over using

in.InvoiceID     

Input Attributes

Attributes mapped into the For Each action will appear here. 

If adding a new input attribute, a Name and Type are required. See Understanding Data Types.



Output Attributes

Attributes mapped out of the For Each action will appear here.

If adding a new output attribute, a Name, Type and Expression are required. This is a PhixScript expression. Values returned by the Input Expression are available in this expression as:

_result.value

To work in a larger popup window, click 

.

See also:

Name: Invoices

Type: String 

Expression: _result.value

Worked Example

Here's a worked example using the Company Data (available from the Learning Centre).

In this example, we are using:  

  • A Company For Each Example screen containing:

    • an multi-line string field and Save button that will be used by the user to enter a list 

    • a string field that will be used to create a filter

    • a grid backed by the ForEachExample table - this screen was created using the Multi-Tile  template

If you are completing this chapter as part of the Actionflow course and using a training instance, the data and screens have already been pre-loaded into the Actionflow Advanced Application. For this example, we'll be working on the Company For Each Example screen.

Split a List Into Individual Records

In this example, we need a quick way to input a stock delivery into our application that can be processed later. We'll take a list of values inputted by a user and convert these into individual records.

Actionflow Setup

  1. Open the Company For Each Example screen

  2. Add an

     to the Save button

    1. Name: SplitIntoRecords

  3. Configure the Input as the CompanyForEachExample form

  4. Map the attribute Text into the Actionflow

Calculate Action - Convert List to Array

Use the split function in a 

 action to split the Text attribute by the comma separator. This will convert the list entered by the user into an array.

  1. Create a 

     action

  2. Connect the 

     to the Calculate action

    1. Map across the Text attribute

  3. In the Calculate action, create an Output Attribute:

    1. Name: Split

    2. Type: Structured Data

    3. Expression: split(in.Text,",")

Calculate Action - Create Session ID (Optional)

Create a SessionID attribute in a 

 action to allow identification of records created at the same time by the same user, which we will use for filtering.

  1. In the Calculate action, create another Output Attribute:

    1. Name: SessionID

    2. Type: String

    3. Expression: now() + _user.username

For Each Action - Convert Array to Records

Use a 

 action to convert the array into individual records.

  1. Create a 

     action 

    1. Name: Convert to Records

  2. Connect it to the Calculate action and map across the Split attribute

  3. On the For Each action, enter the following:

    1. Input Expression: in.Split

    2. Input Attributes: Split

    3. Create two Output Attributes: 

      1. Name: Name

        1. Type: String

        2. Expression: trim(_result.value)

          1. The trim function is used here to remove the whitespace after the comma separator in the list

          2. If this was not used and the list "one, two, three" was entered, the records "two" and "three" would be saved with prefixed whitespace

      2. Name: LastUpdated

        1. Type: Datetime

        2. Expression: now()