How do I get the display value of a MRVS variable?

donnadavis
Tera Expert

Hello, I have a Flow Designer flow that has an MRVS.  I get the MRVS data through the Get Catalog variables.  I am trying to send an email in the flow  and the body of the email needs to contain some of the data from the MRVS. I am executing a For Each action and used the data pill to include the MRVS data in the body of the email.  However, it is only retrieving the sys_id.  How do I get the display values for the variables in the MRVS? 

This is what is showing in the email body:

Donna Davis  is requesting access to  a72ebcd71b1434901c274377cc4bcb64.

Thanks

6 REPLIES 6

Nick Parsons
Mega Sage

Given a row, that you can obtain by using mrvs.getRow(i) while iterating of your MRVS, you can obtain the diplsay value of a field using this helper function I wrote:

 

 

// returns the cell display value given the field name, otherwise it returns an empty string if the field doesn't exist
function getCellDisplayValue(row, fieldName) {
	var cells = row.getCells();
	for(var i = 0; i < cells.length; i++) {
		var cell = cells[i];
		if(cell.getName() === fieldName) {
			return cell.getCellDisplayValue();
		}
	}
	return "";
}
// Usage:
var row = mrvs.getRow(i); 
var foo = getCellDisplayValue(row, "foo"); // gets the display value of the `foo` field

 

 

 

Meloper
Kilo Sage

Hi, do you have an Solution for this?
instead of Using a GR?