web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Best way to compile mu...
Power Automate
Unanswered

Best way to compile multiple email attachments into one file.

(0) ShareShare
ReportReport
Posted on by 13

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?

Abba_0-1663013543715.png

 

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:
I have the same question (0)
  • Ed Gonzales Profile Picture
    4,531 Most Valuable Professional on at

    @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.

  • leungly875 Profile Picture
    15 on at

    I'd save them all in a specific SharePoint folder.

    Then Get Data (SharePoint Folder) Power Query (From Excel) to combine them.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard