ForAll Issue when using a collection

(0) Share

Report

Posted on by rob4681

Hello All,

I have created a collection CheckedItems, which is then used to create entries in a SharePoint list using a patch function which I have done successfully. The second part (below) is to then update a different SharePoint list which uses the same collection, ThisRecord.'Wafer ID' to update specific data. Please take a look below.

ForAll(CheckedItems,
Patch(BatchTrack, LookUp(BatchTrack, 'Batch ID'= DataCardValue16_1.Text && 'Wafer ID' = ThisRecord.'Wafer ID'),
 {
 State: {Value: "TrackOut"},
 OpCode: CurrCount + 1
 }
 ));

The error I get is pasted in below:

I am new to collections, so hopefully it's a simple mistake. The error highlights the LookUp function, so I suspect the issue is with 'Wafer ID' = ThisRecord.'Wafer ID'

Thank you in advance.

Rob

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @rob4681 ,

Do you want to look up record which has same 'Wafer ID' with CheckedItems?
Please try this:
ForAll(CheckedItems As C, Patch(BatchTrack, LookUp(BatchTrack, 'Batch ID'= DataCardValue16_1.Text && 'Wafer ID' = C.'Wafer ID'), { State: {Value: "TrackOut"}, OpCode: CurrCount + 1 } ));

Best regards,
Rimmon

Was this reply helpful? Yes No