For each row in CSV file
Iterates over rows in a CSV file.
Properties
| Name | Type | Description |
|---|---|---|
| Title | ||
| File contents | Required | The contents of the file, provided as either a stream or a byte array. |
| Data start row | Optional | Specifies the index of the row where the data starts. If the file has a header row, the data start row is typically 2. If the files does not have a header row, the start row is usually 1. |
| Column mapping | Required | The mapping between the field indices and field data types in the file, and the columns in the final data set. |
| Data import options | Optional | Specifies options for error handling and how the contents of the file is parsed, such as date and number formattings. |
| Enable dynamic data import options | Optional | Indicates whether dynamic data import options should be used. |
| Dynamic data import options | Optional | A JSON object containing dynamic configuration for data import. |
| Field parser | Optional | Provides a way to customize how field values are parsed during import. |
| Row variable name | Optional | The name of the variable you can use to reference the Row in other actions. |
| Row data type | Read-only | |
| Description | Optional | Additional notes or comments about the action or configuration. |
Videos / Getting started
This section contains videos to help you get started quickly working with CSV files using Flow.
Dump CSV file from Azure Blob container to Azure SQL table
This video demonstrates how to import all records from a CSV file into an Azure SQL table.
In the demo, no data import options (such as data type conversion, number or date formatting) are specified, meaning the data is imported as raw text.