Does anyone know how I can dot walk sysapproval_approver to sc_cat_item in Flow Designer.

[Traci Wills2]

I have tried AI, but I can't get those instructions to work. (Document ID) is not available.

[palanikumar]

Hello @Traci Wills2 ,

From your screenshot I understand that there is one more step above the Look up record on sc_req_item which is doing look up on sysapproval_approver table (Not sure about the Condition) and this is suppose to be step 1.

Outcome of this step is used in this your step in screenshot.

I have highlighted in below screenshot

[nityabans27]

Hi @Traci Wills2,

1. Look Up Requested Item

   • Use a “Look Up Record” action on the sc_req_item table.

   • Condition: sys_id is [Trigger → Record → Approving (Document ID)] — this fetches the parent Requested Item linked to the approval record.

2. Look Up Catalog Item

   • After getting the Requested Item, use its cat_item field to find the related Catalog Item.

   • Add another “Look Up Record” action targeting the Catalog Item table.

✅ In short:
You’re chaining lookups — first find the Requested Item from the approval’s document ID, then find the Catalog Item from that Requested Item.

[aruncr0122]

Hi @Traci Wills2 ,

You can follow below approach : 

Trigger: Approval [sysapproval_approver] > Created (or Updated, if re-running on state changes).
Look Up Records (First): Table = Requested Item [sc_req_item]

Conditions: sys_id is dynamic: ${trigger.record.document_id}
This grabs the parent RITM.

Look Up Records (Second): Table = Catalog Item [sc_cat_item]

Conditions: sys_id is dynamic: ${previous_step.cat_item} (from the RITM lookup output)
Output: Now you have the full sc_cat_item record to use downstream (e.g., for conditions, updates, or notifications).

If you need to reference specific fields from the catalog item (like name or short description), just pill them from the second lookup's output.

NOTE : The document ID is the field Approving in sysapproval_approver table.

Thanks