Home Library Learn Downloads Support Community
Sign in | United States - English | |
52 out of 88 rated this helpful Rate this topic

Submitting Data from InfoPath 2007 to a SharePoint List

Office 2007

Summary:   Learn how to create a solution for submitting data from a Microsoft Office InfoPath 2007 form to add, update, or delete items to a list in Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. (18 printed pages)

Mark Roberts, Microsoft Corporation

February 2008

Applies to:   Microsoft Office InfoPath 2007, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007

Contents

Overview of Submitting to a SharePoint List from InfoPath Forms

Submitting InfoPath forms to a SharePoint form library is quite simple: Just use the Data Connections command on the Tools menu to add a Submit data connection to your form template, and continue from there. However, using an InfoPath form to submit data to a SharePoint list is more complex and requires that you write some code. In this article, we take a look at the steps that are required to do this. The sample solution described in this article enables you to add, update, or delete items in a contacts list on a Windows SharePoint Services 3.0 or Office SharePoint Server 2007 site from an InfoPath form.

Creating an InfoPath Form Template to Submit Items to a SharePoint List

The high-level steps for creating a form template that can submit items to a SharePoint list are as follows:

  1. Create the SharePoint list.

  2. Create the Collaborative Application Markup Language (CAML) XML fragment that InfoPath submits to the UpdateListItems Web service method of the Lists Web service to add the new item to the list.

  3. Create the form template and add the required data connections.

  4. Identify the GUID used as the ID for the list.

  5. Add controls to the form template to display the current items in the list.

  6. Add fields and controls for entering new items to submit to the list.

  7. Add a connection to the SharePoint Lists Web service and define the parameters for calling the UpdateListItems Web method.

  8. Add the event handler code required to submit additions, updates, and deletions from the list.

  9. Test the form.

The following sections provide details about each of these steps.

Creating the SharePoint List

The first step is to create a custom list on a Windows SharePoint Services 3.0 or Office SharePoint Server 2007 site. The following procedure creates a simple contacts list. The first four columns contain the contact data that is visible in the list. The Changed and Delete columns are not displayed in the list. The event handler code in the form template uses these columns to track whether the list item needs to be updated or deleted.

To create the SharePoint list

  1. On the Site Actions menu, click Create.

  2. On the Create page, click Custom List.

  3. Name the list MyContacts, and then click Create.

  4. On the Settings menu, click List Settings.

  5. In the Columns section, click Create Column.

  6. Add each of the columns shown in Table 1.

Table 1 List column names and data types

Name Data Type

FirstName

Single line of text

LastName

Single line of text

Phone

Single line of text

Email

Single line of text

Changed

Yes/No (set Default value to No, and clear the Add to default view check box)

Delete

Yes/No (set Default value to No, and clear the Add to default view check box)

Make a note of the URL for the list. You will need it later to connect your InfoPath form template to the list.

Creating the CAML XML Fragment

The next step is to create a CAML XML fragment that specifies the columns in an item that is being submitted to the list. This XML fragment is submitted as the argument to the updates parameter of the UpdateListItems method of the SharePoint Lists Web service. The CAML elements used in the XML fragment are the Batch Element element, the Method Element (View) element, and the Field Element (List - Definition) element.

After the user specifies the values to add or update, or whether to delete an item, code in the InfoPath form sets the appropriate values in the CAML fragment and then submits it to the UpdateListItems method. By default, the Cmd attribute of the Method element is set to New to add a new item in the list, but code in the form changes the Cmd attribute to "Update" or "Delete" depending on the user's actions in the form.

Also, by default, the ID attribute of the Method element is set to "1". When form code submits a new item to the Web service, the ID attribute is ignored. But if the user updates or deletes an item in the form, code in the form retrieves the value of the ID column for that particular item and sets the ID attribute in the XML fragment before submitting it to the Web service.

To create the CAML XML fragment

  1. Start Notepad (or any text editor).

  2. Copy and paste the following XML code.

    XML
    Copy 
    <Batch OnError="Continue">
    <Method ID="1" Cmd="New">
        <Field Name='Title'></Field>
        <Field Name="FirstName"></Field>
        <Field Name="LastName"></Field>
        <Field Name="Phone"></Field>
        <Field Name="Email"></Field>
        <Field Name="Delete">false</Field>
        <Field Name="Changed">false</Field>
        <Field Name="ID"></Field>
    </Method>
</Batch>

  3. Save this file as Add List Item Template.xml

The next section shows you how to add the CAML XML file to the form template as a secondary data connection.

Creating the Form Template and Adding Data Connections to the List

In this step, you create the form template and add data connections to the Add List Item Template.xml file and the MyContacts list.

To create the InfoPath form template and add data connections to the list

  1. Start Office InfoPath 2007.

  2. In the Getting Started dialog box, click Design a Form Template.

    (If the Getting Started dialog box is not visible, click Design a Form Template on the File menu.)

  3. In the Based on list, click Blank, clear the Enable browser-compatible features only check box, and then click OK.

  4. On the Tools menu, click Data Connections, and then click Add.

  5. In the Data Connection Wizard dialog box, click Create a new connection to, click Receive data, and then click Next.

  6. Click XML document, and then click Next.

  7. Click Browse, locate and select the Add List Item Template.xml file that you created in the "To create the CAML XML fragment" procedure, and then click Next.

  8. Click the Include the data as a resource file in the form template or template part, and then click Next.

  9. Ensure that the Automatically retrieve data when the form is opened check box is selected, and then click Finish.

  10. In the Data Connections dialog box, click Add.

  11. Click Create a new connection to, click Receive data, and then click Next.

  12. Click SharePoint library or list, and then click Next.

  13. Type the URL to the MyContacts list that you created in the "To create the SharePoint list" procedure, and then click Next.

  14. In the Select a list or library list, select MyContacts, and then click Next.

  15. Select the Title and ID fields along with the six custom fields that you created (FirstName, LastName, Phone, Email, Changed, and Delete), and then click Next twice.

  16. Make sure that the Automatically retrieve data when the form is opened check box is selected, and then click Finish.

  17. Click Close to close the Data Connections dialog box.

Identifying the List GUID

