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 / Download Attachment fo...
Power Automate
Unanswered

Download Attachment form Outlook

(1) ShareShare
ReportReport
Posted on by 9

Hi To all,

 

I'm new to Power Automate and I want to solve a little issue. Daily I receive a report from 4 different email address that has 1 excel file in each email, I need to save all the attachments  and then combine all 4 of them into a single report and send it to multiple email address. Although is not time consuming I want to automate the task to run even if I not in the office or away. 

the output excel file must be in the format "Client" Alerts - [todays date}.xlsx

Categories:
  • trice602 Profile Picture
    16,699 Super User 2026 Season 2 on at

    Hi @SBarrios ,

     

    I'm doing this in production on a handful of different variations with a lot of success.  That said, it's a little complex and if it is your first flow, it may be challenging to build.  But, let's go through the framework!

     

    1) So in this case, I would have 4 different cloud flows monitoring your inbox to look for these attachments from specific email addresses.  You could collapse this into a single flow depending on the attachment names or and other factors but without knowing the details, I am describing as such.

     

    2) The flow(s) above will save the attachments to a OneDrive or SharePoint folder (your choice).

     

    3) Next you join all the attachments with a dataflow (aka Power Query for the power platform).  If you have used Power Query before, it's 99.99% the same with some more options.  But essentially you will take all 4 attachments and stack them on top of each other and create a "new" table containing all 4 attachment contents.

     

    4) You can then use the new table data and send out your email as needed.

     

    All of this works really well and I have this same framework doing this in the middle of the night on a handful of flows.

     

    So how do you get started - my recommendation:

     

    1)  Break this down into small bites.  Start by first saving your attachments to OneDrive or SharePoint and check that box as complete. Then go to step #2. Etc. Etc.  You will find using this method, you will end up with a fully developed, complete solution you need.

     

     

     

     

  • SBarrios Profile Picture
    9 on at

    Thanks, is really helpful.

    I'm stuck on get the first step as I'm new to power automate and use the standard flow that is in the pre built demo.

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 289

#2
11manish Profile Picture

11manish 282 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 119

Last 30 days Overall leaderboard