web

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

News and Announcements icon

Power Platform CommunityForums Power Apps ForAll Patch Update on...

Power Apps

Answered

ForAll Patch Update only First record

(0) Share

Report

Report

Posted on by sacpat

4

Hi. I am trying to update bulk record in SharePoint List with using below code

ClearCollect(Coll_loop_Mater_Table,Filter('Master Table',Title=btn_LOB_MS.Text && Product=btn_Product_MS.Text));
ForAll(Coll_loop_Mater_Table,
Patch('Master Table',LookUp('Master Table',Title=btn_LOB_MS.Text && Product=btn_Product_MS.Text),
{
'Team Manager':Combo_Manager.Selected.GivenName & " " & Combo_Manager.Selected.Surname
'Team Manager mail Id':Combo_Manager.Selected.Mail
}));

but it's update only first row in list. is that because using multiple conditions in lookup which patching record.

I can see all the record in collection but update only first row.

please help me to come out.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,530 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sacpat ,

I am assuming here you are updating all the matching records with the various fields selected in a Combo Box. I also have to assume that the user has selected one of these fields before the Patch (if not the other two will not be available)

With( { wMaster: Filter( 'Master Table', Title = btn_LOB_MS.Text && Product=btn_Product_MS.Text ) }, Patch( 'Master Table', ForAll( wMaster As aPatch, { ID: aPatch.ID, 'Team Manager': Combo_Manager.Selected.GivenName & " " & Combo_Manager.Selected.Surname 'Team Manager mail Id': Combo_Manager.Selected.Mail } ) ) )

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.

Visit my blog Practical Power Apps
sacpat 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thanks a lot. This is really help.
I have been stuck for month.

and thanks a lot to @RezaDorrani

Join the conversation