cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Send an email with aggregated info from sharepoint list

Hi

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.

 

Eric

5 REPLIES 5
Highlighted
Community Support
Community Support

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:

Capture.PNG

 

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

 

Regards,

Mona

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.
Highlighted
Frequent Visitor

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?

 

E3  

Highlighted
Frequent Visitor

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

Highlighted
New Member

Re: Send an email with aggregated info from sharepoint list

Any chance of seeing the rest of this solution?

Highlighted
Frequent Visitor

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 napper.abc@gmail.com

 

Good luck

 

 

 

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,749)