MRVS line items to create a record in the table

gowthamnena
ServiceNow Employee
ServiceNow Employee

Hi everyone! 👋

I’m working on a ServiceNow Flow Designer use case where In a catalog item I have:

  • A few single catalog variables 
  • A Multi-Row Variable Set (MRVS) with the same fields as the single variables

When a user submits the catalog item:

  • They enter one set of data in the single variables (e.g.,  A)
  • And multiple entries in the MRVS (e.g., B, C, D) 

The goal is to create records in a destination table that includes all entries—both the single variable data (A) and each row from the MRVS (B, C, D)—so that all details are stored in the same table, which has the consistent columns.

 

Currently, only the single-variable data are being processed in the table. The MRVS entries are not being added to the same table.  Any guidance??

 

 

 

6 REPLIES 6

Kieran Anson
Kilo Patron

Can you share how, in your flow, you are creating records in the target table for the single catalog variable? Have you built out the logic to loop over the MRVS and create records?

Thanks for jumping in, Kilo!

At the moment, only the single catalog variable data is being processed and successfully creating a record in the target table. However, the MRVS entries are not being picked up or looped through, so no records are being created for those. I’ve set up a loop in the flow, intending to iterate over the MRVS entries and create records for each, but it seems like the loop isn’t recognizing the MRVS data correctly.

Would you recommend a better way to extract and iterate the MRVS entries along with the Single variables in Flow Designer?

Using Flow is supported, for testing purposes I created the following which gets the variables from the chosen catalog item, and then uses a for-each loop on the 'personal_info' variable set

KieranAnson_0-1761218535125.png

 

Ankur Bawiskar
Tera Patron
Tera Patron

@gowthamnena 

you said you are using loop to iterate MRVS and that's not working.

share screenshots

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