InfoPath SharePoint Integration

Learn how to combine InfoPath and SharePoint to create forms for both InfoPath Filler 2010 and InfoPath Forms Services in SharePoint.

ADVERTISEMENTS

Configure SharePoint

SharePoint 2007

Determine whether Forms Server is installed on a server

Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

Force InfoPath browser-enabled form to open in the browser

Configure Forms Services and the Form Library to allow and force InfoPath forms to open in the browser.

InfoPath Warning: The form template could not be browser-enabled, but it was successfully published for use with Microsoft Office InfoPath

Learn how you can solve the warning 'The form template could not be browser-enabled, but it was successfully published for use with Microsoft Office InfoPath' which appears on the Publishing Wizard in InfoPath when you try to publish a browser-compatible form template to SharePoint.

"This form template is browser-compatible, but it cannot be browser-enabled on the selected site" message

Learn how to configure Forms Services to allow users to browser-enable form templates.

Understanding the Form Language setting in InfoPath browser-compatible form templates

Learn the logic behind how the 'Form Language' setting on an InfoPath form works in conjunction with Language Packs installed on SharePoint.

Publish InfoPath Form Templates to SharePoint

InfoPath 2007

3 Ways to deploy InfoPath form templates to SharePoint

Learn which methods are available for deploying InfoPath 2007 form templates to SharePoint 2007.

How to publish an InfoPath 2007 browser form to SharePoint

Learn which actions you have to take both in InfoPath and SharePoint before publishing a form template to SharePoint so that it can be opened and/or filled out using a browser.

How to publish an InfoPath form template as a new SharePoint site content type

This article provides the steps required to publish an InfoPath form template as a new content type on a SharePoint site.

InfoPath form uploaded to SharePoint seems to remain stuck in the 'Installing' or 'Upgrading' status

http://www.bizsupportonline.net/blog/2008/12/infopath-form-uploaded-sharepoint-remains-stuck-installing-upgrading-status/

InfoPath 2007 video tutorials

Deploy and enable a managed code InfoPath form template on a SharePoint library

Learn how to deploy an InfoPath browser-compatible form template that contains managed code to SharePoint and then enable it to be used on a SharePoint library.

How to change a SharePoint Form Library template

Learn how you can add, change, and rename a template that is accessible via the New button menu of a SharePoint Form Library.

How to create and deploy an InfoPath browser form template to SharePoint

Learn how you can use InfoPath 2007, Windows SharePoint Services (WSS) 3.0, and Forms Server 2007, to create and publish an InfoPath browser-compatible form template to a SharePoint Form Library.

InfoPath 2010

Change the quick publish location

Learn how you can change the publish location after you have previously published an InfoPath form template, used the quick publish functionality in InfoPat 2010, and would like to republish the InfoPath form template but then using a different publish location.

Deploy administrator-approved form templates to SharePoint 2010

Learn what the steps are for deploying InfoPath 2010 administrator-approved form templates to SharePoint 2010.

Promote InfoPath form fields to a SharePoint library

Learn how to promote fields in InfoPath to a SharePoint form library and get answers to frequently asked questions about InfoPath form field promotion for use in SharePoint 2010 or a workflow.

Display Images in InfoPath Browser Forms

InfoPath 2007

Add a logo from a SharePoint library to an InfoPath browser form

Learn how you can use a Rich Text Box control and code to display an image for a logo that is stored in a SharePoint Picture Library on an InfoPath browser form.

Displaying images in InfoPath 2007 browser forms served through Forms Services in SharePoint

Learn about workarounds that are available to display images in InfoPath forms that are served via InfoPath Forms Services in SharePoint.

How to display images in a repeating table in an InfoPath browser form using a Rich Text Box control

While the Picture control is not available in InfoPath browser forms, you can write code to programmatically add a link to an image to a Rich Text Box control to display images in browser forms.

Add, Edit, and Delete SharePoint Data via InfoPath

InfoPath 2003

Programmatically add an item/event to a SharePoint 2003 calendar using InfoPath 2003 and script code

Use the UpdateListItems method of the Lists web service that comes with Windows SharePoint Services (WSS) to add an item to a SharePoint calendar.

InfoPath 2007

Auto-numbering InfoPath forms when they are submitted to a SharePoint form library

