Create a summary report for all Planner Tasks completed this past month

[qopwer12]

Hi everyone, 

I found a power automation that sends a daily report of planner tasks by bucket here: 

https://flow.microsoft.com/en-us/galleries/public/templates/df5797658f954281b54bad8bf9cc8246/create-... 

but I was wondering if there was a way to send only completed planner tasks and to specify the range of them to only 1 month.

(ex. if 6 tasks were created, 2 was completed in January, and 3 was completed last month (February), the email will send out an array table that consists of only those 3 tasks + their descriptions + dates created. 

Thanks in advance 

[ChristianAbata]

hi @qopwer12  you can use this trigger

[v-yiwenxie-msft · Accepted solution]

Hi @qopwer12 

Thank you for your posting.

I've made a test which has run successfully.

You can use the template in your link, just change the recurrence to 1 month and add two rows in the condition:

In my test, I suppose the trigger runs at the first day of every month and the flow will get all the tasks completed in the past month.

The dynamic content 'value Percent Complete' is chosen from 'List tasks'.

The expression used:

formatDateTime(items('Iterate_through_tasks')?['completedDateTime'],'MM')

formatDateTime(subtractFromTime(utcNow(),1,'Month'),'MM')

The last row in the condition is used to check whether the month of task completed date is equal to the past month.

For more info about the functions formatDateTime(), items(), subtractFromTime(), utcNow():

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

The tasks completed in my all 4 buckets are:

The result of the flow is:

If you still have the problem, please feel free to let me know.

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[qopwer12]

Thank you so much! 

I added the two conditions and got a full list of what planner tasks were completed this past month and it works.

[qopwer12]

Hi Kira, 

I got another additional request to add into this array. Is it possible to pull out an email that also displays "assigned users" to the tasks so we can keep track of who is actually completing the tasks? 

ex) Person A, B and C was on Task 1 

Person A was on Task 3 

results show a table 

Assignee(s) and Task 

A B C                   1

A                         3

I added an apply to each profile that works for a smaller planner of 10 tasks or so but the flow is running super slow after I applied a bigger task planner that even after 15 minutes it still has not been processed.

Thanks in advance!