Unanswered

ForAll AddColumns to a collection

(0) Share

Report

Posted on by ajl80

Im trying to add columns to a collection.

I have a ForAll that loops through a SharePoint list getting group ids, this in turn populates a UsersList collection from all the members of each group. I want to add 2 columns to the collection to say which Group & Establishment they are from.

I have:-

ForAll(Office365StaffGroups,
 Collect(UsersList,Office365Groups.ListGroupMembers(ThisRecord.StaffGroupID).value)
// I guess I need to add this somewhere, AddColumns({GroupName:ThisRecord.StaffGroupName, GroupEstab:ThisRecord.StaffGroupEstab})
)

I have tried different combinations,

or do I have to do another forAll within to loop through the UsersList Collection adding the columns

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ajl80 32 on at

Like (0)

Report

sorted thanks to @RusselThomas
ForAll(Office365StaffGroups As groupRecord, //each record will be accessible via this variable Collect(UsersList, AddColumns(Office365Groups.ListGroupMembers(groupRecord.id).value, "groupID", groupRecord.id) //this will add a groupID column with the value of the current groupRecord.id ) )

Was this reply helpful? Yes No
alrezac on at

Like (0)

Report

Hi,

Thanks for your follow up post! I am glad that you were able to figure out your issue. Hopefully this will prove useful for future communities users who are having similar issues.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No