Re: Sharepoint list to InfoPath repeating table

Ted Fitch — Fri, 29 Jan 2010 19:41:47 GMT

It sounds like this is a good candidate for the Copy Tables function of our qRules product: http://www.qdabra.com/en/products/qRules.aspx

Your code issue is probably being caused by the nil attribute (usually the source of that particular error).

Ted

Sharepoint list to InfoPath repeating table

mjarrett — Fri, 29 Jan 2010 17:57:17 GMT

Hello all. I hopefully will be able to explain what I am trying to do clearly enough so hopefully I can resolve the issue.

I have the below secondary data source that I want populate a repeating table on an InfoPath form. When the form is submitted to SharePoint and then later reopend, I would like the check boxes of GarmentDefectSelected to be populated. The code I have provide below get's to MyaRow.AppendChild(newNode) it returns: "InvalidOperationException was unhandled by user code" and "Schema validation found non-data type errors."

Main DataSource:

Secondary DataSource:

<code>

            XPathNavigator DSroot = DataSources["Common Garment Defects"].CreateNavigator();
            String strDFSQuery = "/dfs:myFields/dfs:dataFields/dfs:Common_Garment_Defects";
            XPathNodeIterator DSSubs = DSroot.Select(strDFSQuery, NamespaceManager);

            XPathNavigator MyPieces = this.CreateNavigator().SelectSingleNode("/my:myFields/my:CommonGarmentDefectsGroup", NamespaceManager);
            XPathNavigator MyaRow = this.CreateNavigator().SelectSingleNode("/my:myFields/my:CommonGarmentDefectsGroup/my:GarmentDefectsGroup", NamespaceManager);

            XPathNavigator newItemNode = MyaRow.Clone();
            XPathNavigator newNode = newItemNode.Clone();

            foreach (XPathNavigator DSSub in DSSubs)
            {
                newNode = newItemNode.Clone();
                String strTemp = DSSub.SelectSingleNode("@Title", NamespaceManager).ToString();
                MessageBox.Show(strTemp);

                newNode.SelectSingleNode("my:GarmentDefectDescription", NamespaceManager).SetValue(strTemp);
                MessageBox.Show(newNode.ToString());

                MyaRow.AppendChild(newNode);
            }

</code>

Any idea or thoughts? Thank you.

Code

Re: Sharepoint list to InfoPath repeating table

Sharepoint list to InfoPath repeating table