Flow Designer script help for update record

[matt_a]

Please could some assist with the following script im wanting to use in flow designer?

var aData = fd_data._6__look_up_records.records;
var aArr = [];
var msg = "This is a test";

if(!aArr.length){
while (aData.next()) {
    aArr.push(aData.getDisplayValue());
}
return aArr.join(', ')
}
else{
    return msg;
};

Following a lookup of records in the flow, I want to push the content of the array into the additional comments. So if the lookup returns items, they successfully post to the comments. But my else isnt working.

Probably something simple im not doing right, but equally, the flow script often throws me!!

[Voona Rohila · Accepted solution]

Hi matt

Try this logic to return else part if there are no records.

var aData = fd_data._6__look_up_records.records;
var aArr = [];
var msg = "This is a test";
​while (aData.next()) {
aArr.push(aData.getDisplayValue());
}
if(aArr.length){
return aArr.join(', ');
}
else
return msg;