Hi guys,
So I've recently made a really basic #Flow for stock level alerts on my org (email alert if stock level field on custom product object, drops below reorder level field). However, I'm having some trouble getting it to only fire once when the stock level first hits reorder threshold, then not again after that, until which time stock is replenished back to above the reorder level.
Probably a really basic thing to fix - I have tried specifying execution "Only if the record that triggered the flow to run is updated to meet the condition requirements", but that seems to stop the flow triggering altogether. I'm also concerned that if I got that to work, would it then no longer fire after the stock gets replenished and eventually runs down to meet the threshold again on the same product record?
Hopefully that makes sense and sorry if these are silly questions!
TIA!
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Depending on your flow, you could update a field in your flow once the email is sent (ie a checkbox that says "below reorder email sent").
This way, you could add an entry condition to only trigger when the box is unchecked and the level is below threshold
Now, you would need another flow for when the levels are above or equal to the threshold AND the checkbox is checked, you would uncheck the box