Update Approval Request : did not create or update sysapproval_approver using current - from the logs

Ramel
Mega Guru

Hi Community,

I am trying to implement an approval via email but the OOB inbound action does not seem to be working. In the logs I can see this message - Update Approval Request : did not create or update sysapproval_approver using current, then after sending the approval via email, it is being received and I can see it from the approval logs but the script in the OOB inbound action does not do anything. The approval state remains requested but based on the script in the OOB Update Approval Request inbound action once 'approve' it should change the state to approved or reject when rejected.

Anyone had encountered the same issue? Need your advise. Thank you.


Regards,

Ramel

1 ACCEPTED SOLUTION

Arkesh Kumar
Giga Guru

#Inbound actions to record action (written on change_task, record_action , reply)


condtion : email.subject.indexOf("autoclose") >= 0 // checks email subject for autoclose keyword

Action script:

if (current.getTableName() == "change_task") {
if (validUser()) {
current.work_notes = "reply from: " + email.from + "\n\n" + email.body_text;

// if it's been cancelled, or completed already it won't update
var doit = true;
if (current.state == '3' || current.state == '4' || current.state == '5' || current.state == '6' || current.state == '7')
doit = false;

if (email.subject.indexOf("Closed Complete") >= 0) // checks email subject for closed complete keyword
{
current.close_notes = email.body_text;
current.state = '3';
}
if (email.subject.indexOf("Closed Incomplete") >= 0) // checks email subject for closed Incomplete keyword
{
current.close_notes = email.body_text;
current.state = '4';
}
if (email.subject.indexOf("Closed Cancelled") >= 0) // checks email subject for closed cancelled keyword
{
current.close_notes = email.body_text;
current.state = '5'; 
}
if (email.subject.indexOf("Closed Complete with Issues") >= 0) // checks email subject for closed complete with issues keyword
{
current.close_notes = email.body_text;
current.state = '6';
}
if (email.subject.indexOf("Closed and Failed") >= 0) // checks email subject for Closed and Failed keyword
{
current.close_notes = email.body_text;
current.state = '7';
}

if (doit) {
current.update();
} else {
gs.log("Update for Change Task ("+current.number + ") failed. Details: Invalid state. Task can only be updated if state is not already completed or cancelled");
}
} else {
gs.log("Update for Change Task ("+current.number + ") failed. Details: invalid user. Task can only be updated by the assignee, not " +email.from );
}
}

function validUser() {

var user = email.from_sys_id;
var ourUser = gs.getUser();
ourUser = ourUser.getUserByID(user);
ourUser.isMemberOf(current.assignment_group);

if(ourUser)
{
return true;
}

else if (current.assigned_to == email.from_sys_id)
{
return true;
}
}

 

Now go to templates under system notification and create records as below

find_real_file.png

 

Go to notification and link template

find_real_file.png

{$mailto:<template_name>} is the format to link template to notification

 

 Change above data as per your convenience. Presently it is in change_task table. and do action based on email subject from user who is the member of the assignment group of change task.

Thank you,

Arkesh

View solution in original post

28 REPLIES 28

Anil Lande
Kilo Patron

Hi,

Can you please share your email subject and body which you are sending to ServiceNow for approval?

 

Thanks,

Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

To process approval, your subject must contain approve or reject word. Also the sender should be valid approver. Then only it approves request.

 

Thanks,
Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Hi Anil,

The subject contains the ticket number and the word 'approve' or 'reject'.

Regards,

Ramel

Can you please share email logs and your inbound email action script?

 

Thanks,

Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande