Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Send an email with aggregated info from sharepoint list


I'm struggling with my flow construction, probably because I'm such a newbie at this...


Here's the context...


I have a Sharepoint list of items - each is a project status update including the project name, current status and current activity and the date the information was entered, normal and blocking issues, etc etc.  


The project managers will input to the list every week, using a powerapp.  Then I want to trigger a flow (probably a recurring schedule) that sends an email to the various project sponsors with the latest inputs for each project, the current status of the project and the current activity. 


I scoured around and experimented, but have failed to develop a successful flow.


Any help gratefully received.



Community Support Team
Community Support Team

Re: Send an email with aggregated info from sharepoint list

Hi @Eric3,


If you could put a column in the SharePoint list with the various project sponsors' emails, this could achieve easily with a flow like this:



Put the project sponsors' emails in the To field and the sharepoint columns in the Body.




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Send an email with aggregated info from sharepoint list

thanks Mona... my problem is that the information will come from more than one item in the list and I wish to filter by  most recent entry by project name, grab the specific 'cells' from each 'row', join those into one html or string and email that to the sponsor group. 


Am I right in thinking that your suggestion means that each sponsor would get the results of one item per email, and that they would get an email for every 'row' for the project, not just the most recent entry.


What do you think?



Level: Powered On

Re: Send an email with aggregated info from sharepoint list

So, I finally figured out how to do this...

It goes like this..


Action 1

Level: Power Up

Re: Send an email with aggregated info from sharepoint list

Any chance of seeing the rest of this solution?

Level: Powered On

Re: Send an email with aggregated info from sharepoint list (MY SOLUTION)

As requested by matthew_B, here's how I ended up...

STEP 1 - Set up your Trigger.  Mine's a Recurrence at 12noon and 5 pm every Friday.


STEP 2 - Get Items.  input your Site Address and your List Name as prompted.  So far, so good.


STEP 3 - Filter that array.  In the From box select "value" from sharepoint

The magic happens in the equation, which looks like this:

@or(equals(utcNow('yyyy-MM-dd'), item()?['WedText']),equals(utcNow('yyyy-MM-dd'),item()?['TueText']),equals(utcNow('yyyy-MM-dd'),item()?['MonText']),equals(utcNow('yyyy-MM-dd'),item()?['ThurText']),equals(utcNow('yyyy-MM-dd'),item()?['FriText']),equals(utcNow('yyyy-MM-dd'),item()?['WeekEndText']),equals(utcNow('yyyy-MM-dd'),item()?['WeekStartText']))


For this to work, you will need columns in your sharepoint that calculate the start of the week for each create date column.

You'll also need columns for each day of the week.  For example, MonText is a column in the sharepoint that is a textstring of a column that calculates the date for Monday of that week (based on the Date Created column).  With me so far?


STEP 4:  Use "Select".  "From" is "Body".  Map the key and values you wish to include in your email.


STEP 5:  Use "Create HTML table"


STEP 6:  use "Send an email" and set the Body to "Output"


Clouds part, angels sing. 


Although, seriously, if that is still a bit mysterious, reach out at


Good luck




Helpful resources


Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,054)