ForAll Patch

(0) Share

Report

Posted on by krj_onlands

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.

ClearCollect(colLokationIds;table1);;

ClearCollect(colLokationIds; ShowColumns(table1; "cr677_nykolonne"))
ForAll(
 colLokationIds,
 Patch(
 table2,
 Defaults(table2),
 {LokationId: LokationId}
 )
);

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Pstork1 68,923 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
In the forall you need to reference the record to access the value. Something like this

ClearCollect(colLokationIds;table1);; ClearCollect(colLokationIds; ShowColumns(table1; "cr677_nykolonne")) ForAll( colLokationIds, Patch( table2, Defaults(table2), {LokationId: thisRecord.LokationId} ) );

Was this reply helpful? Yes No