Team's Planner Scheduled Email for Incomplete Tasks to Assignees In Particular Bucket

[Sephiel]

Hi community,

I am trying to set up a Flow to email three particular people a list of their incomplete tasks in a particular bucket in our large shared planner. I have tried dozens of combinations of steps with no success. I have tried to troubleshoot every step by making my last step sending me an email with the expected output ID, title, etc.

If I create the step "List Tasks", I cannot get it to return a "true" statement if I make a condition where

"value Bucket ID" is equal to string('Ddpmckl3Jk6K5X-Mz5tHgmQAPgVq')

Even though I should get two emails (there are two tasks in that bucket.) I can get it to work if I instead use "List Buckets" but that's not the data I need in order to make this email work.

I've tried doing it through a Filter Array, which will email me properly the list of tasks in the bucket. The problem then is that further along in the process I need to invoke the "value assignments" content in order to see "value assignment Assigned To User ID" in order to email the specific person their open tasks. When I add that content, it nests multiple "Apply To Each" loops which messes up the logic.

I'm at a loss for the best way to tackle this.

So to summarize, I need to send a scheduled email detailing non-complete tasks, assigned to a particular person, from one particular bucket.

• My bucket: "Data Approval", ID = Ddpmckl3Jk6K5X-Mz5tHgmQAPgVq
• Task is not set to "Completed"
• Assigned To Person1 ID: f295235c-8fe9-4156-b2ce-8d568bb702d1, Person2 ID: 3fe1af96-f538-452f-bcab-cf09459155dc, or Person3, ID:130f0651-ff8a-4461-91fa-0da81c60d316 (these are dummy user ID numbers)

The email doesn't have to be fancy, I can format the HTML the way I need, but the body needs the task name or ID.

Can I please get some help with the best way to tackle this? Appreciate the help very much!!

[v-yamao-msft · Accepted solution]

Hi @Sephiel ,

Currently, we are not able to get Assigned to info from Planner tasks, here is one of the similar hot requests on Flow Ideas Forum, please vote and comment it at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/Planner-Get-more-task-details/idi-p/72538

Further, this template Create a daily summary of Planner Tasks by Bucket could be a reference when getting tasks under specific bucket:

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

I have made a simple test on my side for your reference as well:

Best regards,

Mabel

[Sephiel]

Thanks, Mabel. I will see if I can twist their arms to have their own buckets rather than shared!