Unanswered

Flow for Merge Excel files

(0) Share

Report

Posted on by Worker66

I created Microsoft Form for collection of Excel files in a specific template from my team members on daily basis. I need to combine all received files in a particular day in a single master Excel file (contains progress of past days) which will be forwarded to my manager.

Table format for template and master file is below.

Date	Team Member Name	Progress
6/7/2020	Mr. ABC	20%

I tried to create flow but couldn't find any action which dynamically reads new received file and copies data to master file. If anyone of you knows any solution or other workaround do let me know please.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Anupam.Khasia 366 on at

Like (0)

Report
Copy link

Link copied!

Hello @Worker66 ,

You can perform following steps to merge your daily excel files.

1) create one file in one drive that is your master file
2) create action to read attachments from email . (You can apply filter conditions for reading specific emails)

3) update one drive file with content you read from previous step.
https://docs.microsoft.com/en-us/connectors/onedrive/#update-file

Was this reply helpful? Yes No
mlam 4 on at

Like (0)

Report
Copy link

Link copied!

Hello @anupam8555 ,

Do you have screen shots of how to do step 1-3.

Thanks,

Was this reply helpful? Yes No
Anupam.Khasia 366 on at

Like (1)

Report
Copy link

Link copied!

Hi @mlam ,

Here is what it looks like. You might have tweak that into your needs but basically its upload file to oneDrive , read that file from oneDrive and update content to master file in oneDrive.

Thanks
Anupam
(Please mark it as resolved or give thumbs up if it helps you)

Was this reply helpful? Yes No
kmsdove 60 on at

Like (0)

Report
Copy link

Link copied!

If you have large Excel files this could be problematic. Powershell definitely does this quicker.

Was this reply helpful? Yes No
Artefactual 2 on at

Like (0)

Report
Copy link

Link copied!

Hey Anupam,
I'm having similar issues, but I can't really see the attachments you've sent too well, could you perhaps resend them in a similar fashion to this?:
Or maybe even this:
Thanks,
Ben.

Was this reply helpful? Yes No