Send an email when Incoming Quantity = Absolute Value of Variant Inventory Quantity?

Is this possible?

  • Trigger: Inventory Quantity Changed
  • Condition: Incoming Inventory = Absolute Value of Variant Inventory Quantity
  • Action: Send an Email

I need the Variant Inventory Quantity to be an absolute value because our products usually have negative inventory from Pre-Orders.

Basically how we want it to work is—the inventory that’s coming in needs to match up with the number of Pre-Orders for the item that triggered the Flow.

I’m also open to any workarounds. :slightly_smiling_face:

The trigger does not show you “incoming” inventory but rather the current (and prior) quantities for the product variant. If the prior quantity was -3 and incoming is 3, then the quantity would be 0. So can’t you just check if the quantity went from negative (the “prior”) to 0 (current)?

Hi, @paul_n thanks for your reply!

I tried your suggestion just now and this is what I got:

I set the “Incoming Inventory” to 0 quantity, but when I checked the run log, Flow captured only the incoming inventory, not both current & prior inventory. But I don’t know if I was able to understand your suggestion correctly—if what I did was wrong, please clarify.

What I was attempting previously looks like:

And then, the conditions by which Flow should send an email looks like:

Your thoughts? How can I get this to happen?

Have you solved this problem now?