CSV To List Mapping Step

Overview

Data can be converted from a CSV file to a list of strings using the CSV To List Mapping step.

Example

The following example will take a CSV file and convert the data to a list of strings to display on a Form.

1. From a Designer Project, click CREATE FLOW on the Global Action Bar; select Flow, provide a Name, then click CREATE. 
2. From the Flow Designer, attach a Create Data step from the FAVORITE STEPS category of the Toolbox panel, to the Start step. On the Properties panel, click SHOW EDITOR.
3. From the Data Definitions window, enter "File" under NAME and select FileData from the TYPE dropdown. Click the pencil icon under INPUT and Constant map the CSV file by selecting CHOOSE FILE. Click Save and close the Data Definition window. 

   

4. From the DATA > EXCEL & CSV category of the Toolbox, attach a CSV To List Mapping step to the Create Data step. 
5. From the Properties panel, click Unknown next to the Input File field and select the Pencil icon to Select From Flow. Select File and click DONE. For the Output Type field, select String. For the Input File Type dropdown, select CSV. Click Show Item Mapping Editor.
   
6. From the Mapping Editor, set the mapping ITEM to Merge Text, then click the Pencil icon to Show Editor. 
   
7. In the Text Editor, configure the message to read "First Name: [_INPUT.Field01.TextValue] Last Name: [_INPUT.Field02.TextValue] Email Address [_INPUT.Field03.TextValue]" by selecting the plus sign icon under the fields under _INPUT category from under DATA. Click SAVE and then OK.
   
8. Back in the Flow Designer, attach a Show Form step from the FAVORITE STEPS category to the CSV To List Mapping step. From the Show Form step's Properties, click PICK OR CREATE FORM. then CREATE a new Form.
9. From the Form Designer, design a Form using a List Box component from the DATA category of the Toolbox, and a "Done" Button. 
10. Select the List Box on the Form to navigate to its Properties; provide a List Items Data Name, select String [Text] from the Type dropdown, then select SingleSelect from the Output Type menu. Save and close the Form.
    
11. From the Flow Designer, connect the Show Form step to the End step. On the Properties panel, map OUTPUTS to List and set List Display to Ignore.
12. Save the Flow, then if desired close the Flow Designer.

Debug

1. Click Debug from the top action bar. 
2. Click START DEBUGGING. 
   When the Flow runs, the Form will open and display the data from the file according to how it was mapped via the CSV To List Mapping step.