Power Platform Community Forum Thread Details

Hello,

I hope you can help me.

As a result of "Planner.ListTasksV2(id).value" for all Planner plans of our groups, I have a collection with the userIds that are assigned to a task nested in "_assignments". I want to have an own row for each task with one user. For example if one task has three assigned users, I want to get three rows with each title+userId. So I want to "unnest" it. But i don't now, how ich need to write it in PowerApps.

In the collections view, _assignments is shown as an object. I'd like to create a new collection with the tasks and a column for the userId so the task's title and userId together would be like a primary key.

I need to filter the tasks by each userId that is nested in _assignments.

In fact this approach is only a workaround, because the Graph query "GET all Planner tasks for user: https://graph.microsoft.com/v1.0/users/{id | userPrincipalName}/planner/tasks" doesn't work with another user than my own because of permission issues.

I'm sorry, if I'm too confusing.