Power Platform Community Forum Thread Details

I have an existing collection of group id's and plan id's and want to create a new collection record that uses these id's to create a percentage of completed tasks per plan.. This is to provide data for a progress chart next to each plan in a Gallery. As below

I have the following below for the existing collection:

Clear(MyGroupandPlansGalleryItems);
ForAll(
 RenameColumns(MicrosoftTeams.GetAllTeams().value, "id", "groupId"),
 Collect(MyGroupandPlansGalleryItems, AddColumns(Planner.ListGroupPlans(groupId).value,"groupname",displayName, "groupId", groupId))
);

Which works great.

Problem:

As understand I need now to create a collection of tasks for each of these plans (which requires both group id and plan ids). I have tried the following:

Clear(MyGroupandPlansCompletedGalleryItems);
Collect(MyGroupandPlansCompletedGalleryItems, AddColumns(Planner.ListTasksV3(MyGroupandPlansGalleryItems.id, MyGroupandPlansGalleryItems.groupId).value));

Intention:

As mentioned at the beginning, I want to group by plan Id and show percentage of tasks that are completed. I was going to use the "percentComplete" values from task details to create that percentage of completed tasks per plan.

Record of individual tasks below:

percentComplete	planId
0	BGdKsoj4AUuCWxQRd5DHAmUAEh6b
0	BGdKsoj4AUuCWxQRd5DHAmUAEh6b
50	BGdKsoj4AUuCWxQRd5DHAmUAEh6b
50	BGdKsoj4AUuCWxQRd5DHAmUAEh6b
100	BGdKsoj4AUuCWxQRd5DHAmUAEh6b