Add additional column for Planner planId per groupId

[simondpalmer]

Hi I have a button which has the following:

ClearCollect(MyGroupandPlansGalleryItems,If(!IsEmpty(MicrosoftTeams.GetAllTeams().value),ForAll(MicrosoftTeams.GetAllTeams().value, AddColumns(Planner.ListGroupPlans(id).value,"groupname",displayName))));
Clear(MyPlansGalleryItems);
ForAll(MyGroupandPlansGalleryItems,Collect(MyPlansGalleryItems,Value))

This works perfectly providing these columns :

 However I want to add a column for the group id. Not only the group name which in this case is shown as "groupname".

Therefore I want the following column headers (derived field):

• groupname (groupname)
• groupId (groupid)
• title (planname)
• id (planid)

The purpose of this is to use these id's for a flow that brings back planner task information that is otherwise not available (i.e. appliedCategories..etc.) 

I tried to use Planner.ListGroupPlans(id).value again but it just got to confusing with all the syntax. Any help would be great thanks

[v-xida-msft · Accepted solution]

HI @simondpalmer ,

Could you please share a bit more about your scenario?

Do you also want to add a GroupId column in your MyGroupandPlansGalleryItems collection?

I have made a test on my side, please consider take a try with the following workaround:

Set the OnSelect property of the Button to following:

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

The MyGroupandPlansGalleryItems collection looks like below:

On your side, please consider modify your formula as below:

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

Please consider take a try with above solution, then check if the issue is solved.

Best regards,