Each SharePoint list is identified by a GUID. To submit items to a SharePoint list, you must know the GUID for that list. These next steps show you how to identify the GUID for your MyContacts list.

To identify the list GUID

  1. Open a browser and navigate to the MyContacts list.

  2. On the Settings menu, click List Settings.

  3. In the browser’s address bar, you will see the URL appended with List=

  4. Copy everything after the equal sign and paste this into a text editor because you will need this value later.

    Cc162745.Important(en-us,office.12).gifImportant:
    The list GUID must be formatted as: {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}. If the list GUID has the hyphens and braces escaped (with %7B for the opening brace, %2D for the hyphens, and %7D for the closing brace), you must replace the escaped characters with actual braces and hyphens. When you use this GUID later, it must appear as follows: {1E76517B-2C36-4473-A420-A737D98589BC}

Adding Controls to Display the Current Items in the List

In this step, you add a Repeating Table control to display the current items in the MyContacts list.

To add controls to display items in the list

  1. Open the Data Source task pane.

  2. In the Data Source drop-down list, click the MyContacts (Secondary) connection.

  3. Expand the dataFields folder, right-click the MyContacts folder, and then click Repeating Table.

    This adds a Repeating Table control bound to the fields from that connection to your view.

    You do not need the ID and Changed fields bound to the repeating table, so the next step describes how to delete them.

  4. In the Repeating Table control, right-click the ID column, point to Delete, and then click Columns. Repeat this step to delete the Changed column.

  5. At run time, a user can select the Check Box control bound to the Delete field to indicate whether to delete the item, so change the Delete field's column heading to read Delete?

  6. Select the Delete? column heading, and then click the Center button on the Formatting tool bar.

  7. Delete the label next to the check box bound to the Delete field, select the check box, and then click the Center button on the Formatting tool bar.

Adding Fields and Controls for Submitting New Items to the List

In this step, you add a group and fields to the form's main data source to temporarily contain the new items a user adds to the list. Then you add a Repeating Table control, which is bound to this group, to the form's view. You also add an AddContacts field to the main data source and bind that to a Check Box control that the user selects to add new contact items to the list. Finally, you add a ListName field to the main data source that is used by form code to specify the GUID of the list when a user submits items to the list.

To add fields and controls for submitting new items to the list

  1. In the Data Source drop-down list, click Main.

  2. In the Data Source pane, right-click the myFields folder, and then click Add.

  3. Add a True/False field named AddContacts, set the Default Value to FALSE, and then click OK.

  4. Drag AddContacts from the Data Source and drop it below the repeating table you added to the form in the previous procedure.

    This adds a Check Box control that is used at run time to display the repeating table for adding new items.

  5. Change the label of the AddContacts check box to read Add New Contacts?

  6. Right-click the myFields folder, and then click Add.

  7. Add a Group named gpContacts.

  8. Right-click the gpContacts folder, and then click Add.

  9. Add a Group named gpContact, select the Repeating check box, and then click OK.

  10. Right-click the gpContact folder, and then click Add.

  11. Add five Text fields named Title, FirstName, LastName, Email, and Phone.

  12. Right-click the gpContacts folder, and then click Section with Controls.

    This adds a Section control that contains a Repeating Table control bound to the gpContact group and the fields it contains.

  13. Right-click the Section control that you added in step 12, and then click Conditional Formatting.

  14. In the Conditional Formatting dialog box, click Add.

  15. Under If this condition is true, set the condition to AddContacts is equal to FALSE.

  16. Under Then apply this formatting, click Hide this control.

  17. Click OK twice.

  18. Right-click the Repeating Table control that you added in step 12, and then click Repeating Table Properties.

  19. On the Data tab, select the Show insert button and hint text check box, type Add New Contact in the text box, and then click OK.

  20. Right-click the myFields folder, click Add, and then add a Text field named ListName.

  21. Set the Default Value property of the ListName field to the value of the GUID of your list (which you determined by using the procedure in the "Identifying the List GUID" section).

    Form code uses this field to specify the identifier of the list when a user performs the submit operation.

Cleaning Up the Layout of the Form

You should now have the controls that are required for viewing and entering data in the form. But before you continue, clean up the layout using a Layout Table, and add some text to identify what each repeating table is used for.

To add a layout table and labels

  1. Click above the two Repeating Table controls that you added in the earlier procedures.

  2. On the Table menu, point to Insert, and then click Layout Table.

  3. Set the Number of columns to 1 and set the Number of rows to 2, and then click OK.

  4. Right-click the topmost Repeating Table control, click Cut, and then paste it into the first row of the layout table.

  5. Select the Check Box bound to the AddContacts field and the Add New Contacts? label, right-click the selected items, click Cut, and then paste them below the first repeating table.

  6. Right-click the Section control that contains the second Repeating Table control, click Cut, and then paste it into the second row of the layout table.

  7. Right-click the title row of the topmost Repeating Table control, point to Insert, and then click Rows Above.

  8. Select all of the cells in the new row, right-click the selected cells, and then click Merge Cells.

  9. Type Current contacts in the list: in the new row.

  10. Repeat steps 7 and 8 for the second repeating table, and then type New contacts to be added: in the new row.

    When you are finished, your form should look like Figure 1:



    Figure 1. Final design of the form

    Final design of the form

Adding a Connection to the Lists Web Service and Specifying the Parameters of the UpdateListItems Method

To add items to the SharePoint list, a client application uses the UpdateListItems method of the SharePoint Lists Web service.

The UpdateListItems Web service method requires two parameters: the listName parameter that specifies the name of the list, and the updates parameter that accepts a Batch element XML fragment. The Batch element XML fragment specifies the items to post to the list and whether to perform an add, update, or delete operation.

Now that you have the ListName field that contains the GUID for the list, and the Add List Item Template data connection that describes the data structure of the item to add, you have all the necessary information to define the connection for submitting items to the list.

Cc162745.Important(en-us,office.12).gifImportant:
For the data connection to the Lists Web service to work correctly, the URL you enter in step 4 of this procedure must correspond to the location of your MyContacts list. If the list is located directly off the root Web of your SharePoint server, the URL will be in this form:

http://servername/_vti_bin/lists.asmx