Use rules, formulas, and the max() function to generate incremental numbers that can be assigned to InfoPath forms when they are submitted to a form library.

How to delete SharePoint list items via an InfoPath browser form using the SharePoint Object Model

This article explains how you can use the SPSite, SPWeb, SPList, and SPListItem classes in C# code in an InfoPath form to delete items from a SharePoint list.

How to submit a file attached to an InfoPath form as an attachment to a SharePoint list item

Learn how you can programmatically save a file attachment from an InfoPath form as an attachment to a SharePoint list item when the InfoPath form is submitted to the SharePoint list.

How to submit an InfoPath form to a SharePoint list and attach the form to the list item

Learn how to use the Attachments collection of a SharePoint list item to save the XML of an entire InfoPath form as an attachment to a SharePoint list item.

How to submit the rows of a repeating table in InfoPath to a SharePoint list

Programmatically add items from a repeating table in InfoPath to a SharePoint list by submitting a CAML update batch to the UpdateListItems method of the Lists web service that comes with Windows SharePoint Services (WSS).

How to update a SharePoint list via an InfoPath browser form using the SharePoint Object Model

This article explains how you can use the SPSite, SPWeb, SPList, and SPListItem classes in C# code in an InfoPath form to edit values within a SharePoint list.

How to upload a file to SharePoint from an InfoPath form

Learn how you can write code in the FormCode.cs file of an InfoPath form template to be able to extract and upload a document attached to the InfoPath form to a SharePoint document library.

How to use a SharePoint ItemAdded event handler and the object model to submit data from an InfoPath form to a SharePoint list

This article explains how you can use an ItemAdded event handler on a Form Library to extract data from an InfoPath form that was submitted to the form library and use this data to add a new item to a custom SharePoint list.

How to use the SharePoint object model to submit data from an InfoPath browser form to a SharePoint list

This article explains how you can use the SPContext, SPSite, SPWeb, SPList, and SPListItem classes in C# or Visual Basic code in an InfoPath form to submit the form's data as a new item to a custom SharePoint list.

Programmatically add an item/event to a SharePoint 2007 calendar using InfoPath 2007 and .NET code

Use the UpdateListItems method of the Lists web service that comes with Windows SharePoint Services (WSS) to add an item to a SharePoint calendar.

Programmatically add an item with a Rich Text field to a SharePoint list using InfoPath 2007

Programmatically add an item to a SharePoint list by submitting a CAML update batch to the UpdateListItems method of the Lists web service that comes with Windows SharePoint Services (WSS).

Programmatically submit an InfoPath form to a SharePoint library, send an email, and then close the form

This article shows how you can use the FormEvents_Submit event handler to programmatically execute 2 data connections, one to submit to a SharePoint form library and the other to send an email, when submitting an InfoPath browser form, and then close the form afterwards.

InfoPath 2010

2 Ways to create SharePoint list forms in InfoPath 2010

Learn how you can use InfoPath 2010 or SharePoint 2010 to create an InfoPath form that allows you to view, add, edit, and delete items in a SharePoint list without having to write code.

InfoPath form to upload an image to SharePoint (no code)

Learn how to create an InfoPath form that can upload an image to SharePoint using a web service data connection and rules (no code).

Retrieve and Work with SharePoint Data in InfoPath

InfoPath 2003

Generate a concatenated string of email addresses from a list using VBScript

Use VBScript to extract email addresses from a SharePoint list of contacts and generate a concatenated string of email addresses separated by a semi-colon.

Transform data from a secondary data source using XSLT

Use XSLT to transform the data stored within a secondary data source.

InfoPath 2007

Auto-fill a repeating table with data from a SharePoint list when a row is inserted

Learn how to use rules and filters to automatically fill a repeating table row in InfoPath with data from a SharePoint list when the row is inserted.

Copy a SharePoint list to an InfoPath repeating table using XSLT

Use XSLT and the XslCompiledTransform class in C# to transform the data stored within a SharePoint list (secondary data source) and copy the transformed data to a repeating table in the Main data source of an InfoPath form.

Counting the amount of documents submitted today to a SharePoint library

Use an XPath expression to count the amount of documents that were submitted today to a SharePoint library.

Display Excel data in InfoPath via SharePoint or XML connections

