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 : kwkGTTNKYEuUbTF94krAa5
Power Automate - General Discussion
Answered

Create a daily summary of Planner Tasks by Bucket

Like (0) ShareShare
ReportReport
Posted on 25 Oct 2022 06:23:51 by 11

I am using the template "Create a daily summary of Planner Tasks by Bucket" and the basic information in the table is almost what I am looking for.  But I would like to get specific information on the email and in a certain order corresponding to how the buckets are arranged.

1. I would like to remove the completed tasks and not have it included in the summary
2. In the summary display, I want the first bucket on top and last bucket at the bottom (currently it is the other way around)

  • Duc_Tran_1983 Profile Picture
    2 on 10 Jul 2024 at 09:20:28
    Re: Create a daily summary of Planner Tasks by Bucket

    I want to summarize Planner tasks by bucket and display the name of the staff member assigned to each task in Planner.

    I'm currently using this format, but I can't find the value for "assigned to":

    Create a daily summary of Planner Tasks by Bucket | Power Automate

    Could you please assist with finding the correct method to include the "assigned to" like email or name.

     

    Duc_Tran_1983_0-1720603098643.png

     

     

     

  • av3xsubz Profile Picture
    11 on 27 Oct 2022 at 05:42:20
    Re: Create a daily summary of Planner Tasks by Bucket

    @v-chengfen-msft Thanks a lot, this is what I am looking for!

  • Verified answer
    v-chengfen-msft Profile Picture
    on 26 Oct 2022 at 10:05:47
    Re: Create a daily summary of Planner Tasks by Bucket

    Hi @av3xsubz ,

    vchengfenmsft_0-1666778956361.png

     

    please try :

    vchengfenmsft_0-1666778691595.png

     

    Here is result:

    vchengfenmsft_1-1666778721008.png

     

    Best Regards

    Cheng Feng

  • av3xsubz Profile Picture
    11 on 26 Oct 2022 at 03:11:49
    Re: Create a daily summary of Planner Tasks by Bucket

    @v-chengfen-msft the condition to remove the completed tasks is perfect.  However for the summary display, what I am looking for are the buckets to be rearranged from top to bottom and not the task per each bucket.

  • v-chengfen-msft Profile Picture
    on 25 Oct 2022 at 09:39:54
    Re: Create a daily summary of Planner Tasks by Bucket

    Hi @av3xsubz ,

    1. Since the return value of [List tasks] is an array, we can use [reverse()] to sort the array.
    2. One of the  [Task List] ‘s return values: completedDataTime

    if the task is not completed ,completedDataTime is null.

    vchengfenmsft_0-1666690702953.png

     

    Here is a test for your reference:

    Here is  bucket:

    vchengfenmsft_1-1666690702958.png

     

    vchengfenmsft_2-1666690702965.png

    vchengfenmsft_3-1666690702977.png

    vchengfenmsft_4-1666690702984.png

    vchengfenmsft_5-1666690702993.png

    vchengfenmsft_6-1666690702998.png

    vchengfenmsft_7-1666690703001.png

     

    Here is result:

    vchengfenmsft_8-1666690703004.png

     

    Best Regards

    Cheng Feng

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