CODEWITHSUNDEEP
csvsharepointpower-automatepower-platformdocument-library
user20404265
user20404265

Reputation:

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.

enter image description here

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

Can anyone help me for the same?

Thanks

Upvotes: 0

Views: 34548

Answers (1)

Expiscornovus
Expiscornovus

Reputation: 1497

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

enter image description here

Upvotes: 4

Related Questions