Update Multiple Records in SP list once

[Anonymous]

Hello Everyone,

I am trying to update multiple records in my SP list that pass a filter  but with my code below 

it only update one of the records not all at once 

Please help 

Patch('SP LIST',
First(Filter('SP LIST',User_Req_Sharp_ID = Label9.Text&&Assigned_HOD_Sharps = 'Logged_TL-Sharps'.Text&&Line_Manager_Approval_Status = "Approve")),
{'HOD_Approval _Status':"Approved",Line_Manager_Approval_Status:"Approved"})

[WarrenBelz · Accepted solution]

Hi @Anonymous ,

Something like this should do it

UpdateIf(
   'SP LIST',
   User_Req_Sharp_ID = Label9.Text &&
   Assigned_HOD_Sharps = 'Logged_TL-Sharps'.Text &&
   Line_Manager_Approval_Status = "Approve",
   {
      'HOD_Approval _Status':"Approved",
      Line_Manager_Approval_Status:"Approved"
   }
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Anonymous]

Thanks Boss 

It worked fine and fast !!!!!