Learn which 2 methods are available if you want to display data from Excel 2007 as a secondary data source in InfoPath 2007.

Display SharePoint Tasks assigned to the current user in InfoPath

Learn how you can use the userName() function and Conditional Formatting in InfoPath to display only those tasks from a SharePoint Tasks list that have been assigned to the user who has opened the InfoPath form.

Dynamically fill a drop-down list box in a browser form using another InfoPath form as a data source

Use the FileLocation property of the FileQueryConnection object to switch and point to different XML files when filling a drop-down list box.

Sort and filter a SharePoint list in InfoPath using a DataView

Learn how you can use C# code and the DataView class that comes with ADO.NET to sort and filter items from a secondary data source to a SharePoint list in InfoPath.

Filtered cascading drop-downs in InfoPath browser forms using SharePoint lists and WSS owssvr.dll

Learn how you can use Windows SharePoint Services' (WSS) owssvr.dll and InfoPath's FileQueryConnection to write code that filters SharePoint list data displayed in dependent or cascading drop-down list boxes on an InfoPath browser form in SharePoint.

How to add a data connection to a SharePoint list or library in InfoPath

This step-by-step InfoPath tutorial explains how to add a data connection to a SharePoint list or library and then view the structure of the secondary data source in the Data Source task pane.

How to simulate Excel's VLOOKUP function in InfoPath to look up data in a secondary data source using rules and filters

Learn how to use rules and filters to look up data in a secondary data source (here: a SharePoint list) when an item is selected from a drop-down list box and create functionality similar to Excel's VLOOKUP function, but then in InfoPath.

Programmatically check whether a value exists in a drop-down list box bound to a SharePoint list using an XPath filter

Learn how to use an XPath filter expression on a SharePoint list to look up a value in a secondary data source to which a drop-down list box in InfoPath is bound.

Programmatically copy rows from a SharePoint list to a repeating node in the Main data source in InfoPath

Learn how to use C# or Visual Basic code to copy the rows from a SharePoint list to a repeating node in the Main data source of an InfoPath form.

Programmatically create a custom SharePoint list from a repeating table in an InfoPath web-based form

Learn how you can use data from a repeating table in an InfoPath web-based form that you open on a SharePoint site to create a custom SharePoint list.

Programmatically retrieve an InfoPath form from a SharePoint library

Use the System.Net.WebClient class or Copy web service to retrieve an InfoPath form from a SharePoint library.

InfoPath 2010

Add a data connection to a SharePoint list in InfoPath 2010

Get step-by-step instructions for adding a data connection to a SharePoint 2010 list or library to an InfoPath 2010 form template.

Display who last modified an InfoPath form in a SharePoint form library

Learn how you can use a reference to the SharePoint form library in which an InfoPath form is stored to find out who was the last person to modify the InfoPath form and display this "last modified by" information on the InfoPath form.

Embed an InfoPath form in a SharePoint 2010 web part

Learn how you can use the InfoPath Form Web Part in SharePoint 2010 to embed an InfoPath 2010 web browser form in a SharePoint wiki page.

InfoPath 2010 previous next navigation on a SharePoint list

Learn how you can create an InfoPath 2010 form template with previous and next buttons for navigation through items of a SharePoint list that has been added as a secondary data source to the form template.

Recover & make changes to InfoPath forms on SharePoint

Learn how you can recover an InfoPath form template if you still have access to a working InfoPath form in SharePoint, and then go about making changes to the form template.

Use InfoPath with SharePoint Workflow

SharePoint Designer workflows

Create SharePoint Designer workflow for InfoPath form

Learn how you can create a simple SharePoint Designer 2010 workflow that runs and creates new SharePoint list items whenever InfoPath 2010 forms are saved or submitted to a SharePoint 2010 form library.

SharePoint Designer workflow to lookup manager of manager for InfoPath people picker

Learn how you can create a SharePoint Designer 2010 workflow that can lookup the manager of the manager of a user that is entered into a people picker control on an InfoPath 2010 form.

Automatically add a new item to a SharePoint list using InfoPath 2007 and a custom workflow

Use SharePoint Designer 2007 to create a custom workflow that will add a new item to a SharePoint list whenever a new InfoPath form is added to a form library.