If the list is located in a site on your SharePoint server, the URL will be in this form:

http://servername/sitename/_vti_bin/lists.asmx

To connect to the Lists Web Service and specify the parameters of the UpdateListItems method

  1. On the Tools menu, click Data Connections, and then click Add.

  2. In the Data Connection Wizard dialog box, click Create a new connection to, click Submit data, and then click Next.

  3. Click To a Web service, and then click Next.

  4. Type the URL to the Lists Web service (see previous note), and then click Next.

  5. In the Select an operation list, select the UpdateListItems operation, and then click Next.

  6. In the Parameters list, double-click the tns:listName parameter name, and then assign the ListName field as the value to pass for this parameter.

  7. Double-click the tns:updates parameter name, select the Add List Item Template (Secondary) data source, select the Batch folder, and then click OK.

  8. In the Include drop-down list, select XML subtree, including selected element, and then click Next.

  9. Click Finish, and then click Close.

Adding Submit Functionality

Now that your form template has all the data connections and controls that are required for displaying data in the list, you need to add event handler code for submitting the items to add, update, or delete from the list.

Adding Event Handler Code to the Add New Contacts Check Box

By default, conditional formatting set on the repeating table for adding new contacts hides the table. To display the repeating table, you must add an event handler to the check box that is bound to the addContacts field. The event handler code runs when the Changed event of the addContacts field is raised (which occurs when the user selects the check box). The code adds a new blank row to the repeating table, which displays the control and provides an empty row for entering a new contacts list item. The user can add rows by clicking Add New Contact below the first row in the table. If the user clears the check box, the event handler code removes the blank row (and any other rows in the control), which hides the repeating table. The code to remove the blank row depends on the ClearEnteredValues custom function, which is described in the following procedure.

To add event handler code to the Add New Contacts check box

  1. Right-click the check box that is bound to the AddContacts field, point to Programming, and then click Changed Event.

  2. Add the following code to the AddContacts_Changed event handler.

    C#
    Copy 
    try
{
   // Get a reference to the form's XmlNamespaceManager object.
   XmlNamespaceManager ns = this.NamespaceManager;

   // Create an XPathNavigator object for the form's main data
   // source.
   XPathNavigator xnDoc = this.MainDataSource.CreateNavigator();

   // If the check box is set to true, add a new row so the user 
   // can add a new contact.
   if (e.Site.Value == "true")
   {
      XPathNavigator xnTable = 
         xnDoc.SelectSingleNode("/my:myFields/my:gpContacts", ns);
      xnTable.AppendChild("<my:gpContact><my:Title /><my:FirstName /><my:LastName /><my:Email /><my:Phone /></my:gpContact>");
   }
   else
   {
      // If the user clears the check box, remove the added row.
      ClearEnteredValues(xnDoc);
   }
}
catch (Exception ex)
{
   MessageBox.Show("The following error occurred: " + ex.Message);
   throw;
}

  3. Add the following code for the custom ClearEnteredValues function.

    C#
    Copy 
    private void ClearEnteredValues(XPathNavigator xnDoc)
{
   try
   {
      // Get a reference to the form's XmlNamespaceManager object.
      XmlNamespaceManager ns = this.NamespaceManager;

      // Create an XPathNodeIterator object to get a count of the 
      // rows in the repeating table used to add new Contacts.
      XPathNodeIterator xi = xnDoc.Select(
         "/my:myFields/my:gpContacts/my:gpContact", ns);
      int rowCount = xi.Count;

      if (rowCount > 0)
      {
         // Get the first and last rows (nodes) in the 
         // repeating table.
         XPathNavigator firstNode = xnDoc.SelectSingleNode(
            "/my:myFields/my:gpContacts/my:gpContact[1]", ns);
         XPathNavigator lastNode = xnDoc.SelectSingleNode(
            "/my:myFields/my:gpContacts/my:gpContact[" +
            rowCount + "]", ns);
   
         // Delete the existing nodes using the DeleteRange method.
         firstNode.DeleteRange(lastNode);
      }

     // Clear the check box. 
     xnDoc.SelectSingleNode(
        "/my:myFields/my:AddContacts", ns).SetValue("false");
   }

   catch (Exception ex)
   {
      MessageBox.Show("The following error occurred: " + 
         ex.Message);
      throw;
   }
}

  4. Save your additions, and switch back to InfoPath form design view.

Adding Event Handler Code to Flag Updated Items

When the user changes items in the repeating table bound to the MyContacts group that displays current contacts in the list, code is required to set the Changed column to true to flag that the item was updated. The code for submitting data to the list uses the value of the Changed column to determine whether to submit that item. Additionally, the event handler code must check whether the user selected the Delete check box and not set the Changed column in this case.

To add event handler code to flag updated items

  1. Right-click the header row of the repeating table bound to the MyContacts group, point to Programming, and then click Changed Event.

  2. Add the following code to the MyContacts__MyContacts_Changed event handler.

    C#
    Copy 
    try
{
   // Get a reference to the form's XmlNamespaceManager object.
   XmlNamespaceManager ns = this.NamespaceManager;

   // See if values have been changed.
   if (e.Operation == XmlOperation.ValueChange)
   {
      // Set the Changed field to "true" only if the Delete
      // check box is not selected.
      if (e.Site.SelectSingleNode("@Delete", ns).Value != "true")
      {
         e.Site.SelectSingleNode("@Changed", ns).SetValue("true");
      }
   }
}
catch (Exception ex)
{
   MessageBox.Show("The following error occurred: " + ex.Message);
   throw;
}

  3. Save your additions, and switch back to InfoPath form design view.

Adding a Button for Submitting Items in the List

This section describes how to add a Button control and its event handler code to the form for submitting changes to the form. Note that the code for this button handles all operations the user can perform in the form: adding new items, updating existing items, and deleting existing items.

