Sending Reminders for Planner Tasks

[JamesWo]

I am trying to build an Automate flow to send reminder emails to Planner task assignees. I live in the gov't version of O365 so the built-in email reminder functions of Planner do not work. I've successfully got all the tasks filtered into an array and when I look at the output of the array, I see the assignee userID but I cannot figure out how to reference it (it's not listed as an available dynamic content).

This is the basics of the flow so far (I had a bunch more in there but have deleted it):

When I run the flow as is (ending when the array filter step is completed), I can look at the output and see the data I want:

So, I used that information to run the Get User Profile action and just hand jamming this in the UPN field: @items('Apply_to_each')?['_assignments']?['userId'], which it seems to like as it resolves to an object vice the text.

But when I test it, I get this error:

[JamesWo]

It appears this template (Send reminder email for incomplete Planner tasks in a plan) might be helpful if someone can expand it all and post screenshots. I have very little templates in my tenant.

[JamesWo]

After more digging and learning, I think the problem is that when I filter the task list into an array, it's putting the task assignments in an array for each task. I believe that error message is a result of the nested arrays. Still trying to figure out how to parse the information from the nested array.

[v-xiaochen-msft · Accepted solution]

Hi @JamesWo ,

Please try this:

items('Apply_to_each')['_assignments']

items('Apply_to_each_2')['userId']

Best Regards,

Wearskky

[JamesWo]

That worked perfectly! Thank you!