How to create a SharePoint Designer workflow that sends an email containing a link to an InfoPath browser form

This article describes how you can create a SharePoint Designer workflow that is run whenever a new InfoPath web-based form is submitted to a SharePoint form library and sends an email, which contains a link to open the InfoPath form in the browser.

How to retrieve InfoPath form data in a SharePoint workflow

Learn how you can retrieve data that is stored within an InfoPath form either in a SharePoint Designer workflow or in a Visual Studio workflow that runs on that InfoPath form in a SharePoint form library.

Set the value in an InfoPath form from a SharePoint Designer workflow

Learn how to promote InfoPath form fields so that you can set their values through a SharePoint Designer workflow.

Visual Studio workflows

How to create an InfoPath initiation or association form for a SharePoint workflow created in Visual Studio

Learn which steps are required to create an InfoPath form that can be used as an initiation or association form in a SharePoint workflow that is created using Visual Studio.

How to set the value of an InfoPath form field through a SharePoint workflow

Learn how you can write code in a custom Visual Studio workflow for SharePoint to set the value of a field that is stored within an InfoPath form.

How to use a Visual Studio workflow to submit data from an InfoPath form to a SharePoint list

This article explains how you can use a custom Visual Studio sequential workflow on a Form Library to extract data from an InfoPath form that was submitted to the form library and use this data to add a new item to a custom SharePoint list.

Use a custom SharePoint workflow to extract a file attachment from an InfoPath form and upload it to a SharePoint document library

This article explains how you can use a custom Visual Studio sequential workflow on a Form Library to extract data from a File Attachment control on an InfoPath form that was submitted to the Form Library and use this data to add a file to a SharePoint Document Library.

Use InfoPath with Excel and Excel Services in SharePoint

Extract InfoPath form contents from SharePoint library 2010 to Excel

Learn which options are available if you want to extract the contents from one or multiple InfoPath forms that are stored in a SharePoint form library to an Excel spreadsheet.

Calculate work days excluding holidays in InfoPath 2010 using SharePoint 2010 and Excel Services

Learn how you can leverage Excel 2010, Excel Services in SharePoint 2010, and the new REST Web Service data connection in InfoPath 2010 to calculate the difference between two dates in InfoPath 2010 by getting back the amount of work days excluding holidays.

Generate random numbers in InfoPath

Learn which options are available if you want to generate random numbers in an InfoPath form either with or without writing code.

Miscellaneous InfoPath SharePoint Solutions

2 Ways to loop through InfoPath forms in a SharePoint Form Library

Learn how you can write C# code that uses the SPList, SPListItem, SPFolder, and SPFile classes of the SharePoint Object Model to loop through and retrieve all of the InfoPath forms that are stored in a SharePoint Form Library.

6 Basic SharePoint 2010 components to master for InfoPath 2010 - free online resources included

This post contains links to free online resources you can use to start learning the basics of SharePoint 2010 in preparation for starting to work with InfoPath forms, form templates, and workflows in SharePoint 2010.

Beginners programming for InfoPath browser forms in SharePoint

You only need to know how to do 3 things to be able to start writing code for InfoPath browser form templates that you deploy to SharePoint. Learn what these 3 things are.

Calculating date differences in InfoPath 2007 browser forms using C# code

Write C# code which uses the Site property of the XMLEventArgs object and the TimeSpan object in the Changed event of the date fields to calculate the difference between the dates in each row of a repeating table.

How to execute code and close an InfoPath web-based form

Learn what the limitations of InfoPath are and which options are available to you when trying to write code that closes an InfoPath web-based form.

How to send email from an InfoPath browser form in SharePoint

Learn which options are available when you want to send an email through an InfoPath form that is running in InfoPath Forms Services in SharePoint.

Printing InfoPath 2007 Web-based Forms to PDF

This article presents a technique that you can use to print InfoPath 2007 web-based forms to PDF.

Secure InfoPath forms in SharePoint using encryption

Learn how you can use encryption and decryption to secure and protect data stored in InfoPath forms that are displayed through a browser via SharePoint.

SharePoint hates default values in InfoPath forms

Learn how you can solve the 'infinite loop error' SharePoint displays for browser forms that contain too many fields on which default values have been set.

 
InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services