Answered

Create a daily summary of Planner Tasks by Bucket

(0) Share

Report

Posted on by av3xsubz

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)

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

v-chengfen-msft on at

Like (0)

Report
Hi @av3xsubz ,
Since the return value of [List tasks] is an array, we can use [reverse()] to sort the array.
One of the [Task List] ‘s return values: completedDataTime
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

Was this reply helpful? Yes No
av3xsubz 11 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Verified answer

v-chengfen-msft on at

Like (1)

Report

Hi @av3xsubz ,

please try :

Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
av3xsubz 11 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Duc_Tran_1983 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No