Get InfoPath to display lookup column value, not ID

If you have ever used a SharePoint list containing lookup columns as a data source in your InfoPath forms, you may have been disappointed to see the value of the lookup is not displayed. Instead of the value, the list ID of the item containing the value is displayed. My ‘Construction Line Items’ list contains three lookup columns: Project, Category, and Product. When I connect to this list fro... »

SharePoint-InfoPath 2007 Video Tutorial: Storing InfoPath form data in SQL (Part 1)

How-to video: Create an InfoPath form that stores form data in SQL Part 1: Create a web-enabled InfoPath form that stores form data directly in SQL Part 2: Create data view web parts in SharePoint Designer to display/update SQL data in SharePoint pages Part 3: Filter SQL data with a form web part and create SharePoint list items from SQL data This SharePoint video tutorial is based on a simple con... »

SharePoint 2010 Tutorial Video: Drop-Down Filters

How to video: Create Optional Cascading Drop-Down Filters on SharePoint List Forms I knew I was going to like the ability to customize list item forms in SharePoint 2010 using InfoPath. The ability to filter drop down list choices based on a previous selection in the form is something many people ask for. I have created a SharePoint 2010 tutorial/training  video that shows how to customize th... »

InfoPath Form with Multiple, Dynamic Approvers

A question came in to the MOSS Help and How To forum about creating a form that allowed multiple approvers to be specified at the time the form is being filled out. I went ahead and created a form in InfoPath and a simple workflow in SharePoint Designer to allow the selection of the approvers and assign tasks for the approvers. It is a simple form and workflow both. For production you would want a... »

Use SharePoint Lists to Create a Filtered Drop Down in InfoPath 2007

While teaching our online class on InfoPath and SharePoint Designer Workflows (Essentials of InfoPath and SharePoint Workflows), I was asked about using SharePoint list data to populate InfoPath drop-down list controls and filtering a list control based on the selection of another drop-down. Goal: To create an InfoPath form that includes two drop down lists populated from an external source (Share... »