Help on ForAll Patch with Filter

[echodapogi]

Hello Guys,

I need help on using ForAll Patch with filter. My scenario is I have a dropdown box (drpBatchText) and i have a sharepoint list named (xlsPullbackTablePlanningList). I have a field name of "Status" in my Sharepoint list. What i want to do is a button that will update all my  Status data to "Complete" based on drpBatchText value. 

Lets say drpBatchText value is: Batch 1. I need to update all the Status of that Batch 1 to "Complete".

Here is my code:  but i cannot make it work. 

ForAll(xlsPullbackTablePlanningList, Patch(xlsPullbackTablePlanningList, LookUp(xlsPullbackTablePlanningList, BatchName= drpBatchtoSend.SelectedText.Value), {Status: "Complete"}))

Thanks in advance. 

[Jeff_Thorpe · Accepted solution]

I don't think you need Patch() in this case. Have you tried UpdateIf()?

It would look something like this:

UpdateIf( xlsPullbackTablePlanningList, BatchName= drpBatchtoSend.SelectedText.Value, {Status: "Complete"})

*Assuming Status is a text column

[echodapogi]

Thanks Jeff. UpdateIf worked. 😀