Skip to main content
Version: On-Premise 2.4

Create a Workflow to Loop Through a Table by Row

Actions Express stores and retrieves data using tables with pre-built activities to read and write to individual cells. This guide explains how to loop tables in your workflows.

Loop Through a Table by Row​

To use the loop through the table using a table of your creation (e.g., %tableName%):

  1. Create a new workflow.
  2. Add activity CreateMemoryTable.
    • In the Table Name field, enter your chosen name.
    • In the Columns and Rows fields, specify the number of columns and rows you need.
    • Add the column names.
    • Populate the table with data.
  3. Add activity GetRowsCount and name it.
    • In the Table Variable field, enter the table name.
note

NOTE: You must enter the table name as a variable with % % surrounding it.

  1. Add a While control and name it.
    • In the Counter field, add the name of the GetRowsCount activity you created in the previous step as a variable.
  2. Inside the While control, add two GetCellValue activities:
    • Use the first activity, GetCellValue, to pull the value from the column corresponding to the Loop Count.
      • In the Table Variable field, add the table name as a variable.
      • In the Row Number field, add the While control name as a variable.
      • In the Column Type field, select the type.
      • In the Column Number/Name field, enter the name of the first column.
    • Add the second GetCellValue activity to pull out the value from the column corresponding to the Loop Count.
      • In the Table Variable field, add the table name as a variable.
      • In the Row Number field, add the While control name as a variable.
      • In the Column Type field, select the type.
      • In the Column Number/Name field, enter the name of the second column.
  3. Save and run the workflow.