Unanswered

Flow to append a table into a excel file in sharepoint

(0) Share

Report

Posted on by DhineshKumar

Currently, I'm have created a flow that can upload the file to SharePoint. The challenge is that I have an excel file, say a.xlsx present in the SharePoint and I have a b.xlsx in my local repository with the same columns but totally different data. When I upload the b.xlsx through Powerapps it should append the b.xlsx into a.xlsx.

Is this possible?

can some help me from scratch?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

v-litu-msft on at

Like (0)

Report

Hi @DhineshKumar,

Yes, it is possible, you could create a flow to monitor a SharePoint folder. When b.xlsx file is created in the folder, Get its tables + Lists rows action to get all rows. Then use Apply to each action + Add a row into a table to append these rows into a.xlsx file.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
DhineshKumar 14 on at

Like (0)

Report

The flow executes successfully but I don't see any rows add in the a.xlsx file. Did I miss something? I have done the exact representation of yours.

for example, I have a production data in monthly order. The file existing in the Sharepoint folder is jan_production.xlsx and when I add the file (i. e) feb_production.xlsx in SharePoint, the table in the feb_production.xlsx must be appended into the jan_production.xlsx.

Was this reply helpful? Yes No
DhineshKumar 14 on at

Like (0)

Report

In the action of adding a row how to get the values of each row. Do I have to use any expression to get the value? if so what is the expression used?. I think is happening due to the first trigger action of getting the properties only

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

Hi @DhineshKumar,

After get rows, create an Apply to each action to loop through them, then add Add a row into a table action to add them into the master excel file.

The expression should be item()?['columnName'], it means get current column value:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
webbrewer 338 on at

Like (0)

Report

The answers above require that a table exists in the excel file, which is often not the case especially with files exported from 3rd party software. If your file has no tables, you can create a table following this guide:
http://webbrewers.com/microsoft-flow-append-excel-data-to-a-sharepoint-list/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

This works fine for me, but it takes quite a long time (I guess power automate adds row by row). Is there a way of doing something similar, but just append directly a whole table?

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@Anonymous

If the data you want to append to the table is less than 16,000 rows, then this template has a batch create action that can do it in a minute.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706

Was this reply helpful? Yes No