Need help with Multi-row variable set (MVS) use in Flow Designer.

[Jessica28]

Hello,

I'm really need the community to help on this issue. I've spent days trying to figure out a solution, but so far no luck.

I have a Service Request with MVS that contains 2 variables (Add Additional Requestor and Asset Tag).

In the Flow Designer, I looped through the MVS and create tasks for each requestors. I would like to have each Requestor Name and Asset Tag displays on the Short Description field for task so that the Assignment Group can know which task belongs which requestor. 

I'm encountering an issue where the short description contains Sys_id numbers instead of the requestor name.

Is it possible to shows the Requestor Name and Asset Tag that were on the MVS?  If not, please provide suggestions how to capture the information separately each task.

Thank you.

[Mark Roethof]

Hi there,

I tried to simulate. What I noticed is that the reference is actually shown as string:

Userrr should be a reference in my example. While if we query MRVS in business rules, etc, then you could just get the display value.

Interesting case. I'll have some more thinking on this.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020, 2021 ServiceNow Community MVP
2020, 2021 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[Jessica28]

I'm totally lost and stressed out on this issue. Please help.

Thank you so much!

[Mark Roethof]

If it's urgent, as workaround you could obviously lookup the sys_id using look up record. It's not a pretty workaround, though for short notice it will work.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020, 2021 ServiceNow Community MVP
2020, 2021 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[Jessica28]

It is not an urgent Mark. I'm stressing out, because I have not able to find an answer on the web and it is possible that this can not be done.  I came across some of Ankur Bawiskar's posting where he was using inline script I think.  I tried that, but no luck of getting it to work.

Many thank to you and another for helping.

[Mark Roethof]

Well because it clearly shows string, I doubt if it works. I also tested using inline script, with .getDisplayValue(), .getCellDisplayValue(), .getValue()

All don't work.

Can you share the post you are mentioning?

You could obviously also create a Support Case for this. Maybe they can confirm that this is a known thing, does not work, is planned for San Diego, or that there's a nice undocumented trick for this.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020, 2021 ServiceNow Community MVP
2020, 2021 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list