You’re offline. This is a read only version of the page.
2
Hi.
I'm trying to create new rows in Table 2 when I press a button, based on the number of rows in Table 1.
So if there is 20 rows in Table 1 it will create 20 rows in Table2 with Table2.ID = Table1.ID
I have the following code attached to OnSelect on my button. but It doesn't work. Any idea where I'm wrong?
I am using dataverse for my data.
Share
ReportClearCollect(colLokationIds;table1);;
ClearCollect(colLokationIds; ShowColumns(table1; "cr677_nykolonne"))
ForAll(
colLokationIds,
Patch(
table2,
Defaults(table2),
{LokationId: LokationId}
)
);
In the forall you need to reference the record to access the value. Something like this
All responses (
Answers (
ClearCollect(colLokationIds;table1);;
ClearCollect(colLokationIds; ShowColumns(table1; "cr677_nykolonne"))
ForAll(
colLokationIds,
Patch(
table2,
Defaults(table2),
{LokationId: thisRecord.LokationId}
)
);
