Email is unable to retrieve attribute value from request form

[ApacheT101]

Hi Support,

Currently we want our email to retrieve the info of the request and demonstrate to the approver. However, the email is unable to retrieve the value from request form (except first name and cost center). 

This is screenshot of form atrributes:

Not sure why some values (fullname, costcenterdesc, etc) are not retrieving.

Thanks in advance!

[This message has been edited by moderator to mask sensitive information]

[NM]

Hi @ApacheT101 is this user update form?

What error do you see?

[ApacheT101]

Hi,

This is create user request form.

[rushikeshvartak]

Please validate supported variables.

Purpose :

To get what variables are present to use in the email template.

Email Template steps :

keep Advanced HTML CSS flag is checked

Keep your email Address in TO

TO /CC/BCC & Subject - Don't use any dynamic variables

Add only below code in Email Body
${this.binding.variables.each {RVkey,RVvalue -> println "$RVkey ------- $RVvalue" + "" + "br" + ">"}}

Output : using the below expression. By putting it in the email body, it will print all variable names with values, and then accordingly, you can use it:

[ApacheT101]

Hi here is the output, I do not see any dynamic attributes inside the result.

[rushikeshvartak]

Share in text format 

Or enlarge image https://forums.saviynt.com/t5/forum-feedback/enlarge-image-by-default/m-p/96947

[ApacheT101]

Hi @rushikeshvartak,

ServiceAccountOwnerMap ------- [:]br> entitlements ------- []br> accessapprovers ------- com.saviynt.ecm.workflow.Access_Approvers : 84664br> jbpm_activity_name ------- Verifierbr> allApproversComments ------- nullbr> fullrowhtmltablerows ------- br> listofallrolesinrequest ------- []br> approvedEntitlementsOwners ------- []br> entitlementshtmltablerowsv2 ------- br> entitlementshtmltablerowsv3 ------- br> ServiceAccountType ------- br> requestlink ------- null/jbpmworkflowmanagement/showrequestdetails/TPAG_Workflowfinal2.1542541?reqid=2673br> allRejectorsComments ------- nullbr> rolesApprovedOrRejected ------- []br> rolename ------- br> request_access ------- com.saviynt.ecm.workflow.Request_Access : 3892br> users ------- adminbr> allRejectors ------- []br> requestid ------- 1542541br> rolemap ------- [:]br> baseUrlForEmail ------- ,[URL]br> assignee ------- 84000000br> activityname ------- Verifierbr> ServiceAccountFlag ------- falsebr> request ------- com.saviynt.ecm.workflow.ARS_Requests : 2673br> exceptionCount ------- 0br> fullhtmlassignedrows ------- br> requestkey ------- 1542541br> rejectedEntitlementsOwners ------- []br> roles ------- nullbr> rejectedByMap ------- [:]br> out ------- java.io.PrintWriter@1723bd5fbr> requestedby ------- alexanderbr> assigneemanager ------- adminbr> requesttype ------- br> dynamicAttrsList ------- []br> approvallink ------- null/jbpmworkflowmanagement/showrequestdetails/TPAG_Workflowfinal2.1542541br> allrolesinrequest ------- br> email ------- [my_email]br> endpoints ------- ()br> entitlementshtmltablerows ------- br> rolesshtmltablerows ------- br> manager ------- adminbr> approvedByMap ------- [:]br> entitlement_values ------- []br> allApprovers ------- []br> requestor ------- alexanderbr> accounts ------- []br> user ------- adminbr> curExecutionId ------- TPAG_Workflowfinal2.1542541br> accessItems ------- [com.saviynt.ecm.workflow.Request_Access : 3892]br> [ServiceAccountOwnerMap:[:], entitlements:[], accessapprovers:com.saviynt.ecm.workflow.Access_Approvers : 84664, jbpm_activity_name:Verifier, allApproversComments:null, fullrowhtmltablerows:, listofallrolesinrequest:[], approvedEntitlementsOwners:[], entitlementshtmltablerowsv2:, entitlementshtmltablerowsv3:, ServiceAccountType:, requestlink:null/jbpmworkflowmanagement/showrequestdetails/TPAG_Workflowfinal2.1542541?reqid=2673, allRejectorsComments:null, rolesApprovedOrRejected:[], rolename:, request_access:com.saviynt.ecm.workflow.Request_Access : 3892, users:admin, allRejectors:[], requestid:1542541, rolemap:[:], baseUrlForEmail:[URL], assignee:84000000, activityname:Verifier, ServiceAccountFlag:false, request:com.saviynt.ecm.workflow.ARS_Requests : 2673, exceptionCount:0, fullhtmlassignedrows:, requestkey:1542541, rejectedEntitlementsOwners:[], roles:null, rejectedByMap:[:], out:java.io.PrintWriter@1723bd5f, requestedby:alexander, assigneemanager:admin, requesttype:, dynamicAttrsList:[], approvallink:null/jbpmworkflowmanagement/showrequestdetails/TPAG_Workflowfinal2.1542541, allrolesinrequest:, email:[my_email], endpoints:(), entitlementshtmltablerows:, rolesshtmltablerows:, manager:admin, approvedByMap:[:], entitlement_values:[], allApprovers:[], requestor:alexander, accounts:[], user:admin, curExecutionId:TPAG_Workflowfinal2.1542541, accessItems:[com.saviynt.ecm.workflow.Request_Access : 3892]]

[Raghu]

@ApacheT101  share Email template ? and Dynamic attributes properly mapped ? not able see column name in above screenshot share clearly

[ApacheT101]

Hi @Raghu,

Sorry for the late response. Here is the code of email template. I also shared the screenshot of dynamic attributes.

Thanks in advance.

[NM]

@ApacheT101 try by removing dynamic attribute from subject

[ApacheT101]

HI @NM,

I have changed the subject to "testing" but the result is same as the one I had shared with Stalluri.

[rushikeshvartak]

Does dynamic attribute value get stored in the accounts column?

[ApacheT101]

May I know how to verify whether dynamic attribute are stored in accounts column? For your information, this form is used for creating user like contractor, so I am not sure whether these values are saved in accounts column after I submitted the form. After submitted the form, it will route to verifier for approval and the system will send email for notification. Hence, I want to populate those values inside the request form.

[rushikeshvartak]

It will be stored in users attribute then

[ApacheT101]

I see, it is still going to be in users customproperty? Since the request has yet to be finished, I thought users attribute will not work because the values have not been saved in the users table before finish the workflow process. 

[rushikeshvartak]

Did you used users column ?

[ApacheT101]

Yeah , I use users custom property in dynamic attributes to save value in users profile once the workflow is finished. Tmr I will try to get value from {users.customproperty}

[stalluri]

@ApacheT101 
Can you share the output of the below email response?

TO : Hardcode your Email address.

CC/BCC & Subject: Don't use dynamic variables.

Add only below code in Email Body:

${this.binding.variables.each {STkey, STvalue -> println "<div style='margin-left:20px;'><strong>$STkey</strong>: $STvalue</div><br>"}}


Make sure you enlarge the image when attaching in the response.

[ApacheT101]

Hi @stalluri,

Here is the output:

Thanks in advance.