Parse CSV

Overview

The 'Parse CSV' action parses the contents of a CSV file and returns it as JSON data.

Example Flow

Please refer to the following article showcasing the 'Parse CSV' Power Automate action: Parse a CSV File and Add Content to a SharePoint List

Default Parameters

The default 'Parse CSV' flow action parameters are detailed below:

  • File Content: A Base64 encoded representation of the CSV document

mceclip0.png

Advanced Parameters

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: Manually set the columns headers for the CSV file as a comma separated string e.g. Col1, Col2, Col3.
  • Skip First Line: If 'Yes', the first line of data is pulled from the 2nd line.

mceclip1.png

Return Parameters

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

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk