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

(0) Share

Report

Posted on by 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-a-daily-summary-of-planner-tasks-by-bucket/

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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @qopwer12 you can use this trigger

Was this reply helpful? Yes No
Verified answer

v-yiwenxie-msft Microsoft Employee on at

Like (0)

Report

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.

Was this reply helpful? Yes No
qopwer12 46 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
qopwer12 46 on at

Like (0)

Report

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!

Was this reply helpful? Yes No