SharePoint

Articles, tips & tricks, and guidance on how to use InfoPath with SharePoint, InfoPath Forms Services, SharePoint Form Libraries, SharePoint Lists, and SharePoint workflows.

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.

3 Ways to use InfoPath forms in Office SharePoint Server and WSS 3

Learn what InfoPath forms can be used for or as in Microsoft Office SharePoint Server (MOSS) 2007 or Windows SharePoint Services (WSS) 3.0.

Filter and sort 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.

How to upload a document 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.

2 Ways to retrieve the SharePoint site collection URL of an InfoPath browser form

Learn how you can write C# code in an InfoPath browser form to be able to retrieve the URL of the SharePoint site collection that the InfoPath form is part of.

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.

10 most popular InfoPath / SharePoint articles on BizSupportOnline

Learn which SharePoint and InfoPath articles and videos on BizSupportOnline received the most views and were found to be the most helpful in the past few months.

Use a custom SharePoint Designer workflow activity to upload images from InfoPath to a SharePoint Picture Library

Learn how you can use an InfoPath browser form, file attachment controls in a repeating table, and a custom SharePoint Designer workflow activity to upload and store images in a SharePoint Picture Library.

Writing to the Windows Event Log from an InfoPath browser form

If you're writing code in VSTA for an InfoPath browser form, want to debug it, but do not have Visual Studio, you can use the workaround described in this post.

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.

Top 10 bestsellers among InfoPath and SharePoint books in 2009

Learn which InfoPath, SharePoint, and SharePoint Designer books were bought in 2009 and read by visitors to BizSupportOnline.NET.

Pre-filtering large SharePoint lists in InfoPath using WSS's owssvr.dll

Learn how you can take advantage of Windows SharePoint Services' owssvr.dll to filter a long or large list of data in a SharePoint list before the data is returned to an InfoPath form and used to populate InfoPath controls.

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.

Trick: Create InfoPath forms using a SharePoint Designer workflow

Learn how you can change the settings and default template on a SharePoint Form Library in such a way that it enables you to use a SharePoint Designer workflow to automatically create InfoPath forms in that SharePoint Form Library.

Use a custom SPD action to extract an attachment from an InfoPath form and add it to a SharePoint document library

Learn how you can create a custom SharePoint Designer activity that can be used as an action in a workflow that runs on InfoPath forms to extract an attachment from an InfoPath form and upload it as a file to a SharePoint document library.

Archive or move InfoPath forms in SharePoint

Learn how you can use a SharePoint content type and a SharePoint Designer workflow to move InfoPath forms in SharePoint from one library to the other as a way of archiving InfoPath forms in SharePoint.

3 Ways to deploy InfoPath form templates to SharePoint

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

Send email from SharePoint based on values in an InfoPath form

Learn how you can access InfoPath form fields from a SharePoint Designer workflow and use a condition in the workflow to take action based on the value of a field in the InfoPath form.

InfoPath Q&A: Can InfoPath be used with Oracle databases for data gathering and reporting?

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.

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.

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 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 add, update, and delete SharePoint list items via InfoPath

Learn how to write code in InfoPath that makes calls into the SharePoint object model to insert, edit, and delete items in a 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.

Best of BizSupportOnline – 2008

Learn which InfoPath articles on the BizSupportOnline.NET web site and blog got the most attention during 2008.

Submit repeating table rows from InfoPath to a SharePoint list using the SharePoint Object Model

Learn how you can combine two InfoPath solutions to be able to submit rows of a repeating table in an InfoPath form to a SharePoint list using the SharePoint Object Model (OM).

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

Learn how you can use the stsadm command line utility to run the administrative timer jobs for InfoPath forms that get stuck during an administrator-approved deployment.

Step-by-step instructions for setting up InfoPath Forms Services using Office Forms Server 2007 and WSS 3.0

Learn what steps are required before you can use InfoPath with Forms Server 2007 and WSS 3.0 to create and deploy forms that can be filled out through a browser.

5 Ways to submit an InfoPath form to a SharePoint list

Learn which workarounds are available if you want to submit the data from an InfoPath form to a SharePoint list.

"Microsoft.SharePoint.SPException: The security validation for this page is invalid." error in InfoPath browser forms

Learn how you can use the SPWeb.AllowUnsafeUpdates property to prevent the 'The security validation for this page is invalid.' error from taking place when you run code that calls directly into the SharePoint object model from within an InfoPath browser form.

InfoPath Q&A: How can I use InfoPath forms without having InfoPath installed on users' PCs?

Learn which software products are required if you want to use InfoPath 2007 forms, but not install the InfoPath client application on the PCs of users who must fill out forms.

How to enable InfoPath Forms Services in WSS v3

Learn which components you need to install before you can enable InfoPath Forms Services to work in WSS version 3.0 and display InfoPath forms in a web browser through SharePoint.

InfoPath Q&A: Does InfoPath support cascading drop-down list boxes in a repeating table?

Learn which options are available to you if you want to filter lists on an InfoPath form to create cascading drop-down lists.

How to copy data from a secondary data source (SharePoint list) to a repeating table in the Main data source of an InfoPath form

Learn how you can use code that either loops through a repeating node or uses an XSL transformation to copy data from a secondary data source to a repeating table in the Main data source of an InfoPath form.