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 / Creating a summary ema...
Power Automate
Answered

Creating a summary email of all emails received into a shared mailbox

(0) ShareShare
ReportReport
Posted on by 60

Hi

 

i need to create a flow that will send an email each day that summarises the emails received into a shared mailbox over the previous 24 hours 

 

is this possible? Can anyone assist

Categories:
I have the same question (0)
  • Verified answer
    Manish Solanki Profile Picture
    15,167 Moderator on at

    Hi @Bigshow 

     

    Pls refer the below sample for sending the summary of emails received to shared mailbox:

     

    1. Firstly, we will set the recurrence for sending the daily email. Here I have set up trigger time as 11:59 PM:

    ManishSolanki_0-1694253722310.png

     

    2. Next, add "Get emails" action to get all the emails which are received today i.e. past 24 hours. Using search parameter, we are filtering the emails which are received today and in the 'Original Mailbox Address' put the shared mailbox address:

    ManishSolanki_2-1694254067737.png

    Search query used here:

    received:@{formatDateTime(utcNow(),'yyyy-MM-dd')}

     

    3. Now, add "Create HTML table" action to create html table. Select "Custom" option from 'Columns' drop down list to add the columns required for sharing summary in the html table. For getting the value of each header, we need to write an expression. Expression needs to be written in the expression box as shown below:

    ManishSolanki_3-1694254341911.png

    Expression used for subject:

    item()?['subject']

    Expression used for sender:

    item()?['from']

    Expression used for recipients:

    item()?['toRecipients']

     

    4. Finally, add the output of create html table action in email body and send it to the required recipient:

    ManishSolanki_4-1694254515216.png

    I hope this flow will give you some idea to start with.

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

  • Bigshow Profile Picture
    60 on at

    Thank you!

    I was wondering, would it be possible to forward this summary email to the individuals who sent the original messages? I have a team who are sending emails to a shared mailbox, and I would like each of them to receive a summary of the emails they have sent.

  • Manish Solanki Profile Picture
    15,167 Moderator on at

    If you are looking for grouping the emails based on the sender and then send the summary to respective sender, then it is possible using "Select" action & writing some expressions. I have modified the flow and have attached the .zip package file here, which you can import in your environment:

    To import the flow, go to "My flows" --> "Import" --> "Import Package (Legacy)"

    ManishSolanki_0-1694324135208.png

     

    Another thing is "Get emails" has the limit to return only 25 emails so if you want to fetch more emails then you need to change the action. I did not try it but found a nice tutorial to overcome that:

    How to get more than 25 emails from a mailbox with Power Automate (tomriha.com)

     

    You may more apply filter in "Get emails" like for recipient filter you can set the team members email in "To" parameter etc. as per your need.

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

     

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard