undefinedCSV to Sharepoint list with 8000+ records and 20 columns

[Anonymous]

Hello All,

I know this is woring forum to ask this question but hoping as I will get some solution here.

I am exporting Power BI data as CSV using Power automate to sharepoint which has 8000+ rows and 20+ Columns

Here is the sample records of the same,

Now I have to push the same data set to SharePoint list using Power automate and this flow should trigger automatically as when there is new file in the sharepoint documents.

I have created this flow which is loading 3200 records and remaining is not loading, the catch is every time before loading the data the flow should delete all the  exisiting records and reload the new records.

split(string(outputs('Get_file_content')?[body]),'\n')

skip(outputs('SplitByLine'),1)

split(item(),',')?[0]

Thanks in Advance!

[Anonymous]

Hi @Anonymous ,

I think the problem is related to the output of "get file content", which you can check by:

1. Check whether the output of get file content contains 8000 pieces of data.

2. Check how many times "Apply to each" run in the history of the flow.

Also, if you have previously used a CSV file with 3000 records in the same flow, choose "Manually" when you run the flow. You can also try removing and re-adding "get file content" action or recreating the flow, as sometimes flow gets stuck on historical data.

Best regards,

Mengmeng Li

[lbendlin]

Use the SharePoing Batch API for mass inserts.