Getting Planner Tasks from a Specific Bucket to Excel

(0) Share

Report

Posted on by Rocky1313

Hello,

I'm trying to create a flow that will add Planner tasks from a specific bucket to a table in excel. I can pull the task title and due date with no issues. But I cant seem to get the display name of the user the task is assigned to. Every time a reference "value assignments assigned To User Id" Power automate throws it into a apply to each loop. Fine, I guess it could possibly be assigned to more that one user. The problem is when I run the flow I get an error...

"the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array."

Any ideas?