InfoPath Dev

 I am getting the error "Failed to select the destination node" on my form. 

Here is the command I am using:

Transform /sourceds=RepeatingTableData /destpath=/my:myFields/my:repeatingTable /xsltfile=LastWeeksData.xslt /excluderoot=true /placement=append

 Here is the error I'm getting:

Transform /sourceds=RepeatingTableData /destpath=/my:myFields/my:repeatingTable /xsltfile=LastWeeksData.xslt /excluderoot=true /placement=appendfalseFailed to select the destination node.Transform /sourceds=RepeatingTableData /destpath=/my:myFields/my:repeatingTable /xsltfile=LastWeeksData.xslt /excluderoot=true /placement=appendfalseFailed to select the destination node.

 

I looked at the LastWeeksData.xslt file and the xsl looks correct to me.  I confirmed the names of the fields in both the form and the secondary list. 

Here is the XSLT:

<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"
    xmlns:d="http://schemas.microsoft.com/office/infopath/2009/WSSList/dataFields"
    xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2016-03-14T16:40:08"
      
>

<xsl:template match="/">
 <my:repeatingTable>
  <xsl:apply-templates select="/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:FormID !='']"/>
 </my:repeatingTable>
</xsl:template>
 
<xsl:template match="d:SharePointListItem_RW">
 <my:rtColumns>
  <my:matterNumber>
   <xsl:value-of select="d:ClientMatterNumber"/>
  </my:matterNumber>
  <my:clientName>
   <xsl:value-of select="d:ClientMatterName"/>
  </my:clientName>
  <my:description>
   <xsl:value-of select="d:Description"/>
  </my:description>
  <my:partner>
   <xsl:value-of select="d:Partner"/>
  </my:partner>
  <my:comments>
   <xsl:value-of select="d:Comments"/>
  </my:comments>
  <my:ST>
   <xsl:value-of select="d:ST"/>
  </my:ST>
  <my:LT>
   <xsl:value-of select="d:LT"/>
  </my:LT>
  <my:thisMonth>
   <xsl:value-of select="d:ThisMonth"/>
  </my:thisMonth>
  <my:RowID>
   <xsl:value-of select="d:ID"/>
  </my:RowID>
  <my:FormName>
   <xsl:value-of select="d:FormName"/>
  </my:FormName>
  

 </my:rtColumns>
</xsl:template>

</xsl:stylesheet>

 

Here is the repeating table node

 

Here is the source list:

 

So, if you right click repeatingTable in the fields task pane & copy XPath, the XPath is: /my:myFields/my:repeatingTable? Since the error says failure to select destination node, that is always the first thing I check. :) The second thing I'd check would be under the Data tab in the ribbon - if you look at the Defaults for the form, is my:repeatingTable included by default?

 Thanks, Hillary.  I checked the data tab and added the repeating table in as a default. Now the data shows twice.

Any thoughts?

 

 I think I found the issue.  Thanks, again!
You are the best!

Wonderful - glad you have it working! If you use Visual Studio at all, you can run XSLTs to see what the output is - NotePad ++ also has an XML Tools plugin I like that you can use to apply a transform. Sometimes that helps me with debugging. You can use GetXml in qRules to get back sample XML from your secondary data source as well - paste it into a file to use with your XSLT. :)