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

Like (0) Share

Report

Posted on 4 Mar 2021 21:19:23 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

All responses (4)

Answers (1)

qopwer12 46 on 05 Mar 2021 at 15:29:35

Like (0)

Report

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

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!
qopwer12 46 on 05 Mar 2021 at 14:12:33

Like (0)

Report

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

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.
Verified answer

v-yiwenxie-msft Microsoft Employee on 05 Mar 2021 at 02:14:08

Like (0)

Report

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

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.
ChristianAbata 8,947 Most Valuable Professional on 05 Mar 2021 at 01:07:45

Like (0)

Report

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

hi @qopwer12 you can use this trigger