How to Read CSV file using Power Automate?

(0) Share

Report

Posted on by BhoomeshJoshi

I have added a CSV file to the SharePoint Documents library.

I need to read that CSV file using Power Automate / Flow. without using any third-party actions.

I need to store particular column data to array from CSV and add that array data to the SharePoint list.

Can anyone help me with the same?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

fchopo 8,003 Moderator on at

Like (0)

Report

Hi @BhoomeshJoshi

There are no standard connectors to parse CSV files. Therefore you can try to parse the file manually. Have a look at this excellent post by @Paulie78 : Power Automate: How to parse a CSV File to create a JSON array (tachytelic.net)

Instead of creating a JSON array, you could add a new item into the SharePoint list.

Hope that helps!
Ferran

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report

EDIT : answered to the wrong topic... deleted my answer.

Was this reply helpful? Yes No
piotrostr 30 on at

Like (6)

Report

is there anything in this service which works without applying workarounds?
id assume paying for premium should be fine, or it needs some additional googling to find out how to make it happen?

This is ridiculous. Complete rubbish.
How can you not support csv. how this product can be used if you just look for workarounds for the simplest tasks

Was this reply helpful? Yes No
Sticks22 5 on at

Like (0)

Report

There has been CSV table support for a while. Not sure how long but here is a link to the docs.
https://learn.microsoft.com/en-us/power-automate/data-operations#use-the-create-csv-table-action

Was this reply helpful? Yes No
Sticks22 5 on at

Like (0)

Report

Opps I just read that a bit better, that's only data to make CSV not read CSV in... Bummer.

Was this reply helpful? Yes No
fuo 11 on at

Like (0)

Report

Yes. The entire "Power" Platform is garbage.

3 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Akhil Mehra 2 on at

Like (0)

Report

After "Get file content" (SharePoint), then:

1. Convert CSV to an Array: Use split(replace(outputs('Get_file_content'), '\r\n', '\n'), '\n') to separate rows.
2. Extract Headers: Use first(outputs('Compose')) to get column names.
3. Extract Data Rows: Use skip(outputs('Compose'), 1) to remove headers.
4. Filter Required Column Data: Use "Select" action with split(item(), ',')[ColumnIndex] (replace ColumnIndex with the actual position).
5. Loop Through Extracted Data: Use "Apply to each" to iterate over values.
6. Store Data in SharePoint List: Use "Create item" to save each extracted value in the list.

1 people found this reply helpful.

Was this reply helpful? Yes No