Referenced action based on value from different table

[Pratyay_Rakshit]

There’s one table which holds a bunch of addresses, say Address, against some town.

There’s another ‘persons’ table.

What I want to do is to assign a person against a bunch of addresses which share the same town name.

I have made another ‘link’ table, which has a column named town, which is a valid if from the address table - Address[Town]

There’s another column which shows all addresses against the same town.

filter(“Address”, [Town]=[_THISROW].[Town])

Then there’s a person column which is a ref from the person table.

What I want to achieve is to write the person name in the address table against the addresses which are chosen here.

I know that is achieveable by using a referenced action on the rows of the address table. The referenced rows would be the ones that match the addresses with the ones chosen here in the link table.

But I don’t know how to write the person name into that table. If I use a data change action, then I cannot figure out how to use the person name there, which is dynamic and dependent on the link table column.