Update records in the collection based on value from another collection

[Termigez1]

Hello,

I have 2 collections:

ColManualChanges

ID	Name	Version	Status
1	A	V1	1
55	D	V1	1
153	A	V1	1

ColFinalExport

ID	Name	Version	Status
1	A	V1	0
2	B	V1	1
3	C	V1	1

...

They have the same number of columns and column names. ColManualChanges consist of just "few" records and ColFinalExport are basically my all records from data source. I want to update the value of  ColFinalExport.Status based on the ColManualChanges.Status where ColManualChanges.ID = ColFinalExport.ID. (For each pair of ID in two collections all the values of the columns will always be the same, except the value of Status). So basically in given example for ID = 1 the value of Status in ColManualChanges is 1 and for ColFinalExport it is 0 so I want it to be updated to 1 so ColFinalExport would look like this:

ColFinalExport

ID	Name	Version	Status
1	A	V1	1
2	B	V1	1
3	C	V1	1

[krishnags · Accepted solution]

you can try 

ForAll(ColManualChanges,Patch(ColFinalExport,Lookup(ColFinalExport,ID=ID),{Status:Status}))

you can include all other required fields