Run scheduled flow based on a variable on a RITM record

[AnthonyMull]

Hi community,

I would like to implement the following can you please help?

> Have a catalog item that gathers fields including start date and has a hidden field called COUNTER.

> Once this item is submitted, the COUNTER = 0.

> Every week check have a scheduled flow to check if Start date is more than 1 month ago.

> the flow will check following:
    If COUNTER variable is == 0 and Start Date is more  than 1 month ago send a mail

Is this possible to access variables related to the RITMS in a flow in this way?

[soumyadeep10]

Hey @AnthonyMull ,

Yes, it is possible to access the variables related to a catalog item through an RITM in a flow. I have created a test flow for you to understand.

1. I have done 'look up records'.

2. In RITM, the field 'item' stores the catalog item for which the RITM was submitted, so I have chosen a random catalog item.

3. I have accessed the variables of the catalog item by choosing  ' variables > [the catalog item name] > [choose the catalog item variable] '.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

[AnthonyMull]

Hi @soumyadeep10 

thank you for this, one more follow up, is it possible to update these variables in a flow?

Kind regards

[Ankur Bawiskar · Accepted solution]

@AnthonyMull 

you can access variable value by using Lookup Record flow action

there is no direct action that updates the variables in flow designer and also it is not recommended also. But you can achieve it through the following steps - 

1. Look up record on the sc_item_option_mtom table where 'Parent Item' is 'RITM' and 'Dependent Item.Question.Name' is 'variable name' (which variable's value you need to change) 
2. Then lookup record - 'sc_item_option' with conditions -'sys_id'='Dependent Item.sys_id' (the 1st look up reco record's) 
3. Then Update the last look up record with desire value change - 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