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:
Solved! Go to Solution.
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.
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.