To add a button for updating items in the list

  1. In the Design Tasks task pane, click Controls.

  2. Drag a Button control below the second repeating table.

  3. Double-click the button to display its properties dialog box.

  4. On the General tab of the Button Properties dialog box, change the Label property to Submit Changes, and change the ID property to btnSendChanges.

  5. Click Edit Form Code to open the code editor.

  6. Add the following code to the btnSendChanges_Clicked event handler.

    C#
    Copy 
    try
{
   // Get a reference to the form's XmlNamespaceManager object.
   XmlNamespaceManager ns = this.NamespaceManager;

   // Create a DataSource object for the MyContacts 
   // list data connection.
   DataSource dsContacts = this.DataSources["MyContacts"];

   // Create an XPathNavigator object for the MyContacts 
   // data connection.
   XPathNavigator xnContacts = dsContacts.CreateNavigator();

   // Create an XPathNodeIterator object for the MyContacts 
   // data connection to enumerate the existing contacts.
   XPathNodeIterator xiContacts = xnContacts.Select(
      "/dfs:myFields/dfs:dataFields/dfs:MyContacts", ns);

   // Create a DataSource object for the Add List Item Template
   // data connection.
   DataSource dsCAML = this.DataSources["Add List Item Template"];

   // Create an XPathNavigator object for the 
   // Add List Item Template data connection.
   // This is used to set the values in the CAML XML file.
   XPathNavigator xnCAML = dsCAML.CreateNavigator();

   // Create a WebServiceConnection object for submitting 
   // to the Lists Web service data connection.
   WebServiceConnection wsSubmit = 
      (WebServiceConnection)this.DataConnections[
      "Web Service Submit"];

   // Create an XPathNavigator object for the form's 
   // main data source.
   XPathNavigator xnDoc = this.MainDataSource.CreateNavigator();

   // Create an XPathNodeIterator object for the new contacts.
   XPathNodeIterator xiNewContacts = xnDoc.Select(
      "/my:myFields/my:gpContacts/my:gpContact", ns);

   // See if any new contacts have been added.
   if (xiNewContacts.Count > 0)
   {
      while (xiNewContacts.MoveNext())
      {
         // Set the values in the Add List Item Template 
         // XML file using the values in the new row.
         xnCAML.SelectSingleNode(
            "/Batch/Method/Field[@Name='Title']", ns)
            .SetValue(xiNewContacts.Current.SelectSingleNode(
            "my:Title", ns).Value);
         xnCAML.SelectSingleNode(
            "/Batch/Method/Field[@Name='FirstName']", ns)
            .SetValue(xiNewContacts.Current.SelectSingleNode(
            "my:FirstName", ns).Value);
         xnCAML.SelectSingleNode(
            "/Batch/Method/Field[@Name='LastName']", ns)
            .SetValue(xiNewContacts.Current.SelectSingleNode(
            "my:LastName", ns).Value);
         xnCAML.SelectSingleNode(
            "/Batch/Method/Field[@Name='Phone']", ns)
            .SetValue(xiNewContacts.Current.SelectSingleNode(
            "my:Phone", ns).Value);
         xnCAML.SelectSingleNode(
            "/Batch/Method/Field[@Name='Email']", ns)
            .SetValue(xiNewContacts.Current.SelectSingleNode(
            "my:Email", ns).Value);

         // Set the values of the Changed and Delete columns to
         // "FALSE".
         xnCAML.SelectSingleNode(
            "/Batch/Method/Field[@Name='Changed']", ns)
            .SetValue("FALSE");
         xnCAML.SelectSingleNode(
            "/Batch/Method/Field[@Name='Delete']", ns)
            .SetValue("FALSE");

         // Set the value of Cmd attribute to "New".
         xnCAML.SelectSingleNode("/Batch/Method/@Cmd", ns)
            .SetValue("New");
         
         // Submit the new row.
         wsSubmit.Execute();
      }
   }
   else
   {
      // Enumerate the existing contacts and see if 
      // any items have been changed or set to be deleted.
      while (xiContacts.MoveNext())
      {
         if (xiContacts.Current.SelectSingleNode(
            "@Changed", ns).Value == "true")
         {
            // Set the values in the Add List Item Template XML file
            // to the values in the updated row.
            xnCAML.SelectSingleNode(
               "/Batch/Method/Field[@Name='Title']", ns)
               .SetValue(xiContacts.Current.SelectSingleNode(
               "@Title").Value);
            xnCAML.SelectSingleNode(
               "/Batch/Method/Field[@Name='FirstName']", ns)
               .SetValue(xiContacts.Current.SelectSingleNode(
               "@FirstName").Value);
            xnCAML.SelectSingleNode(
               "/Batch/Method/Field[@Name='LastName']", ns)
               .SetValue(xiContacts.Current.SelectSingleNode(
               "@LastName").Value);
            xnCAML.SelectSingleNode(
               "/Batch/Method/Field[@Name='Phone']", ns)
               .SetValue(xiContacts.Current.SelectSingleNode(
               "@Phone").Value);
            xnCAML.SelectSingleNode(
               "/Batch/Method/Field[@Name='Email']", ns)
               .SetValue(xiContacts.Current.SelectSingleNode(
               "@Email").Value);
            xnCAML.SelectSingleNode(
               "/Batch/Method/Field[@Name='Changed']", ns)
               .SetValue("false");
            xnCAML.SelectSingleNode(
               "/Batch/Method/Field[@Name='ID']", ns)
               .SetValue(xiContacts.Current.SelectSingleNode(
               "@ID").Value);

            // Set the value of the Cmd attribute to "Update".
            xnCAML.SelectSingleNode(
               "/Batch/Method/@Cmd", ns)
               .SetValue("Update");

            // Submit the updates for the current row.
            wsSubmit.Execute();
         }
         // If the Delete field is set to "true" for the current
         // row, in the Batch fragment set the ID for the row
         // and set the Cmd attribute to "Delete".
         if (xiContacts.Current.SelectSingleNode(
            "@Delete", ns).Value == "true")
         {
            xnCAML.SelectSingleNode(
               "/Batch/Method/Field[@Name='ID']", ns)
               .SetValue(xiContacts.Current.SelectSingleNode(
               "@ID").Value);
            xnCAML.SelectSingleNode(
               "/Batch/Method/@Cmd", ns)
               .SetValue("Delete");
            
            // Submit the delete operation for the current row.
            wsSubmit.Execute();
         }
      }
   }

   // Create a DataConnection object for the MyContacts 
   // data connection.
   DataConnection dcContacts = this.DataConnections["MyContacts"];

   // Execute the data connection to refresh the list of 
   // contacts to reflect any additions, updates, or deletions.
   dcContacts.Execute();

   // Clear the values in the repeating table for 
   // adding new contracts.
   ClearEnteredValues(xnDoc);
}

