Update multiple related rows data

[JohnYuen]

Hi Eveyrone, 

I have a problem cannot be solved by my tiny head as shown below: 

I have 2 tables "Relocation" and "Inventory"

Inventory is a database to store product data, and Relocation works as a form for me to submit and update the inventory. 

As you can see the example data of the inventory, my products happen to have multiple barcodes so i separate the products by barcodes (2 barcodes, 2 rows; 3 barcodes, 3 rows, etc.)

I created two actions as shown below: 

full formula of the Trigger - SELECT(Inventory[Barcode], [YuensCode] = [_THISROW].[YuensCode])

both actions run perfectly, but the headache is about the location it updated to my database if you look back to the Inventory example data... 

the "Relocation" table will definitely have lots of rows which contain old and new ones. Now i only have two rows, and in the inventory, the PrimaryLocation of "John123" turns to have both data of Relocation. 

I tested myself, the PrimaryLocation of John123 in Inventory will only append instead of replace the PrimaryLocation. 

What should i do?

What I want to do is everytime i submit a new location to update, the automation will replace the PrimaryLocation with NewPrimaryLocation for all related product (All John123's PrimaryLocation will be update to the submitted one, and will only have 1 PrimaryLocation). 

[Tommy62]

Ohne vollständig herausgefunden zu haben, was Sie wollen.

Versuchen Sie es mit "Setzen Sie diese Spalte" in der letzten Abbildung Primärer Standort = [Neuer primärer Standort].

[JohnYuen]

Thanks for the reply, appreciate it. 

What i really need is to update multiple rows in inventory when submitting the form (Relocation). 

I have tried the PrimaryLocation = Relocation[NewPrimaryLocation] and it works. However, it is not replacing the old PrimaryLocation with New one, but instead it adds into the cell.