Iterate a list in a flow action

[cbarlock]

I have a "Project" table that has a column called "Policies" that is a List of "Policy".  I wrote a flow whose trigger is the creation of a new Project.  The flow passes Trigger->Project Record->Policies to an action.  This action has an input named "policies" that is of type "List.Policy".  A script projects this list:

(function execute(inputs, outputs) {
    var policies = inputs.policies;
    outputs.policy_names = '';
    while (policies.next()) {
        outputs.policy_names += '<br/>' + policies.getDisplayValue();
    }
})(inputs, outputs);

This works fine if the list contains two or more policies, but if there is only one, no policy names are generated.  What am I doing wrong?

Thanks!

[bishopx · Accepted solution]

You are doing nothing wrong. This is known issue I have reported this to HI more than 8 months ago.
Still not answer on when it will be fixed. Seems it's not really a priority for ServiceNow team.

You need to the manual workaround:

if(inputs.policies.getRowCount() == 1){
  gs.info(inputs.policies);
}
else{
  while(inputs.policies.next()){
    gs.info(inputs.policies);
  }
}

Hope that helps

Jozef

[Ankur Bawiskar]

Hi Chris,

you will have to convert the array of String to Array

please check below links for help

How to iterate an Array.String in the flow designer?

Flow Designer Foreach loop on Service Catalog List Collector variable type not identified as record ...

Regards
Ankur

[cbarlock]

Thank you both!

[Ankur Bawiskar]

Hi Chris,

So what was the solution/workaround

Regards
Ankur