The 'Parse CSV' action parses the contents of a CSV file and returns it as JSON data.
Please refer to the following article showcasing the 'Parse CSV' Power Automate action: Parse a CSV File and Add Content to a SharePoint List
The default 'Parse CSV' flow action parameters are detailed below:
- File Content: A Base64 encoded representation of the CSV document
The advanced 'Parse CSV' flow action parameters are detailed below:
- Delimiter: Override the character used to delimit the CSV file. The default value is a comma.
- Column Headers: Optional - Manually override and the columns headers for the CSV file as a comma separated string e.g. Col1, Col2, Col3. Column headers will be automatically determined if a value is not provided.
- Skip First Line: If 'Yes', the first line of data is pulled from the 2nd line.
The 'Parse CSV' flow action returns the following data.
Action Specific Return Values
- CSV Data - The contents of CSV file parsed as JSON.
Standard Return Values
- Filename - The filename provided
- FileContent - A base64 string representation of the archive (.zip) file
- OperationId - The unique ID assigned to this operation
- HttpStatusCode - The HTTP Status code for the response
- HttpStatusMessage - The HTTP Status message for the response
- Errors - An array of error messages should an error occur
- Operation Status - Indicates whether the operation has completed, has been queued or has failed