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

matthew_hughes · 3 weeks ago

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:

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

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:

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

Records created:

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

Rafael Batistot · a week ago

Hi @matthew_hughes

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

If this response was helpful, please mark it as Helpful and, if applicable, as Correct.
This helps other users find accurate and useful information more easily

GlideEdward · a week ago

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