Unanswered

Combine excel files in one share point list and update list when any excel file updated

(0) Share

Report

Posted on by SinanALMAC

Hi all,

I'm working with more than 5 companies. Every company sends me a mail their employee status every month as an excel file.
I just want to merge these files in a SharePoint list or Excel file automatically

File names are different this file’s content is the same

Here are the file names:

employee_company1.xlsx
employee_company2.xlsx
emplayee_company3.xlsx etc.

I'm using Office 365
onedrive
SharePoint
Flower

With the flow. I can collect all files in an onedrive folder.

Does anyone have an idea how to combine these files in one place when i get a new mail?

Categories:

General topics

All responses (3)

Answers (0)

Sort by

efialttes 14,756 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!

I believe this thread describes an scenario (and a solution) very similar to what you need

https://powerusers.microsoft.com/t5/Building-Flows/Copy-excel-contents-from-email-attachment-to-another-excel/m-p/496257

Hope this helps
SinanALMAC 4 on at

Like
a
(0)

Report
Copy link

Link copied!

hey @efialttes ,
Thank you for your reply.

but I'm trying to update a share point list with 3 different excel files with the same column names

best regards
efialttes 14,756 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!

Sorry for the misunderstanding, when I read your first comment I understood data could be finally stored either on a SP list or on an excel

"I just want to merge these files in a SharePoint list or Excel file automatically"

No problema, Happy Flowing!