cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qopwer12
Helper I
Helper I

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

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 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yiwenxie-msft
Microsoft
Microsoft

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.

3.5-1.PNG3.5-2.PNG

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:

3.5-3.PNG

The result of the flow is:

3.5-4.PNG

 

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.

 

View solution in original post

4 REPLIES 4
ChristianAbata
Super User II
Super User II

hi @qopwer12  you can use this trigger

bbas.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
v-yiwenxie-msft
Microsoft
Microsoft

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.

3.5-1.PNG3.5-2.PNG

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:

3.5-3.PNG

The result of the flow is:

3.5-4.PNG

 

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.

 

View solution in original post

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
Helper I
Helper I

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! User Profiles.PNG

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (77,648)