Overview
The 'CSV - Parse' action parses the contents of a CSV file and returns it as JSON data.
Example Flow
Please refer to the following article showcasing the 'CSV - Parse' Power Automate action: Parse a CSV File and Add Content to a SharePoint List
Credit Count
This action consumes 1 credit per operation.
Note, different Encodian actions can consume different number credits. Please always check the action specific documentation and read What is an Encodian Action for a full description of how credits are consumed.
Default Parameters
The default 'CSV - Parse' flow action parameters are detailed below:
- File Content: A Base64 encoded representation of the CSV document
Advanced Parameters
The advanced 'CSV - Parse' flow action parameters are detailed below:
- Delimiter: Override the character used to delimit the CSV file. The default value is a comma. For a tab delimiter enter \t
- Column Headers: Optional - Manually override 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.
Return Parameters
The 'CSV - Parse' flow action returns the following data.
Action Specific Return Values
-
CSV Data - The contents of CSV file parsed as JSON.
Standard Return Values
- 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 been completed, has been queued or has failed
0 Comments