MRVS: Dot-Walking in Flow Designer

[Wasdom_Kung]

Hello,

I currently have a MRVS that is used to allow a customer to provide multiple asset details, including their location which is a reference to the cmn_location table. 

With this information, the flow should loop through each asset provided and create a catalog task to the relevant assignment group based on the location.region value, for example, location 1 might have region EAST and this region will have an assigned assignment group.

However, when looking at the variables that are a part of the MRVS in flow designer, they cannot be expanded to show other fields, for example, expanding location data pill outside of the flow logic shows all related columns/rows for this, but cannot be expanded within the MRVS.

e.g. the variable "Location asset is used from" is a reference to cmn_location, but cannot be expanded to add the location.region value into the logic.

Any advice to achieve this?

[SANDEEP28]

@Wasdom_Kung Unfortunately, its the limitation of flow designer. I also faced similar situation in past. As a workaround I added one more step of lookup record to get the detail of that reference variable.

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

[Wasdom_Kung]

Hi Sandeep,

Thanks for then information - when using a lookup record action, I can't seem to view any of the MRVS - do

you have an example at all?

Edit: I see the table that the MRVS are stored in actually, just need to work out how to get it to actually work 😄

Thanks!

[Ankur Bawiskar]

@Wasdom_Kung 

you need to handle this via custom script action.

[Wasdom_Kung · Accepted solution]

I managed this without custom actions or scripts.

I created a hidden field on the form that used the auto-populate functionality to pull the region of the location from the selected choice table, and then using that value with the for each loop which works without issue.