Unanswered

Best way to compile multiple email attachments into one file.

(0) Share

Report

Posted on by Abba

I've been trying for a few weeks to gather email attachments into one single file. I receive hundreds of emails with excel attachments in the same format and I need a way to automatically compile all of those attachments into one single file. For example, if I get the two tables on the left in two different emails, how do I get them together to look like the table on the right?

I tried following this video tutorial, but there's an issue with running scripts that I can't get around so I'm trying to find a method that works without using them. Any help or ideas would be appreciated!

Categories:

Business Process Flows

All responses (2)

Answers (0)

leungly875 15 on at

Like (0)

Report

Re: Best way to compile multiple email attachments into one file.

I'd save them all in a specific SharePoint folder.
Then Get Data (SharePoint Folder) Power Query (From Excel) to combine them.
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Re: Best way to compile multiple email attachments into one file.

@Abba
Hi there. Rather than using Power Automate only, check out Dataflows. That might be more along the lines of what you need.

https://www.youtube.com/watch?v=SueC1d2xUNQ

Keep us posted.
-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.