Approval Rejection reason in notification email

spike
Mega Sage

I'm designing my own work flow in Flow Designer to manage a multilayer approval process for a catalog item. I'm not using the step based fulfillment as I want to do extra stuff as part of the flow.

One thing I'd like to do is send an email to the requestor if their request is rejected. While I can do this easily with the Send Email action, there are some constraints: 1. There are multiple points where this can happen and 2. I want to put the rejection reason in the email.

Point 1 and I think I can resolve by creating a notification against the item table and then triggering that notification (I really only want to configure the email once - code reuse and all that).

What I can't seem to do is point 2. I can find no way to put the rejection reason into the email. I've tried messing with the notification but I can't seem to find where the information is stored. And when I do find some related information (although not found the rejection comment, just the fact it's been rejected) I can't attach the notification to the flow (I think because the notification is then on the Approval table and not the Request table.)

I just don't what to do! Some, or any(!), direction would be much appreciated!

4 REPLIES 4

bammar
Kilo Sage
Kilo Sage

When the user rejects using email they can provide text in the response- they can also provide a comment when rejecting from within system- now getting that reason may be tough as especially via email you can not provide it. 

You would grab that value by going to the comments of the Rejected Approval Record.

Also - If the item gets rejected you can put in the email the name of the stakholder that rejected it and if the person needs more explanation find out from them. 

Tony Kim
Tera Expert

I was able to make it work in Flow designer by lookup up the sysapproval_approver table and using the condition of "approving" is the "Trigger - Requested item" data pill.  Then send an email action and using the "approval records - comments" data pill. 

 

This allowed me to pull the comments from the rejection into the email/flow without scripting anything. 

TonyKim_0-1677868409141.png

TonyKim_1-1677868463068.png

 

@Tony Kim 

This helped me to catch Approval and Rejection comments in the 'Send Email' action of Flow Designer.

 

Thanks

Thanks @Tony Kim!!!  You just saved me a ton of frustration and fruitless work!  😄