Dotwalk using script in flow designer

[ss123]

Hi All,

Can anyone assist on this?

I need to dotwalk a user's network id from a MRVS and populate it on the create record in flow designer. 

this is my script but seems not working.

var accountID = fd_data._12__for_each.item.user_s_or_group_s_to_be_added_or_modified.u_network_id;

return accountID;

I need to get/dotwalk the Network ID [u_network_id] of the user from the MRVS.

  Thanks!!

[Dnyaneshwaree]

Hello @ss123 ,

Try this script if useful:

var mrvsSize = fd_data.mvrs_field; // add the MRVS field name

var accountID = '';
if (mrvsSize && mrvsSize.length > 0) {
for (var i = 0; i < mrvsSize.length; i++) {
var size = mrvsSize[i];
accountID = row.user_s_or_group_s_to_be_added_or_modified.u_network_id;
// If only first network ID needed, then use break here
break;
}
}

return accountID;

[OlaN]

Hi,

The issue here is that the values stored in the MRVS are strings (of sysID to the table you're referencing), so you cannot dot-walk directly.

You can work around this by doing a lookup record on the value in the MRVS, and after you've retrieved the record, you can dot-walk further (either in dotwalking the data directly in action selection, or by scripting).

[ss123]

Hi @OlaN thanks for this info.

Can you help how to do it with the look up record? 

Thanks.

[OlaN · Accepted solution]

Basically you should just need to select which table to look up (the table you're referencing in the MRVS).

Then as condition, select sysID is equal to -> Data picker to get the value of the for-each-value of your specific MRVS variable.