Patch – Update multiple records using Filter Function

(0) Share

Report

Posted on by SG1990-2

Hi,

I am trying to update all values within a column, when the reference = “123.

I think I have to use filter and Patch, however the patch function asks me for which record. As I want all the records updated that have reference “123” I am not sure what to include.

I have used the lookup function, but this only updates one record with a “123” reference, but I need them all.

Please can someone tell me what to include for the record section. I have put my code below – but need to replace the “[All Records within filter]” part of the code.

ClearCollect(colTest,tDisposal);

ForAll( colTest,

Filter( tDisposal, Property_Reference = "123"),

Patch( tDisposal, [All Records within filter],

{ Claimant_Company: "Company" }

)

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!
Apologies for my last reply. I understand it wrongly, pls try this formula:

ClearCollect(colTest,tDisposal);
UpdateIf(colTest,Property_Reference = "123",{Claimant_Company: "Company"});
Patch(tDisposal,colTest);

Thanks

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

Try this:

ClearCollect( colTest, ShowColumns( Filter(tDisposal, Property_Reference = "123"), "ID","Claimant_Company" ) ); UpdateIf(colTest, true, { Claimant_Company: "Company" }); Patch(tDisposal,colTest);

This code will create a collection with only ID and Claimant_Company

it will update the column Claimant_Company of that collection

and then Patch that collection to the database

Any doubts let me know

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi
You're almost there.
Do this:
ClearCollect(colTest,tDisposal); ForAll( Filter( colTest, Property_Reference="123" //(or 123 if its a number) ) As _patchRecords, Patch( tDisposal, {ID:_patchRecords.ID}, { Claimant_Company:"Company" } ) )

If you have a lot of records, you could add a Collect(Progress in the for all to make a progress bar).

Hope this helps 🙂

Was this reply helpful? Yes No