How to split Multi-Row Variable Set rows into multiple RITMs for a single Request?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
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
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
Thanks Ankur...I will try this approach and will update you.
Regards,
Vishwamitra Manav