catch (Exception ex)
{
   MessageBox.Show("The following error occurred: " + ex.Message);
   throw;
}

  7. Save your additions, build the code, and then switch back to InfoPath form design view.

Testing the Form

Now that everything is in place, you can preview the form to test it. Each time you make a change to the list from the form, you can confirm that the changes were submitted to the list by opening the list in a Web browser, making sure to refresh the page if it was opened before you submitted changes.

To test the form

  1. Click the Preview button to preview the form.

    If there are any items already in the list, they are displayed in the first repeating table control.

  2. Select the Add New Contacts? check box. This should display the second repeating table with a blank row for adding a new contact item.

  3. Fill in values for Title, FirstName, LastName, Email and Phone fields in the second repeating table control.

    Cc162745.note(en-us,office.12).gifNote:
    If you want, you can click Add New Contact below the first row to add more than one new contact at a time.

  4. Click the Submit Changes button.

    The contact information is submitted as one or more new items to the MyContacts list, which are then displayed in the first repeating table control that is bound to the list.

  5. In the first repeating table control, make a change to the values in one or more of the items in the list.

  6. Click the Submit Changes button.

    The updated contact information is submitted to the MyContacts list.

  7. In the first repeating table control, select the Delete? check box for one or more of the items in the list.

  8. Click the Submit Changes button.

  9. The items to delete are submitted to the MyContacts list, and the data connection is refreshed to update the items displayed in the control.



    Figure 2. Previewing the form

    Previewing the form

Next Steps

Because the form template contains code for updating list items, you must perform additional steps before you can deploy it, such as digitally signing the form template. For more information about deploying a form template that contains code, see How to: Deploy InfoPath Projects. If your users do not have InfoPath, but you do have Office SharePoint Server 2007 with InfoPath Forms Services or Office Forms Server 2007, you can deploy the form template to your server so that users that do not have InfoPath can open the form in the browser. Completing the deployment process for a form template that contains code requires administrator rights on the server. For information about how to deploy a form template that contains code to Office SharePoint Server 2007 or Office Forms Server 2007, see "Deploying Form Templates That Contain Code" in Developing and Deploying Form Templates for InfoPath Forms Services.

Conclusion

By connecting to the SharePoint Lists Web service and submitting data by using its UpdateListItems method, you can create an InfoPath solution for adding, updating, and deleting items in a SharePoint list. This article describes how to design a form template and write code to create such a solution.

Cc162745.note(en-us,office.12).gifNote:
You can also create a simpler codeless solution for submitting items to a SharePoint list from an InfoPath form. For more information, see Submitting to a SharePoint List on the InfoPath Team Blog.

Acknowledgments

I would like to thank Scott Heim for his contributions to this article.

Additional Resources

Did you find this helpful?
(2000 characters remaining)
Community Content Add
Annotations FAQ
Does anyone have the VB equivalent to this code?
Having never coded C# I thought I'd give it a try with this but the very first event handler code is giving an error, apparently "else" isn't recognized????

This functionality is key, I can't see how they haven't known that everyone would want to get the repeating data into a table. What good is the data stuck only in the form???

Please MS find a way to build the functionality into InfoPath to submit to multiple SharePoint lists, including repeating control data! This is highly needed.

Thanks!
History
Code doesn't work
I'm glad someone took the time to put together this example but where are the updates because the code is not working? Are there any naswer on the forums?

Thanks.
History
Followed the steps, pasted the code, this doesn't work
For starters, the way this is written, a blank entry is created every time, so on the first use, regardless of wether or not the end user added a record, the code tries to process a blank record.  After following the instructions at least 5 times on 3 different setups, I consistantly get the following error.

InfoPath cannot submit the form.
An error occurred while the form was being submitted.

The SOAP response indicates that an error occurred on the server:
Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
<detail><errorstring xmlns="Value'>http://schemas.microsoft.com/sharepoint/soap/">Value does not fall within the expected range.</errorstring></detail>

This leads me to believe there is something wrong with the submission data connection or the Add List Item Template.xml file.  I double checked the xml file against some general working with SharePoint services code and it looks fine.  No clue what I'm doing wrong.  I'd love to see a functioning project.
History
Cannot change empty fields
I am only interested in updating the contents of existing items, but when opening the form and the repeating table is populated with existing data from the SP list I am unable to update a column if it is empty (i.e. empty in the SP list and therefore empty in the form).

I can change the contents of existing data, but cannot populate an empty field.

If I delete the contents of a column from a row and update the list, the changes are called in but now I cannot update that column as it is now empty.

This functionality is crucial for something I am working on at the moment, where I need users to batch update items in a list, but the columns are initially blank.

Any advice would be welcome!
History
Selecting Add contacts Check box Got Exception "Object reference not set to an instnter title here.
Pls help me.
History
Infopath Form Services Error
Hi,

I did everything the article said, but I wanted to publish it using Forms Services and this is the error?


System.Net.WebException: The remote server returned an error: (401) Unauthorized.
at System.Net.HttpWebRequest.GetResponse()
at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.GetResponseHelper(WebRequest request, DataAdapterTimer dataAdapterTimer, DataAdapterCredentials credentials, Stopwatch timer, ExecWebRequestExceptionState state, String adapterName, Boolean isQuery)
at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.ExecWebRequestSync(XPathNavigator inputSubDOM, Boolean[] inputUseDataset, XPathNavigator resultsSubDOM, Boolean resultUseDataset, XPathNavigator errorsSubDOM, Uri serviceUrl, Uri soapAction, Int64 timeOutMillisec, Solution solution, Document document, String name, Boolean isQuery, DataAdapterTimer dataAdapterTimer, DataAdapterCredentials credentials, Boolean useDcl, Boolean useProxy, Boolean useSelf)


