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.
Solved! Go to 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
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
Thanks Jeff. UpdateIf worked. 😀
User | Count |
---|---|
182 | |
123 | |
88 | |
45 | |
42 |
User | Count |
---|---|
250 | |
160 | |
126 | |
78 | |
73 |