Unanswered

How to compile incoming excel spreadsheets into a master sheet as they come in?

(1) Share

Report

Posted on by ethanteoh

As I get my daily report (In the form of excel), I'd like for that data to be put into a master document, so that way I can track all daily reports in a single excel spreadsheet.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

sajidakram 104 on at

Like (0)

Report

Okay

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (1)

Report
Hi @ethanteoh ,

If the excel file you received has the same table structure and table name, maybe you could try as follows.

I'm assuming you get daily reports via email attachments and your master file is stored in a SharePoint document library

1. Here are my excel files.

2. Here is my flow.

items('Apply_to_each_2')?['ColumnName']

Result Screenshot:

In addition, here is a link for your reference:

https://powerusers.microsoft.com/t5/Building-Flows/Copy-Excel-file-data-to-different-Excel-file-in-SharePoint/m-p/1386017#M156280

Best Regards,

Charlie Choi

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

Like (1)

Report

@ethanteoh @v-yujincui-msft @sajidakram

If you need to more continuously update and/or create many rows in Excel, try batch actions:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706

Demo Video:
https://youtu.be/HiEU34Ix5gA

Was this reply helpful? Yes No