I'm working on the below flow in flow designer where I'm trying to retrieve some records in the 'sysapproval_approver' table:
I'm wanting to write the Name of the Approver field to the work notes of a record that gets created:
I'm using the below code:
var approvers = fd_data._3__look_up_records.records;
var ritmNumber = fd_data.subflow_inputs.ritm.number;
var workNotes = "RITM " + ritmNumber + " approved by:\n";
for (var i = 0; i < approvers.length; i++) {
var name = approvers[i].approver.display_value;
var date = approvers[i].sys_updated_on;
workNotes += "- " + name + " on " + date + "\n";
}
return workNotes;
However, i'm not getting the results I need. I was just wondering if anyone knows where I'm going wrong.
I'm creating the flow in a scoped app.
1 ACCEPTED SOLUTION
this will work
var approvers = fd_data._3__look_up_records.records;
var ritmNumber = fd_data.subflow_inputs.ritm.number;
var workNotes = "RITM " + ritmNumber + " approved by:\n";
while (approvers.next()) {
var name = approvers.approver.getDisplayValue();
var date = approvers.sys_updated_on;
workNotes += "- " + name + " on " + date + "\n";
}
return workNotes;OR Another way
1) you can create a flow variable of type String
2) then use "Set Flow Variables" flow logic to iterate over the approver records and store the details
3) then use this flow variable to set value in work notes
var ritmNumber = fd_data.subflow_inputs.ritm.number;
var ritm = new GlideRecord('sc_req_item');
ritm.addQuery('number', ritmNumber);
ritm.query();
ritm.next();
var workNotes = "RITM " + ritmNumber + " approved by:\n";
var app = new GlideRecord('sysapproval_approver');
app.addQuery('sysapproval', ritm.sys_id);
app.addQuery('state', 'approved');
app.query();
while (app.next()) {
var name = approvers.approver.getDisplayValue();
var date = approvers.sys_updated_on;
workNotes += "- " + name + " on " + date + "\n";
}
return workNotes;
If my response helped please mark it correct and close the thread so that it benefits future readers.
