cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SinanALMAC
Regular Visitor

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

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?

3 REPLIES 3
efialttes
Super User III
Super User III

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

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!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,039)