**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"
Solved! Go to 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
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
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
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
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".
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |