How to Read Csv File Using Power Automate?

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

6

1 Answer

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'])

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Maya Lin-Takahashi

Maya Lin-Takahashi

Consumer Tech & Gadget Reviewer

Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.

Share this article
Twitter Facebook Pinterest