MRVS Iterate in flow designer issue

Shekhar Deshin1
Mega Guru

@Ankur Bawiskar 

Flow Designer to create or update the alm hardware record from MRVS.

Model - Ref 

Model Category - ref

 

1.I am taking reference data in MRVS to add the asset details for Model and Model Category from (Product model - cmdb_model) and Model category from cmdb_model_category).user will add this data in MRVS.

2.I am trying to create the record in alm_hardware table for above field details which is coming from MRVS.

Model,Model Category,Serial Number,Asset tag create or update in alm_hardware table.

3.I have added "For each" for MRVS variables and trying to iterate the data.

4.after for each i am adding "lookup record" to getting sys_id of Model (from MRVS).

5.After running the flow it is creating 1 record in alm hardware table how i can create multiple record coming from MRVS data.

 

While run time logs i am getting MRVS data suppose if i added 3 model in MRVS it is showing 3 record in run time values in flow execution logs.However it is create the record only for 1st record and other 2 in flow logs it shows not run.

 

Please suggest please find the attachment of initial flow add.I am not getting where i am making mistake.

Thanks,

Shekhar,

 

 

1 ACCEPTED SOLUTION

@Ankur Bawiskar @Bhimashankar H 

Thanks for your help on this issue however in the Action number 13 i was added End Flow so it was taking only 1 record and end the flow.

When i removed End Flow from that line it is working fine for all the record iterate.

my issue is resolved.

Thanks for your support.

 

View solution in original post

6 REPLIES 6

Bhimashankar H
Mega Sage

Hi @Shekhar Deshin1 ,

 

You need to process each of those rows from MRVS, you can do that with the action "Get Catalog Variables".  This action allows you choose the main catalog item and select the variables which you wish to use in your flow. You might be missing action "Get Catalog Variables" in your flow.

 

Please go through the below article it explains how to iterate MVRS in fd with screenshot.

How to Use Multirow Variable Sets (MRVS) in Flow Designer 

How do I iterate through a multi row variable set in Flow Designer? 

 

I hope that helps

 

Thanks,
Bhimashankar H

 

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

Ankur Bawiskar
Tera Patron
Tera Patron

@Shekhar Deshin1 

you are iterating MRVS and then using lookup

is the MRVS loop running 3 times?

what did Lookup Record give as outcome for the other 2 executions?

share some more screenshots.

Please add screenshots directly in post rather than adding as attachment

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

Here is the flow screen shot:

ShekharDeshin1_0-1756795440603.pngShekharDeshin1_1-1756795647938.png

In the action number 10 i am looping for sys_id condition and taking Model from MRVS:

ShekharDeshin1_2-1756795739101.png

 

you are iterating MRVS and then using lookup - YES

is the MRVS loop running 3 times? - Yes

what did Lookup Record give as outcome for the other 2 executions? - 3 records

 

ShekharDeshin1_3-1756797454995.png

 

2nd Execution not run

 

ShekharDeshin1_4-1756797516824.png

 

THanks,

 

 

 

@Shekhar Deshin1 

it's strange

any error in the last execution i.e. 1st iteration?

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