Answered

patch records on a list column into another list

(0) Share

Report

Posted on by Community Power Pla...

I have 2 Lists (ListA and ListB) with same unique id EID. Now I want to compare ListA.EID and ListB.EID when its true patch all the data in field ListA.Status into ListB.Status. How do i do this?

I tried below but not working

Patch(ListB, LookUp(ListB, EID in ListA.EID), {Status : ListA.Status});

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Can you define the ListA.EID before?? That might be what is causing the error and you should use equals ( = ) instead of in

Set(varEIDFromListA, CONDITION);

Patch(ListB, LookUp(ListB, EID = varEIDFromListA), {Status : ListA.Status});

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Hi @Anonymous

@Nogueira1306 mentioned we need an equal sign and condition to update a single record.

For multiple records, we may need to loop through
ForAll( ListA As Source, With( { Item: LookUp( ListB, EID = Source.EID ) }, If( !IsBlank(Item), Patch( ListB, Item, {Status: Source.Status} ) ) ) )

Again, no records are based on the app settings limit.

Thanks,
Stalin - Learn To Illuminate

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

Like (0)

Report

ListA.EID is a field name not parameter.
varEIDFromListA : No this is a field from another List

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

Like (0)

Report

The item still flagging error

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Item is just a temp variable. You can rename anything. Please share the error.

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

Like (0)

Report

The button faded and query was running forever and never patches. Both Lists has 250 records.

button.PNG

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@Anonymous

Doing this will incur issues with delegation to the datasource. So if record amounts don't exceed record limits, then you can use the following formula:

Patch(ListB, ForAll(Filter(ListB, EID in ListA.EID) As _item, With({_a: LookUp(ListA, ListA.EID = _item.EID)} Patch(_item, {Status: _a.Status}) ) ) )

This formula uses the ForAll properly (as a table producing function) and will not put your app into a "deadlock" trying to perform the operation. It will still not be the most performant formula do to the amount of data actions it has to do.

But, if delegation is not a concern, then it can be streamlined to be much quicker.

I hope this is helpful for you.

Was this reply helpful? Yes No