cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eric3
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
v-monli-msft
Community Support
Community Support

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.

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  

Eric3
Frequent Visitor

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

It goes like this..

 

Action 1

Any chance of seeing the rest of this solution?

Eric3
Frequent Visitor

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,046)