how to configure wait for condition in flow designer based on state and custom variable value

[Harrys09]

Hi,

i needed some help please as i'm configuring a wait for condition in flow designer where the conditions that must be met are:

1. variable value is Yes 

Or

2. The state is complete

if one of these conditions are met then the the next catalog task will be created.

i have configured this like this so far (see screenshots below):  where i look for the variable from the sc_item_option_mtom (variable ownership) table then i look up the options table to where the sys id of the dependent item of the previous step and then created a wait for condition that waits till the variable value is set to 'Yes' on the catalog task. How could i adapt what i have created so the same wait for condition also works if the state on the catalog task is set to 'closed complete'? Like in first look up action how do I adapt it to also look up the state of the catalog task from the 

sc_item_option_mtom table

i would really value any help on this. Thank you 

Thank you,

Harry

[virchula]

You can use the OOB action called "Get Catalog Variables" for it

[Sanjeet_Choudha]

@Harrys09  you can use available action which gives you variables values of ritm. you dont have to use look up for mtom or option table for values.

Please correct me if I misunderstood.

Thank you

Sanjeet

[Thejashwini]

Hi @Harrys09 

I am configuring a Flow Designer flow where multiple Catalog Tasks (SCTASKs) are created for a Requested Item (RITM).

My requirement is:
The RITM should only move to Completed/Closed once all associated Catalog Tasks are closed.

What I have tried:

• Created Catalog Tasks using multiple conditions
• Used Lookup Records (sc_task) with condition:

  Request Item = RITM

Added a Wait for Condition step with:

Active = false

using the lookup records

Issue:

• The Wait step completes immediately without actually waiting
• RITM gets updated even when tasks are still open

Questions:

1. Does Wait for Condition work dynamically with Lookup Records (collection)?
2. What is the correct way to ensure the flow waits until all SCTASKs are closed?
3. Should this be implemented using:
   • Direct table-based wait on sc_task, OR
   • Loop / Do Until, OR
   • Business Rule instead?

Any guidance or best practices would be appreciated.