Add field to E-Mail Notification for a Catalog Itme

[Matt_EpiQ]

Building custom email for notification after a Service Catalog item has been submitted and approved.  I can't get the item name selected as part of the email.  I have tried dot walking etc but have no idea what the name of the catalog item selected is.

[Najmuddin Mohd · Accepted solution]

Hello @Matt_EpiQ ,

I believe the flow is configured for this Catalog item using Flow Designer or Workflow.
You have an OOB action 'Send Email', from which you can send email and you can reference the values.

Alternative, you can trigger an event and pass the parameters and use them in the Email.


If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

[jMarshal · Accepted solution]

Hi @Matt_EpiQ -- it looks as though you have this configured to trigger on the REQ (sc_request) table ("Request ID" is a variable represented by ${number} in your notification)...if this is the case, you need a mailscript to accomplish this. The REQ doesn't contain information related to the item and you can't dot-walk to it, because there are no fields on the REQ table to dot-walk from. You need to write a mailscript that will glide to the RITM table (sc_req_item) and query on req_item.request=number.

Another option would be to build your email notification from the RITM table and dot-walk to the approval date (request.approval_set) and approved by (request.requested_for.manager) info...but you can access catalog item directly as ${cat_item} as that is a field on RITM, but not on REQ.

Please double-check field names, but that should get you going in the right direction. Please mark as helpful/correct solution, if appropriate. Thanks in advance!

[Najmuddin Mohd · Accepted solution]

Hello @Matt_EpiQ ,

I believe the flow is configured for this Catalog item using Flow Designer or Workflow.
You have an OOB action 'Send Email', from which you can send email and you can reference the values.

Alternative, you can trigger an event and pass the parameters and use them in the Email.


If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

[jMarshal · Accepted solution]

Hi @Matt_EpiQ -- it looks as though you have this configured to trigger on the REQ (sc_request) table ("Request ID" is a variable represented by ${number} in your notification)...if this is the case, you need a mailscript to accomplish this. The REQ doesn't contain information related to the item and you can't dot-walk to it, because there are no fields on the REQ table to dot-walk from. You need to write a mailscript that will glide to the RITM table (sc_req_item) and query on req_item.request=number.

Another option would be to build your email notification from the RITM table and dot-walk to the approval date (request.approval_set) and approved by (request.requested_for.manager) info...but you can access catalog item directly as ${cat_item} as that is a field on RITM, but not on REQ.

Please double-check field names, but that should get you going in the right direction. Please mark as helpful/correct solution, if appropriate. Thanks in advance!

[Matt_EpiQ]

Thank you will try

[Pavan Angadi · Accepted solution]

Hi  @Matt_EpiQ 

Could you please confirm which table you have configured the notification on?

Thank you,
Pavan