How to Read CSV file using Power Automate?

Question

I have added CSV file to SharePoint Documents library.

I needs to read that CSV file using Power Automate / Flow.

I have created Power Automate flow. Below is the screenshot fro the same.

Which CSV parser do i need to use for read data from file content action?

Can anyone help me for the same?

Thanks

Answer 1

If you want to retrieve the content of the CSV without a premium connector you could use an expression to convert the $content property of the Get File Content action into a string value. You can use the base64tostring function for this.

Below is an example

base64tostring(outputs('Get_file_content')?['body']['$content'])