Using For Each Excel Or CSV Row Step
  • Updated on 13 Jan 2015
  • 3 minutes to read
  • Print
  • Dark
    Light

Using For Each Excel Or CSV Row Step

  • Print
  • Dark
    Light

This tutorial demonstrates how to use For Each Excel Or CSV Row step. This step can be found inData > List > Excel and CSV category in the ToolBox .
Example:
In this example we are going to create a Flow that creates new Accounts using data from the Excel file. Also, this Flow will show a pop-up Notification for each Account that was created from the Excel file.

We begin in the Designer Folder with clicking Create Flow on theFolder Actions panel.
2018-03-30_102917-1.png

Next, we Name the Flow and click Create to proceed to the Flow Designer.
In the Flow Designer we need to create a Data that will hold our Excel File . We add Create Data step from Favorite Steps category in the Quick Add Step dialog*.*
2018-01-12_144603.png

In the resulting Data Definitions window we click Add New to define new Data .
2018-01-12_144730.png

Then, in the Add DataDefinitions window we Name our Data and select its Type FileData . Click Ok to save and close Add DataDefinitions window.
2018-01-12_144847.png

Next, we can pick an Excel file forCreate Data step. The Excel file for this example looks as following. It has 3 columns with First Name, Last Name, andEmail Address.

2016-12-15_141807.png

In the Flow Designer we select Create Data step on the workspace and Step Information Layer pops up. We use Choose File for the ExcelFile data in the Inputs section to pick our Excel File .
2018-01-12_145200.png

Next, we add For Each Excel Or CSV Row step from All Steps [Catalog] > Integration > Excel and CSV category in the Steps panel*.*
2018-01-12_145916.png

2018-01-12_150020-1.png

To configure Data for this step we select Edit Input Mapping from step’s Edit Pop Up.

2016-12-15_142322.png

2018-01-12_150333-1.png

In theMapping Editor we connect ExcelFile output from Create Data step to the File Input field. Then, we click Ok to save and close Mapping Editor.
2018-01-12_150439-1.png

2016-12-15_142540.png

Back in the Flow Designer we select For Each Excel Or CSV Row step on the workspace to pop up Step Information Layer . Then, in Input Data section from theInput File Type dropdown we select Excel_xlsx because our Excel File has**.xlsx** extension.
2018-01-12_150333-2.png

2016-12-15_142637.png

On the Next Row outcome from For Each Excel Or CSV Row step we add Create Account step from Integrations > All Integrations > Accounts category in the Quick Add Step dialog*.*
2018-01-12_151325.png

2016-12-15_142742.png

Then, we Edit Input Mappings for the Create Account step…
2018-01-12_151533.png

2016-12-15_142906.png

In the Mapping Editor we expand Current Row outcome from the For Each Excel Or CSV Row step. We connect Text Value from the Field03 to the emailAddress field, and Text Value from the Field01 to the password field. Then, we save and close Mapping Editor.
2018-01-12_151944.png

2016-12-15_143037.png

Back in the Flow Designer we add Show Popup step from Favorite Steps in the Steps panel to the Done outcome from Create Account step.
2018-01-12_152056.png

2016-12-15_143121.png

We call Mapping Editor for the Show Popup step to configure its Data .
2018-01-12_152828.png

2016-12-15_143155.png

In the Mapping Editor we use Constant text for the Subject field and Text Merge.Plain Mapping type for the Message field. Then, we click Show Editor for the Message field.
2018-01-12_153109.png

2016-12-15_143322.png

In the Merge Text Editor we use TextValues from Fields in the Current Row to reflect an information about currently added Account . When finished, we click Ok to save and close Text Merge Editor. Then, we can save and close Mapping Editor.
2018-01-12_153748.png

2016-12-15_143554.png

Back in the Flow Designer we connect steps in our Flow in the following manner, and click Debug Flow link to test the Flow .
2018-01-12_154222.png

Our flow executes in the Debugger with no errors and we can see Pop-up Notifications indicating that 3 new Accounts were added…
2018-01-12_155021.png

We close the Debugger and the Flow Designer. In the Portal we navigate to theSystem > Security > Accounts Folder , and confirm that four new Accounts were added to the Portal .

2016-12-15_144650.png

Was this article helpful?