Can you help me?
History
Error on the Add New Contacts checkbox
When I click on the the checkbox to Add New Contacts I get an error "The following error occurred: schema validation found non-data type errors.".

If I click ok and carry on the Repeating Table appears, I can add new records ok, delete records, update records without any problem.  I only get an error when using the check box, which I find quite odd, as it is only a copy and paste exercise from the supplied code.  Has any one else had this problem?
History
How to add the required field validation
How can we add the required field validation in the control using the xml as a control datasource?    
History
RE:Unable to See VB code
I can't see the code on any of the tabs in Lightweight view. Was able to view the code by using Preferences on this site to switch to either Classic or ScriptFree view. If you want the VB code, copy the C# code and then use this dandy little converter to convert it to VB

http://www.developerfusion.com/tools/convert/csharp-to-vb/

History
Unable to See VB code
Very good article, however as I'm using MVST the VB code is essential to completing this Tutorial and unfortunately, I'm unable to see the VB code. I only see:
This language is not supported or no code example is available.
Please help me find the VB code for this tutorial... any help would be greatly appreciated.

Thank you.
History
Cannot see example code
I'm not seeing the example code for 'Adding Submit Functionality', just a message, 'This language is not supported or no code example is available.
 It doesn't seem to matter which language I choose.
History
System.Runtime.InteropServices.COMException
Hi All,

I am getting the following error while submitting data. 

System.Runtime.InteropServices.COMException
An item with the following index does not exist in the collection: Add List Item Template
   at Microsoft.Office.Interop.InfoPath.SemiTrust.DataObjects.get_Item(Object varIndex)
   at Microsoft.Office.Interop.InfoPath.SemiTrust.DataObjectsCollectionWrapper.get_Item(Object varIndex)
   at Microsoft.Office.InfoPath.Internal.DataSourcesHost.get_Item(String name)
   at List_Data.FormCode.btnSendChanges_Clicked(Object sender, ClickedEventArgs e)
   at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
   at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

Please Help me reagrding this.

Thanks,
Kumar.

History
Can't Find Rows in InfoPath by Adding new SharePoint Connection
Hello,

I have a problem. I followed the tutorial and add a custom list in SharePoint. The first problem: Using a Custom List doesn't work. I have to use a data connection library. After adding the rows in the list, I load the XML-File into InfoPath. After that, I would build the connection to the new Sharepoint-List. I can choose the list, but I can't see the rows and InfoPath said, that there are no data connection files at this place.

Can somebody tell me, what it's wrong?

Greetings,
Karon
History
Nedd help getting the new list item ID value upon submitting UpdateListItem web service
This was a very helpful article and I was able to get everything working. Now that I am tweaking things for my real form development, I have a need to capture, when submitting the web service, the new Sharepoint list item ID that was created. The reason why is because I want to be able to add attachments using the AddAttachments web service.

Does anyone know of a way to get at the value of the new list item ID that was created?
History
Error
Among others, my first error is

On my DataSource dsCAML = this.DataSources["Add List Item Template"]; is throwing COMException was unhandled by user code

[tfl - 23 11 09] Hi - and thanks for your post. You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quicker response using the forums than through the Community Content. For specific help about:
Visual Studio  : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.vstudio%2C&
SQL Server     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
.NET Framework : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.dotnet.framework
PowerShell     : http://groups.google.com/group/microsoft.public.windows.powershell/topics?pli=1
All Public     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&

History
There isnt any new row in my list
Hi,
I did all rows wiht out any error and i compile my c# code with out any error but at end of execute there isn't any new row in my list and compiler didn't catch any error.
Can some body help me.

