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)
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.
@v-chengfen-msft Thanks a lot, this is what I am looking for!
@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.
Hi @av3xsubz ,
if the task is not completed ,completedDataTime is null.
Here is a test for your reference:
Here is bucket:
Here is result:
Best Regards
Cheng Feng
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2