Subform not showing in email notification
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})
-
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.
- schema path has to be configure root node of the subform
- '~' 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
-
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!
-
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
-
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):
-
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!
Please sign in to leave a comment.
Comments
6 comments