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

[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 field names
Employee Name| Company Name| Start Day of Work |City | ID Number E-mail|

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?

[efialttes]

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-anot...

Hope this helps

[SinanALMAC]

 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]

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!