Modify Rows by Matching Lookup Values / Inventory Management / Action Modify Row .Filter

My scenario is as follows:

I have Table A with two rows whose values are:

  • Banana
  • Orange

It uses a second column to tell me the number of each fruit I need

I have Table B which has two columns

  • Quantity (a number)
  • Fruit (a lookup field listing Table A fruit option)

I wish to add TableB.Quantity to TableA.FruitNumber of the appropriate fruit chosen from the lookup field TableB.Fruit. I would think that a button with the function of Modify Rows>Filter>+TableB.Quantity would work, but it does not. Can anyone share some formula that I can use to tackle this.

Here’s the formula that i’ve tried - it gives me no errors, but will only alert me “No action taken” when I press the button.

ModifyRows(Filter(TableB, thisRow.[Fruit]=[Fruit Type]), TableB,[Number of Fruit], +thisRow.[Quantity])