Answered

Daily extract of content of csv to SharePoint list

(0) Share

Report

Posted on by AndrejZitnay

Hello all,

I am quite new to Power Automate.

I have little trouble to solve my current task. I've looked into google, YouTube, this community page but I couldn't find right solution.

I have share Point folder where I receive every day CSV file via API transfer.
In format "Name of report_YYYY-MM-DD.csv"
Headers are always the same but content might differ. Sometimes it might be empty. (Just headers)

In this example I have there just 5 columns.

In real life I have there around 30 columns and few hundreds of rows.

My aim is to extract content of csv's my new SharePoint list.

I have in my folder few hundred's of csv's and I get every day new file.

Would you be so kind and try to help on my basic example?

Many thanks.

Andrej

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AndrejZitnay
According to your description, you want to parse a csv file and add the content to a SharePoint List.
I created a flow based on the information you provided . You can take a try with the following steps to see if it helps.
This is my test csv file.
Flow in details:
Get today's date
Then save and run the flow. After that copy the CSV Data from Parse CSV action.
Next step: Edit the flow and add Parse JSON action.
Click ‘Generate from sample’ and paste the JSON schema copied from ‘Parse CSV’ action in it.
Then save and test the flow.
After flow runs,the csv file content will be add into sharepoint list.
For more info you can refer to:
https://www.encodian.com/blog/parse-a-csv-file-and-add-content-to-a-sharepoint-list/
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AndrejZitnay
According to your description, you want to parse a csv file and add the content to a SharePoint List.
I created a flow based on the information you provided . You can take a try with the following steps to see if it helps.
This is my test csv file.
Flow in details:
Get today's date
Then save and run the flow. After that copy the CSV Data from Parse CSV action.
Next step: Edit the flow and add Parse JSON action.
Click ‘Generate from sample’ and paste the JSON schema copied from ‘Parse CSV’ action in it.
Then save and test the flow.
After flow runs,the csv file content will be add into sharepoint list.
For more info you can refer to:
https://www.encodian.com/blog/parse-a-csv-file-and-add-content-to-a-sharepoint-list/
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
AndrejZitnay 4 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-LilyW-msft ,

Many thanks for your help.

Kind regards.

Andrej

Was this reply helpful? Yes No