Subform not showing in email notification

Follow

Taylor Howard

• December 09, 2020 20:58

Hi,

 

I have an email notification sent to a reviewer for approval and am trying to add a subform to the email. I have dragged the $XMLREPEATING2HTML() to my email template and dragged the data source node to between the parentheses, but when I test it by submitting a form, the subform table doesn't show anywhere. This is the entry in my email:

$XMLREPEATING2HTML(${/pd:AP/pd:dataSource/pd:SharePoint/pd:SampleRequestRecords/pd:Sample_x0020_Request_x0020_Records/pd:SAMPLE_x0020_ITEM_x0020_RECORDS})

0

• 

  Kumar E K

  • December 10, 2020 06:15

  Hi Taylor,

  Please follow the below document which helps to configure E-mail Macro.

  https://documentation.agilepoint.com/00/appbuilder/cloudenvEmailMacro.html  

  https://documentation.agilepoint.com/00/appbuilder/cloudappExampleAddSubfromToEmail.html 

  Based on the template shared above there are 2 observations.

  1. schema path has to be configure root node of the subform
  2. '~' missing at the end of the schema node which is mandatory

  The above shared document is descriptive which helps you to configure subform to email.

  Thanks & Regards,

  Kumar E K

   

  0

  Comment actions Permalink
• 

  Taylor Howard

  • December 10, 2020 14:00

  Hi Kumar,

  I did use the root node (and the other one as well just to try it) and I added the ~ after I submitted this question, and it still doesn't work.

  The first link you sent says page cannot be found and the other one is the article I used to set it up the first time. No matter what I try (first or second node, ~ or no ~), the subform doesn't show up in the email notification.

  Thanks!

  0

  Comment actions Permalink
• 

  Kumar E K

  • December 10, 2020 14:42

  Hi Taylor,

  Below is the link

   https://documentation.agilepoint.com/00/appbuilder/cloudenvEmailMacro.html

  As you are using HTML mail template I suspect syntax might be malformed. Prepare the syntax in notepad and add in the template and give a try it should work.

  Thanks & Regards

  Kumar E K

  0

  Comment actions Permalink
• 

  Taylor Howard

  • December 10, 2020 15:07

  Hi Kumar,

  I tried that (typing it out outside of AgilePoint and copy pasting in the email template), and it still isn't working. I am using the HTML mail template. Here is what I have so far.

  Thanks!

  Typed out text:

  $XMLREPEATING2HTML(${/pd:AP/pd:dataSource/pd:SharePoint/pd:SampleRequestRecords/pd:Sample_x0020_Request_x0020_Records/pd:SAMPLE_x0020_ITEM_x0020_RECORDS}~)

  Email Template:

  

  Email I received (highlight where table is supposed to be):

  

  0

  Comment actions Permalink
• 

  Kumar E K

  • December 10, 2020 15:34

  Hi Taylor,

  Please try the below

  $XMLREPEATING2HTML(${/pd:AP/pd:dataSource/pd:SharePoint/pd:SampleRequestRecords/pd:Sample_x0020_Request_x0020_Records~})

  Thanks & Regards

  Kumar E K

  0

  Comment actions Permalink
• 

  Taylor Howard

  • December 10, 2020 21:41

  That didn't work, as it is now showing every field in the main form, and not the child SharePoint list (so the table is there, but the subform SharePoint list isn't). I also tried the below to try to incorporate the child list:

  $XMLREPEATING2HTML(${/pd:AP/pd:dataSource/pd:SharePoint/pd:SampleRequestRecords/pd:Sample_x0020_Item_x0020_Records~})

  $XMLREPEATING2HTML(${/pd:AP/pd:dataSource/pd:SharePoint/pd:SampleRequestRecords/pd:Sample_x0020_Request_x0020_Records/pd:Sample_x0020_Item_x0020_Records~})

   

  Thanks!

  0

  Comment actions Permalink

Please sign in to leave a comment.