InfoPath – Submitting to Two Data Connections

Many workflows could be enhanced if a form could be sent to more than one location, like to a main repository and to a user who  via email.

In this topic, I’ll show you how to create a form that is sent to two locations.

The first step in the process is to create two data connections. For this example, we’ll create one for a Sharepoint forms library and one for email.

Create A Data Connection to Submit to a Sharepoint Form Library

  1. Click ToolsData Connections. The Data Connections dialog opens.
  2. Click the Add button. The Data Connection wizard opens.
  3. Since we’re creating a “submit” data connection, accept the default option of Submit data.
  4. Click the Next button.
  5. Select the To a Sharepoint form library option. In the Sharepoint form library field, enter the UNC path to the Sharepoint forms library.

Note: It’s easiest to navigate to the forms library and copy the URL from the Address field of your browser, then paste it in this field. After you do that, delete this from the end of the URL: Forms/AllItems.aspx

  1. The File Name field can be a bit tricky if you want something other than just “Form” as a name for each form submitted. The See “Using the Concat Function” function (don’t let that word scare you) is the trick. Use the CONCAT function to establish a form naming convention.

Example:

concat(FullName, "-",now()) would result in: Debbie Silbert-10-03-2005.xml as a filename.
  1. If you would like the form to allow save and replace, click the Allow overwrite if file exists checkbox.
  2. Click the Next button.

Create a Data Connection to Submit via Email

  1. Click Tools…Data Connections. The Data Connections dialog opens.
  2. Click the Add button. The Data Connection wizard opens.
  3. Since we’re creating a “submit” data connection, accept the default option of Submit data.
  4. Click the Next button.
  5. Select the As an e-mail message option.
Tagged on:

Leave a Reply

Your email address will not be published. Required fields are marked *