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

Jacob Saaby Nie
Tera Contributor

Hi everyone.

So I have a catalog item. In that, I'm using some multi row variable sets. That all works just fine.

However, in my flow I would like to be able to get a list of what people actually ordered. Those things are in that multi row variable set.

What I want to do is get the elements in the mrvs, so I can write out the variable choice names in an email, and then send that.

Can any of you help me figure out how to do that? I'm pretty proficient in Flow Designer, just not code 😉 

1 ACCEPTED SOLUTION

Hitoshi Ozawa
Giga Sage
Giga Sage

Hi Jacob,

Flow Designer supports mrvs. To get each row, use "For Each Item in"

Example:

find_real_file.png

find_real_file.png

find_real_file.png

View solution in original post

10 REPLIES 10

Hey @Hitoshi Ozawa 

Thanks. Yeah, I get that far as well.

But as in your picture, the object and the columns are greyed out, so how do I actually use them in Flow Designer?

Oh, I've got it now. I was checking under the get catalog variables, not under the for each. As soon as I unfold the for each object, I'm fully able to get the values from the variable array.

Thanks 🙂 

@Hitoshi Ozawa unable to drag that columns name to approval 

Jacob Saaby Nie
Tera Contributor

Ok @Allen Andreas and @Hitoshi Ozawa 

Bonus question!

Iterating using a for each in the flow will give me the variable value. But not the variable text. I've tried the following, but that doesn't work. Neither does using getDisplayValue();.

Do any of you know how to get the "Text" part of that choice?

fd_data.trigger.request_item.description = fd_data.trigger.request_item.description + "Sandwich: " + fd_data._4__for_each.item.sandwich.text + " - " + "Bestilles til dato: " + fd_data._4__for_each.item.bestil_til_dato_sandwich + "\n";

ArnasD
Tera Contributor

Hi Jacob, did you find solution for getting DisplayValues  from MRVS in flow designer?