How to Read CSV file using Power Automate?

Like (0) Share

Report

Posted on 13 Dec 2022 12:35:36 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

All responses (7)

Answers (0)

Suggested answer

Akhil Mehra 2 on 05 Feb 2025 at 06:54:21

Like (0)

Report

How to Read CSV file using Power Automate?

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.
fuo 11 on 21 Jun 2024 at 16:58:44

Like (0)

Report

Re: How to Read CSV file using Power Automate?

Yes. The entire "Power" Platform is garbage.
Sticks22 5 on 28 Nov 2023 at 16:34:52

Like (0)

Report

Re: How to Read CSV file using Power Automate?

Opps I just read that a bit better, that's only data to make CSV not read CSV in... Bummer.
Sticks22 5 on 28 Nov 2023 at 16:28:55

Like (0)

Report

Re: How to Read CSV file using Power Automate?

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
piotrostr 30 on 06 Sep 2023 at 07:47:38

Like (6)

Report

Re: How to Read CSV file using Power Automate?

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
SamLed 2,332 Moderator on 03 Aug 2023 at 10:15:07

Like (0)

Report

Re: How to Read CSV file using Power Automate?

EDIT : answered to the wrong topic... deleted my answer.
fchopo 7,968 Super User 2025 Season 1 on 13 Dec 2022 at 15:05:00

Like (0)

Report

Re: How to Read CSV file using Power Automate?

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

Community site session details

How to Read CSV file using Power Automate?

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

How to Read CSV file using Power Automate?

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates