Get Values out MRVS in a Flow Script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2023 06:27 AM
I have 3 MRVS on a Record Producer
1. i already use Get Catalog Variables
2. i use a for each loop for 2 of the MRVSs
For the 3 MRVS i just need the String Values for a Description Field.
This MRVS has 1 Variable "year".
Maybe user creates 3 rows with values 2017,2018 and 2019.
in one of the for each loops (Step2) i know only need the 2017.2018.2019 as a String in the Description, how can i do this?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2023 11:18 PM
Hello @Meloper,
in your for loop, in each iteration you can update the Description field with the already existing description + the year of the current loop. This way, your Description will look accordingly after each loop iteration. After the last loop the Description will look like required.
1. Loop: --> Description = 2017
2. Loop: --> Description = 2017 2018
3. Loop: -->Description = 2017 2018 2019
Please the following Flow designer screenshot how to achieve this below.
I hope this helped!
Greetings,
Sören
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2023 12:25 AM
Unfortunately, I need the string value inside a fixed text.
i also can't run the MRVS in a for Each.
Because we are already in another For each loop of another MRVS.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2023 11:32 PM
Hi,
Are you using flow to set values?
You can use Record producer script and use below logic to populate description:
var mrvs= producer.mrvs_variable; // access the MRVS variable
var totalRows = mrvs.getRowCount();
var description = '';
for (var i = 0; i < totalRows; i++) {
description = description + mrvs.getRow(i).getCell('year').getCellDisplayValue() +', ';
}
Thanks
Anil Lande
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2023 12:27 AM
no, i dont use the flow only to set value.
I use a for each loop do open a new task for every row in 1 MRVS.
and for each new record created by this loop, if have to set a description.
In this discrption, i need also the values another MRVS, but not row for row.
text + rows form mrvs (,) + text