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?
Hi!
I believe this thread describes an scenario (and a solution) very similar to what you need
Hope this helps
Proud to be a Flownaut!
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
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!
Proud to be a Flownaut!