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
Super User

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,233)