[tfl - 23 11 09] Hi - and thanks for your post. You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quicker response using the forums than through the Community Content. For specific help about:
Visual Studio  : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.vstudio%2C&
SQL Server     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
.NET Framework : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.dotnet.framework
PowerShell     : http://groups.google.com/group/microsoft.public.windows.powershell/topics?pli=1
All Public     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&
History
There has been an error while processing the form
Hi,
I have published, verified, uploaded and activated the forms on my sharepoint server according to (http://msdn.microsoft.com/en-us/library/ms772110.aspx)

When I try to Submit the change I have this error :

"There has been an error while processing the form - An entry has been added to the Windows event log of the server. Log ID:5337"

In my 12 logs I found this :

03/23/2009 17:36:34.69     w3wp.exe (0x0AA4)                           0x0FF4    Forms Server                      Forms Services Runtime            0    Medium      Regenerating object: ProcessId:[9] CacheId: SiteFeatures_91ffb6e0-6a12-421e-92c0-c003f842ebc6


03/23/2009 17:36:38.49 w3wp.exe (0x0AA4) 0x0FF4 Forms Server Forms Services Runtime - Busine 82g6 Warning Business logic failed due to an exception. (User: DOMAIN\User, Form Name: ContactListToUpload, IP: , Request: http://mysharepointsite/_layouts/Postback.FormServer.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:ContactListToUpload:-myXSD-2009-03-23T11-21-23, Type: NullReferenceException, Exception Message: La référence d'objet n'est pas définie à une instance d'un objet.) 110062d1-4b6a-4488-9098-f30c265476f0


03/23/2009 17:36:38.50 w3wp.exe (0x0AA4) 0x0FF4 Forms Server Forms Services Object Model 7tge Assert Exception thrown from business logic event listener StackTrace: à Microsoft.Office.InfoPath.Server.DocumentLifetime.OMExceptionManager.CallFormCodeWithExceptionHandling(UserMessages userMessages, OMCall d) à Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonFormCode.<>c__DisplayClass2.<Click>b__0() à Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonFormCode.Click(Document document, XPathNavigator container) à Microsoft.Office.InfoPath.Server.DocumentLifetime.EventClick.Play(Document document, BindingServices bindingServices, EventLogProcessor eventLogProcessor) à Microsoft.Office.InfoPath.Server.DocumentLifetime.Event.PlayEvent(Document document, BindingServices bindingServices, EventLogProcessor eventLogProcessor) à Microsoft.Office.InfoPath.Server.Docum... 110062d1-4b6a-4488-9098-f30c265476f0


03/23/2009 17:36:38.50* w3wp.exe (0x0AA4) 0x0FF4 Forms Server Forms Services Object Model 7tge Assert ...entLifetime.EventLogProcessor.<>c__DisplayClass1.<ExecuteLog>b__0() à Microsoft.Office.InfoPath.Server.DocumentLifetime.EventLogProcessor.ExecuteLog(Int32 expectedEventLogID) à Microsoft.Office.InfoPath.Server.Docum 110062d1-4b6a-4488-9098-f30c265476f0


03/23/2009 17:36:40.17 w3wp.exe (0x0AA4) 0x0FF4 SharePoint Portal Server Runtime 8gp7 Medium Topology cache updated. (AppDomain: /LM/W3SVC/1916344843/ROOT-1-128822862474298504)


03/23/2009 17:36:46.41 w3wp.exe (0x0AA4) 0x0FF4 Forms Server Forms Services Runtime - Busine 82g6 Warning Business logic failed due to an exception. (User: DOMAIN\User, Form Name: ContactListToUpload, IP: , Request: http://mysharepointsite/_layouts/Postback.FormServer.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:ContactListToUpload:-myXSD-2009-03-23T11-21-23, Type: NullReferenceException, Exception Message: La référence d'objet n'est pas définie à une instance d'un objet.) 110062d1-4b6a-4488-9098-f30c265476f0


03/23/2009 17:36:46.41 w3wp.exe (0x0AA4) 0x0FF4 Forms Server Forms Services Object Model 7tge Assert Exception thrown from business logic event listener StackTrace: à Microsoft.Office.InfoPath.Server.DocumentLifetime.OMExceptionManager.CallFormCodeWithExceptionHandling(UserMessages userMessages, OMCall d) à Microsoft.Office.InfoPath.Server.SolutionLifetime.XmlEventExternal.FireChangedEvent(XPathNavigator sender, XmlEventArgsHost args, Document document) à Microsoft.Office.InfoPath.Server.DocumentLifetime.XmlNotificationManager.<>c__DisplayClass6.<FireEventHelper>b__5() à Microsoft.Office.InfoPath.Server.DocumentLifetime.XmlNotificationManager.FireEventHelper(XPathNavigator nodeChanged, SortedList notifiers, XmlEventType eventType, Boolean internalListenersOnly) à Microsoft.Office.InfoPath.Server.DocumentLifetime.XmlNotificationManager.FireChangedEvents(XPathNavigator nod... 110062d1-4b6a-4488-9098-f30c265476f0


03/23/2009 17:36:46.41* w3wp.exe (0x0AA4) 0x0FF4 Forms Server Forms Services Object Model 7tge Assert ...eChanged, SortedList notifiers) à Microsoft.Office.InfoPath.Server.DocumentLifetime.XmlNotificationManager.<>c__DisplayClass3.<FireEventsToListeners>b__0() à Microsoft.Office.InfoPath.Server.DocumentLifetime.XmlNoti 110062d1-4b6a-4488-9098-f30c265476f0


03/23/2009 17:36:46.41 w3wp.exe (0x0AA4) 0x0FF4 Forms Server Forms Services Runtime - Busine 82g6 Warning Business logic failed due to an exception. (User: DOMAIN\User, Form Name: ContactListToUpload, IP: , Request: http://mysharepointsite/_layouts/Postback.FormServer.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:ContactListToUpload:-myXSD-2009-03-23T11-21-23, Type: NullReferenceException, Exception Message: La référence d'objet n'est pas définie à une instance d'un objet.) 110062d1-4b6a-4488-9098-f30c265476f0


03/23/2009 17:36:46.41 w3wp.exe (0x0AA4) 0x0FF4 Forms Server Forms Services Object Model 7tge Assert Exception thrown from business logic event listener StackTrace: à Microsoft.Office.InfoPath.Server.DocumentLifetime.OMExceptionManager.CallFormCodeWithExceptionHandling(UserMessages userMessages, OMCall d) à Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonFormCode.<>c__DisplayClass2.<Click>b__0() à Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonFormCode.Click(Document document, XPathNavigator container) à Microsoft.Office.InfoPath.Server.DocumentLifetime.EventClick.Play(Document document, BindingServices bindingServices, EventLogProcessor eventLogProcessor) à Microsoft.Office.InfoPath.Server.DocumentLifetime.Event.PlayEvent(Document document, BindingServices bindingServices, EventLogProcessor eventLogProcessor) à Microsoft.Office.InfoPath.Server.Docum... 110062d1-4b6a-4488-9098-f30c265476f0


03/23/2009 17:36:46.41* w3wp.exe (0x0AA4) 0x0FF4 Forms Server Forms Services Object Model 7tge Assert ...entLifetime.EventLogProcessor.<>c__DisplayClass1.<ExecuteLog>b__0() à Microsoft.Office.InfoPath.Server.DocumentLifetime.EventLogProcessor.ExecuteLog(Int32 expectedEventLogID) à Microsoft.Office.InfoPath.Server.Docum 110062d1-4b6a-4488-9098-f30c265476f0

Thanks for your help


[tfl - 23 11 09] Hi - and thanks for your post. You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quicker response using the forums than through the Community Content. For specific help about:
Visual Studio  : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.vstudio%2C&
SQL Server     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
.NET Framework : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.dotnet.framework
PowerShell     : http://groups.google.com/group/microsoft.public.windows.powershell/topics?pli=1
All Public     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&

History
VB version, pls.
Can I have a vb version of all the codes in this tutorial? Many thanks.
History
Cannot Update the Details in the Form
Hi, I have follwed the Procedure accurately. All those things are fine. But If didn't enter Values to some fields while submitting , Next Time I can't update those columns. Pls any one can save me it's urgent.

Pls forgive me for my poor english.

[tfl - 23 11 09] Hi - and thanks for your post. You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quicker response using the forums than through the Community Content. For specific help about:
Visual Studio  : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.vstudio%2C&
SQL Server     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
.NET Framework : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.dotnet.framework
PowerShell     : http://groups.google.com/group/microsoft.public.windows.powershell/topics?pli=1
All Public     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&
History
"Element" is an invalid XmlNodeType

Has anyone else experienced this type of error? Occurs on adding new records to the list. Thanks in advance for any and all help!

[tfl - 23 11 09] Hi - and thanks for your post. You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quicker response using the forums than through the Community Content. For specific help about:
Visual Studio  : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.vstudio%2C&
SQL Server     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
.NET Framework : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.dotnet.framework
PowerShell     : http://groups.google.com/group/microsoft.public.windows.powershell/topics?pli=1
All Public     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&
History
Using Windows Forms in InfoPath

Is there some reference information on using Windows forms in InfoPath? Is it possible to display windows forms in a browser version of InfoPath? 

[tfl - 23 11 09] Hi - and thanks for your post. You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quicker response using the forums than through the Community Content. For specific help about:
Visual Studio  : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.vstudio%2C&
SQL Server     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
.NET Framework : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.dotnet.framework
PowerShell     : http://groups.google.com/group/microsoft.public.windows.powershell/topics?pli=1
All Public     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&
History
Confirm Message Box before deleting Record in Browser Enabled Form

In above example list of contacts are displayed in Infopath 2007 Page along with one check box

for delete functionality.

In the same functionality for Browser Enable Infopath 2007form ,

how to provide confirm message "Are you sure you want to delete?"

If user click on Ok then it will delete the item and if clicked on cancel it will not do any thing.

Is there any solution for this issue?


[tfl - 23 11 09] Hi - and thanks for your post. You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quicker response using the forums than through the Community Content. For specific help about:
Visual Studio  : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.vstudio%2C&
SQL Server     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
.NET Framework : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.dotnet.framework
PowerShell     : http://groups.google.com/group/microsoft.public.windows.powershell/topics?pli=1
All Public     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&
History
MessageBox error when building the code

The overall information here is excellent and could be very useful, except that I consistently get an error when attempting to build the code. VSTA reports "The name 'MessageBox' does not occur in the current context. InfoPath Forms Service does not allow me to reference System.Windows.Forms, so I had to comment out the try and catch lines of the code. Is there a solution to this problem?

[tfl - 23 11 09] Hi - and thanks for your post. You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quicker response using the forums than through the Community Content. For specific help about:
Visual Studio  : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.vstudio%2C&
SQL Server     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
.NET Framework : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.dotnet.framework
PowerShell     : http://groups.google.com/group/microsoft.public.windows.powershell/topics?pli=1
All Public     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&
History
More than one GUID per list
When looking for the GUID of the list, make sure you're looking at the GUID seen on the 'Settings>List Settings' page on sharepoint. I made the mistake of having the 'Actions>Edit in Datasheet' open first when putting in my GUID and got an uninsightful error when trying to submit the form. It turns out that the GUID isn't just unique to that list, but each list has several GUIDs for different views, and ONLY the GUID shown on the List Settings page will work when submitting data.
History
Some additional Tips
Below here is my research result to create a list to be used on InfoPath form (after went through almost 100 InfoPath templates for tests):
1. When you create the list on SharePoint, the column name is very important. Use Camel Case for example FirstName is guaranteed to work
2. If you want to create a "Multiple lines of text" column, choose "Plain Text". Then in the Infopath form, you can use a "Rich Text Box" for this column
3. There is a length limit for column name (eventhough I am not sure what is the max character). You still can create the column in SharePoint, but when you submit the form, it will create nothing in the list. Column name example: ThisIsTheExampleForLongColumnName
4. To get GUID easier without doing any convertion, in the SharePoint list setting, click on Column Ordering and then either click OK or Cancel will do. You will see the GUID in the format you need now on the address linkbar.
5. If you have created a column in SharePoint, and you realize that this column name has problem, DO NOT EVER use this column again. Renaming wont fix it, but delete it and recreate it will fix it.

Now I am still struggling to get the Update existing list item from InfoPath. Somehow setting the CAML CMD="Update" wont do it. Even though I have put the same "ID". And have done some research. Most of them said that I have to use on_changed event handler (programming). But from the C# codes in this page, it looks like just setting the CMD in CAML to "Update" and use the same "ID" for list item will solve my problem. Just not working in my case. Anyone can give me some hint? Thanks
History
Displaying error message for browser-enabled form template

ChrisP123: The code examples do assume that you're opening the form in the InfoPath client. As you've discovered, System.Windows.Forms.MessageBox() is not supported for forms that can open in the browser. To display an error message in a web-based form on InfoPath Forms Services, you'd need to display the message in-line in the form itself.

One way to do that, is to add a text field to the Main data source, eg named "ErrorMsg", drag that as a Text Box control on to the form, and then use code like the following in the try/catch block to write the error message to the ErrorMsg field:

catch (Exception ex)
{
   XmlNamespaceManager ns = this.NamespaceManager;


   XPathNavigator xnDoc = this.MainDataSource.CreateNavigator();




   xnDoc.SelectSingleNode("/my:myFields/my:ErrorMsg", ns).SetValue(


      "The following error occurred: " + ex.Message);


   throw;


} 

        

        

            History
        

        
        

        
        

        

             

             
               
                
            

            
            
              

                          
              
              

            
        

        
    

    




    
    

      
      

              Using Infopath to submit data to a Sharepoint list 
                
        
 
        

            Hi, I've followed the example here very closely but when my form runs, the wsSubmit executes without error but no data is ever populated in the list.  I've triple checked the GUID of the list.  I've checked the logs in the event viewer on my server and don'e see any errors being generated.   I also recreated my example on the home site just to make sure I didn't have a problem with the URL to the _vti_bin directory and to avoid any security issues with sub-sites.  I've tried writing the application following this example and alternatively using .net.  I get the same results both times.  Any other ideas of what else I can check?  I saw somewhere something about running into problems if you have anonymous access turned on - which I do.
        

        

            History
        

        
        

        
        

        

             

             
               
                
            

            
            
        

        
    

    




    
    

      
      

              Displaying error message for browser-enabled form template  - ChrisP123 
                
        
 
        

            
Hello ChrisP123,




The other way around this is to add a reference to System.Windows.Forms and then add "Imports System.windows.forms" (VB) or "Using System.Windows.Forms" (C#).




Following the above, you can then use messagebox.show("Blah Blah Blah....")' in your code.




It worked for me.




cheers

        

        

            History