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:
I'm using Office 365
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?
I believe this thread describes an scenario (and a solution) very similar to what you need
Hope this helps
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
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!
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.