How to get the value of a Department record from a Multi Row Variable Set

matthew_hughes
Kilo Sage

I'm developing catalogue item to create records in our custom table 'u_m2m_depts_config_items'. So it's records that consist of a business application and a department record. I'm using a multi row variable set in my catalogue item to collect the list of consumers:

matthew_hughes_0-1782739418588.png

 

 

This is my multi row variable set in the back end of ServiceNow:

matthew_hughes_1-1782739494390.png

 

What I'm struggling with is getting the value of the consumer_organisation for each row in my Multi Row Variable Set. I'm trying to implement the below step in my flow:

matthew_hughes_2-1782739577626.png

 

matthew_hughes_3-1782739607657.png

 

matthew_hughes_4-1782739657471.png

 

At the moment, when new records in our custom table 'u_m2m_depts_config_items' get created, the following is happening:

matthew_hughes_5-1782739763550.png

matthew_hughes_6-1782739884241.png

 

Records created:

matthew_hughes_7-1782739989442.png

 

If anyone has seen this issue before or knows what I need to do, that would be much appreciated



 

2 REPLIES 2

Rafael Batistot
Mega Patron

Hi @matthew_hughes 

 


Kindly share the output values of your flow before insert the table 

 

GlideEdward
Tera Contributor

I highly suspect it's because the MRVS object is not compatible with Flow Designers concept of an Object. I frequently run into issues like these.

 

The answer is almost always going to be that you need to create a custom scripted flow action which will:

1) Take your RITM as an input

2) Output the Array.Object that you need to iterate through to create your m2m records in the latter part of the Flow