Access RITM variables in 'For Each' section of flow designer

[Lisa Conn]

Hello Experts,

I have a RITM with date variables “Start” and “End”. The requirement is to send an email notification to the requestor 30 days before the “End” to remind them to renew the request. I have created a flow that runs on a trigger of Daily that looks up records in the sc_req_item table based on the “End”variable, and does a 'for each item' to send an email. I would like to provide the “End” variable in the body of the mail as this is useful information for the recipient, but there is no data pill option to add RITM variables in the “for each” section of the flow designer. Has anyone had a similar situation and found a solution?

Thanks!

[Shane41 · Accepted solution]

Hi Lisa,

Have you tried using the get catalog variables action. If the requested items are based on the same item this could be a good option

This will add variable data pills that you can use in your flow

 

Hope this helps,

Shane

 

[Lisa Conn]

Hi Shane,

I tried that but I wasn't putting the Get Catalog Variables in the for each loop so it wasn't working. Once I moved it in the for each loop as in your image, it worked like a charm! Thank you so much for your help, I really appreciate it!

Lisa