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

Community site session details

Session Id : GNuYZMCLwZdtobZsuhOPTg
Power Automate - Building Flows
Unanswered

How to send email digest of all pending tasks per bucket twice a week

Like (0) ShareShare
ReportReport
Posted on 2 Aug 2019 09:56:26 by

Hi! I am new to Flows and would like to know how I can use flow to send an email digest containg a summary of all pending tasks of all users per bucket in Planner.  I have searched available templates and found the ff:

  • Send daily email summary of tasks in planner (regardless if completed or not)
  • Send email digest of pending tasks per user (can be scheduled)

 

What I would essentially want to do is combine both: send a scheduled digest (twice a week) containing only the pending tasks per bucket.  Each team is assigned their own bucket and I would like my flow to check each bucket, list all the pending tasks, note who these tasks are assigned to & the due date and send this as an email to an email address that I will define.

 

Thank you very much!

  • v-yamao-msft Profile Picture
    on 07 Aug 2019 at 09:41:33
    Re: How to send email digest of all pending tasks per bucket twice a week

    Hi @Anonymous ,

     

    You need to add the Filter array action directly after the Append to string variable, then modify the following actions to select value from Filter array instead of List tasks.

     

    I have tested with the following configuration, which is working properly.

     

    Further, you also need to add another action Get user profile to return email address.

    1.PNG

     

     

    Best regards,

    Mabel  

     

  • Community Power Platform Member Profile Picture
    on 06 Aug 2019 at 12:19:07
    Re: How to send email digest of all pending tasks per bucket twice a week

    @v-yamao-msft wrote:

    Hi @Anonymous ,

     

    I assume that the following template “Create a daily summary of Planner Tasks by Bucket” could be a reference:

    https://asia.flow.microsoft.com/en-us/galleries/public/templates/df5797658f954281b54bad8bf9cc8246/create-a-daily-summary-of-planner-tasks-by-bucket/

     

    Further, if you want to contain only pending tasks, you need to add a Filter array action to filter out tasks that are not completed.

     

    Please take a try with it on your side.

     

    Best regards,

    Mabel          

     


    Hi @v-yamao-msft,

     

    Thank you for your suggestion.  I have tried using that template as reference but pretty bummed on where to put my filter to exclude those tasks with 100% completion


    flow.PNG

     

    I am pretty sure I should put it before I append my array variables but I'm not sure exactly where?

     

    I am also having difficulties finding the values where tasks are assigned to in Planner.  All I can see is the Assigned To User Id which just returns encrypted data when I run my flow 😞

     

    flow2.PNG

     

    Hope someone can enlighten this Flow newbie.  Thanks!

  • v-yamao-msft Profile Picture
    on 05 Aug 2019 at 06:16:09
    Re: How to send email digest of all pending tasks per bucket twice a week

    Hi @Anonymous ,

     

    I assume that the following template “Create a daily summary of Planner Tasks by Bucket” could be a reference:

    https://asia.flow.microsoft.com/en-us/galleries/public/templates/df5797658f954281b54bad8bf9cc8246/create-a-daily-summary-of-planner-tasks-by-bucket/

     

    Further, if you want to contain only pending tasks, you need to add a Filter array action to filter out tasks that are not completed.

     

    Please take a try with it on your side.

     

    Best regards,

    Mabel          

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2