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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
rob4681 on at

Like (0)

Report

Sorry I cannot see the changes.

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
rob4681 on at

Like (0)

Report

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

Was this reply helpful? Yes No