Flow Designer - Create RITM for an asset when stockroom quantity goes below threshold

[JordanDR]

Hi community,

In the current flow were able to set a condition for the trigger for when the quantity of an item in the stock room changes to a certain number. However, is there a way to set the condition for when the quantity of the item goes BELOW a certain number? There is an option for this in the generic filters so is it possible this could be scripted?

[Allen Andreas]

Hi,

You should have access to the "greater than" or "less than" operators when working with a quantity type field (as it should be integer). So you wouldn't need to script that. Have you tried within a flow trigger condition to look at the quantity field and do you see other operators available that could work for you?

[JordanDR]

Thanks for your response Allen!

This was what I was initially leaning toward but the RITM would be created every time the quantity falls below the number. So if I set the threshold to 3, the RITM would be created when it hits 2, and then again when it hits 1

[Allen Andreas]

Hello @JordanDR 

When you said this: "This was what I was initially leaning toward but the RITM would be created every time the quantity falls below the number. So if I set the threshold to 3, the RITM would be created when it hits 2, and then again when it hits 1"

Did you actually test that or you're just thinking that will happen?

If the flow is meant to run more than once, then you'd use a different "Run Trigger" option than "once".

Then you'd add another condition to it such as less than 4 AND greater than 2, thus you narrow it to 3 or ...you'd use is 3. We are unsure the specifics, but you can use the condition builder as appropriate to solve this without script. Please try using the condition builder and creatively working through the requirement. I've given a few examples here, but again, we don't know the specifics.

The same issue would be spoken about if this was done by script, so we're still not in territory where it has to be done via script.

You'd want to think through when this should trigger and then consider updating the trigger record state to "on order" if that's what you're doing with this RITM. Then, you can use that in your flow as well instead and do less than 3 and state is not "on order".

[jcmings]

Yes. You should be able to select is less than in the filter condition. Can you share a screenshot of the current configuration?