How do I get list of RITMs for a given REQ in flow designer?

[aryanjain27]

Hi,
I am using a "Look up Record" to get the REQ record. I am able to get that but in the output I do not see anything that says Requested Items. When I go to the REQ record and scroll down, I do see the list of RITMs on it under requested items tab, but how do I get those numbers/their sys ids, in flow designer? If not directly in flow designer, is it possible to create an action and write a script to get that?

Thnx in advance!

[M Iftikhar · Accepted solution]

Hi @aryanjain27 ,

When you look up a REQ (sc_request) record with Look Up Record, you’re only getting the fields from the sc_request table itself. The Requested Items (RITMs) you see on the form are from the related table sc_req_item, which has a reference field request pointing back to sc_request.

Options:

1. Use Look Up Records 

• In Flow Designer, instead of "Look up Record" , use Look up Records.
• Table: sc_req_item
• Condition: request =  map the REQ sys_id you got earlier.
• This will return a list of RITMs for that REQ.
• You can then loop over them using For Each to get each RITM number or sys_id.

---

2. Script Action

Yes, you can create a custom action with a Script step to achieve the same.

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.

[aryanjain27]

When I search the sc_req_table for request=REQxy17 I get this:

The same when I try in the flow designer "look up records":

[M Iftikhar · Accepted solution]

Instead of mapping the data pill to the request number, keep it mapped to the request record itself.

[aryanjain27]

This works like a charm! Thnx a lot!

[M Iftikhar]

Happy to help, keep learning!

[Rafael Batistot]

Hi @aryanjain27 

If you need the list of RITMs, may you try via report, you don’t need flow for it 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0819688