web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send Weekly Email to "...
Power Automate
Unanswered

Send Weekly Email to "Assigned To" person in a task list for items with past due dates every Friday

(0) ShareShare
ReportReport
Posted on by

My task is to create a workflow that will send an email to the "Assigned To" persons fields on a Task List every Friday for a list items that are Past Due.

 

The Past Due Email would look like this:

Past Due Items Email.JPG

 

 

Task List is called, "ActionTracker"

 

I may be going about this the wrong way but here is what I've tried/done so far:

 

1. Create a Recurrence MS Flow, Get ActionTracker Items, and create two variables to hold HTML emails

First Step.JPG

 

2. Then send Past Due Email to "Assigned To" person using For Each of "Get ActionTracker Items"Send Email with Variables pt1.JPG

3. Since I'd like a List of ALL items, not just the one iteration that im on, i created a variable to hold that current iterations "email body" which appends to a variable that is used in the "final" email.

 

 Send Email with Variables pt2.JPG

 

 

 

What this will do now is send me a email with one item from the list, followed by an email for each additional item, but with other items listed as well (All Items past due date, which I want).

 

Picture of the two emails that I get:Result_2.JPG

 

 

 

------------------------------------------------------------------------------------------------------------------------------------------------------------------

Result_1.JPG

 

 

 

 

I hope I explained and gave enough information, please reply if you'd need more.

Thank you for any help that you can provide.

-Jonathan

Categories:
I have the same question (0)
  • v-yuazh-msft Profile Picture
    on at

    Hi @ JonathanNguyen,

     

     

    Could you please take a try to move the "Send an email" action outside the "Apply to each".

     

    Please let me know if the flow would achieve your needs?

     

     

    Regards,
    Alice Zhang

  • Community Power Platform Member Profile Picture
    on at

    I would do that but the Send Email Action gathers information for that email during the iterating of the "Apply to Each". 

    The workflow works this way currently, and maybe you can suggestion a different approach that would allow me to move the Summary Email out of the "Apply to Each" loop:

    1. User adds action item to ActionTracker SharePoint List.

    2. Flow add "HTML content" to "EmailBody" column of that specific Action Item:EmailBody_In_List.JPG

     

    That EmailBody column for that item contains the Task Name and Due Date of that item wrapped in HTML formatting with table, code is shown here:Update_EmailBody_Column.JPG

    3. A second MS Flow then runs every Friday, with the objective of sending each person that is Assigned To a task a List of all Task Name and Due Dates currently past due.

    4. The Second MS Flow aka "Every Friday" Flow, then added the above html code for each task the person is assigned to:

     

    <!-- 1 Column Text + Button : BEGIN --> <tr> <td bgcolor="#ffffff"> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%">

    <tr> <td style="padding: 5px 40px 5px; text-align: center; background: #f2f2f2;">

    <h1 style="margin: 0; font-family: sans-serif; font-size: 24px; line-height: 125%; color: #333333; font-weight: normal;">These tasks are Past their Due Dates:</h1>

    </td> </tr>

    <tr>

    <table width="100%"> <tr> <th valign="top" align="center" style="font-size: 9pt; font-family: ‘Segoe UI’; border: 1px solid #ddd; background-color: #f2f2f2; padding: 3px 15px;">Task</th> <th valign="top" align="center" style="font-size: 9pt; font-family: 'Segoe UI'; border: 1px solid #ddd; background-color: #f2f2f2; padding: 3px 15px;">Due Date</th>

    </tr> ​Past Due Email Body×​​ </table>  ************** This will  repeat for each Task Name Assign To User

    </tr>

    <tr> <td style="padding: 0px 40px 15px; font-family: sans-serif; font-size: 15px; line-height: 140%; color: #555555; background: #f2f2f2;"> </td> </tr> </table> </td> </tr>

    <!-- 1 Column Text + Button : END -->

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard