How do I get the display value of a MRVS variable?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2021 12:43 PM
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
- Labels:
-
flow designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-06-2022 08:12 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2023 10:23 PM
Hi, do you have an Solution for this?
instead of Using a GR?