Unanswered

Updating a SharePoint list within a ForAll by patching a drop-down menu value

(0) Share

Report

Posted on by rob4681

Hello People,

I'm updating multiple records in a SharePoint list by using a ForAll. Within the checked items to be updated there are drop down lists, 'Box' and 'Slot No'. Although no error is shown the update is not performed. Please suggest alternative code for these two lines as I have become stuck.

ForAll(CheckedItems As D,

Patch(RCAData,First(SortByColumns(Filter(RCAData,BatchID = DataCardValue16_2.Text && WaferID = D.'Wafer ID'),
 "Created",
 SortOrder.Descending)),
 {
 TrackOutTime: Now(),
 TrackOutComments: DataCardValue29.Text,
 TrackOutOperator: OperatorDropDown.Selected.Operator,
 Box: D.Box, 
 ProductID: DataCardValue5_1.Selected.Value,
 SlotNo: D.'Slot No',
 ProcessCount: CountRows(Filter(RCAData, BatchID = DataCardValue16_2.Text && WaferID = D.'Wafer ID'))
 }
 )
);

Thank you for your help.

Rob

All responses (4)

Answers (0)

rob4681 on at

Like (0)

Report

Re: Updating a SharePoint list within a ForAll by patching a drop-down menu value

Thank you for your response. I have BatchID as text. The code finds the correct line to populate. The problem is I cannot get the drop-down lists for Box and SlotNo to populate when patching. Thanks
anandm08 1,936 Super User 2025 Season 1 on at

Like (0)

Report

Re: Updating a SharePoint list within a ForAll by patching a drop-down menu value

i have wrapped the Datacardvalue16_2.Text(text) with Value because you are comparing it to BatchID(Number) and so on
rob4681 on at

Like (0)

Report

Re: Updating a SharePoint list within a ForAll by patching a drop-down menu value

Sorry I cannot see the changes.
anandm08 1,936 Super User 2025 Season 1 on at

Like (0)

Report
Re: Updating a SharePoint list within a ForAll by patching a drop-down menu value

ForAll(CheckedItems As D, Patch(RCAData,First(SortByColumns(Filter(RCAData,BatchID = Value(DataCardValue16_2.Text) && WaferID = Value(D.'Wafer ID')), "Created", SortOrder.Descending)), { TrackOutTime: Now(), TrackOutComments: DataCardValue29.Text, TrackOutOperator: OperatorDropDown.Selected.Operator, Box: D.Box, ProductID: DataCardValue5_1.Selected.Value, SlotNo: D.'Slot No', ProcessCount: CountRows(Filter(RCAData, BatchID = DataCardValue16_2.Text && WaferID = D.'Wafer ID')) } ) );
try this