Add only 1 column from a collection to an existing collection

[mozzerellagoril]

**all dummy data

This is the existing collection, "AS"-

ClearCollect(
AS,
ForAll(
Attendance,
Patch(
ThisRecord,
LookUp(
COM,
cl_code = Attendance[@cl_code]
)
)
)
);

The column I want to add is from the collection "SessionInfo", this is how it looks like -

I only want to add the column, " Capacity" into according to the "cl_code" column in "AS" 

[v-bofeng-msft · Accepted solution]

Hi @mozzerellagoril ,

Please try:

ClearCollect(
   AS,
   ForAll(
      Attendance,
      Patch(
         ThisRecord,
         LookUp(COM,cl_code = Attendance[@cl_code]),
         {capacity:LookUp(SessionInfo,cl_code = Attendance[@cl_code]).capacity}
      )
   )
);

Best Regards,

Bof

[mozzerellagoril]

Hi, it seems that the solution is interfering with the another collection of mine..

ClearCollect(
SessionInfo,
ForAll(
Session,
Patch(
ThisRecord,
LookUp(Class,cl_code=Session[@cl_code]),
LookUp(Speaker,sp_id=Session[@sp_id])
)
)
);

Before the solution code, "SessionInfo" was able to collect all the data from SQL, however with "AS" now in effect, it can only partially collect data..

The code for "SessionInfo" is the first ClearCollect, followed by 2 other and then "AS" last

[v-bofeng-msft]

Hi @mozzerellagoril ,

It seems that these two formulas will not affect each other, and I suggest you perform it separately and check if the problem still exists.

Best Regards,

Bof

[mozzerellagoril]

Hi @v-bofeng-msft ,

I have tried multiple times, and unfortunately when the two formulas are together, only "AS" is complete and "SessionInfo" is partially full. When I remove "AS", "SessonInfo" is a complete table. Both these formulas are placed in "OnStart".