The Zurich release has arrived! Interested in new features and functionalities? Click here for more

How to split Multi-Row Variable Set rows into multiple RITMs for a single Request?

VishwamitraM
Tera Expert

Hi Community,

I have a requirement related to catalog items with a Multi-Row Variable Set (MRVS).

Currently, when a user submits a catalog request that includes multiple rows in the MRVS, ServiceNow creates:
• One Request (REQ), and
• One Request Item (RITM),
with all MRVS rows stored under that single RITM in the sc_multi_row_question_answer table.

Requirement:
For one Request (REQ), I need to generate multiple RITMs — essentially, one RITM per MRVS row.

Example:
• If the MRVS contains 2 rows (e.g., two different order items),
• Then I want the system to create 2 RITMs under the same Request, instead of 1 RITM containing both rows.

Question:
• Is there a standard way to achieve this in ServiceNow?

I’d appreciate any guidance, best practices, or examples from anyone who has implemented this before.

Thanks in advance!

5 REPLIES 5

Rafael Batistot
Kilo Patron

Hi @VishwamitraM 

 

There’s no standard way to split MRVS rows into multiple RITMs.

 

You’ll need either a Flow Designer customization or a Business Rule/script to loop through MRVS rows and programmatically create new RITMs under the same REQ.

Ankur Bawiskar
Tera Patron
Tera Patron

@VishwamitraM 

No OOTB way for this. you will require custom solution

you can use For Each in your main Flow of catalog item and then iterate over MRVS

Then use "Submit Catalog Item Request" flow action to submit those many REQ

Remember you will have multiple REQs for each row, you will have to update the newly created RITM to update the REQ with the parent REQ
I shared solution here in this link on how to do

Create multiple RITM based on data in MRVS using Flow Designer 

submit new ritm based on mrvs and update new RITMs with old REQ.gif

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@VishwamitraM 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Thanks Ankur...I will try this approach and will update you.

 

Regards,

Vishwamitra Manav