Create a flow when a csv file is created in SharePoint

[sushmitha1403]

Hi,

I am new to Power Automate I need help in creating a flow.

I have a SharePoint folder where CSV files are dynamically created everyday with the file name DD-MM-YYYY.csv format

I have an Excel file in the same SharePoint folder where I need to keep updating the content from the newly created csv files. 

Thanks,

Sushmitha

[ManishSolanki · Accepted solution]

Hi @sushmitha1403 

Here is the sample flow.

In this example, I have used a csv file with 2 columns: Name & City:

The excel sheet where data from csv needs to be added is stored in SharePoint document library inside "Test" folder:

Flow:

1. Create an automate flow with "When a file is created" as a trigger. Set the SharePoint site, document library & folder where the csv file will be created:

2. Next, add "Get file content" action to read the csv file:

3. Add compose action to convert content from base64 to string. We would use expression to perform the conversion. Expression needs to be added in the expression window as highlighted in the below screenshot:

base64ToString(body('Get_file_content')?['$content'])

4. Now, add filter array to create an array from csv data & filter out the blank rows using query:

Expression used in "From" parameter:

skip(split(outputs('Compose'),decodeUriComponent('%0D%0A')),1)

To enter filter query, click "Edit in advanced mode" link on the bottom of filter array action and enter the below query in the textbox:

@not(equals(item(), ''))

5. Add "Apply to each" action to iterate each row and add "Add a row into a table" action to enter the data in excel sheet:

Expression used for 1st column:

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

pls note that index starts from zero so to get first column value use 0.

Expression used for second column:

split(item(),',')[1]

You could increment the index for subsequent columns based on the number of columns i.e. for nth column the expression would become :-  split(item(),',')[n-1]

Output of the flow would look like:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[sushmitha1403]

@ManishSolanki , thank you so much. It worked successful. I tested it on 3 data sets that has this requirement and all went good.
I have a follow up question please. One of the data set has ~4000 rows that gets generated every day. It took more than an hour to complete the flow with all the rows. Is there a way I can decrease this time? 

[ManishSolanki]

Hi @sushmitha1403 

You could follow the below awesome example for quickly saving the rows in excel:

Quickly Add Multiple Rows to Excel Table In Power Automate (matthewdevaney.com)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks