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

Announcements

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 953

#2
Valantis Profile Picture

Valantis 810

#3
Haque Profile Picture

Haque 622

Last 30 days Overall leaderboard