web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Update Multiple Record...

Power Apps

Answered

Update Multiple Records in SP list once

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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"})

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Boss
It worked fine and fast !!!!!

Join the conversation