Click here to Skip to main content
13,354,886 members (89,883 online)
Click here to Skip to main content
Add your own
alternative version


5 bookmarked
Posted 2 Jun 2009

How to add a SharePoint list data connection to an InfoPath dropdown list box

, 2 Jun 2009
Rate this:
Please Sign up or sign in to vote.
This article will show you how to populate an InfoPath dropdown box with values from a SharePoint list.


If you have a SharePoint list and want an InfoPath dropdown list box populated from the list, follow these steps.

Also, if you have tried to use an XML data connection to populate a dropdown list box when using a browser-based InfoPath form with Forms Services and have received an error when submitting, you may want to use a SharePoint list instead.


  • Step 1 - Create or use an existing SharePoint list
  • Step 2 - Add a SharePoint list data connection in InfoPath
  • Step 3 - Check the dropdown list box values

Step 1 - In SharePoint, use an existing list or create a custom List

(Note: To ensure that users have access to the list when they fill out a form, the custom list is best located under the same SharePoint site as the form library)


Step 2 - In InfoPath 2007, open the drop-down list box properties, select Look up value from an external data source  and click Add:


Select Create a new connection and select Receive data:


Select SharePoint library or list:


Enter the URL location for the SharePoint library:


Select the name of the SharePoint list:


Select the field(s) you want available in the InfoPath list box:


Do not select Store a copy of the data in the form template:


Give the data connection a name (can be the same as the SharePoint list name) and make sure 'Automatically retrieve data when form is opened' is selected:


Click on the icon next to Entries to select the field to display in the dropdown list box:


Select the custom list and then select the Value and Display Name:



 Step 3 - In InfoPath 2007, preview the form and check the dropdown list box values:



This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Catherine Wright
United States United States
Sr. Technical Project Manager

You may also be interested in...


Comments and Discussions

QuestionNice one Pin
jyothis7729-Sep-14 22:05
memberjyothis7729-Sep-14 22:05 
QuestionMax Number of Lists as Data Source Pin
aarenz15-Dec-09 10:15
memberaarenz15-Dec-09 10:15 
GeneralSorting Pin
pete.guerette11-Aug-09 10:52
memberpete.guerette11-Aug-09 10:52 
GeneralRe: Sorting Pin
aarenz15-Dec-09 10:12
memberaarenz15-Dec-09 10:12 
GeneralRe: Sorting Pin
thekryten8-Feb-10 12:18
memberthekryten8-Feb-10 12:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.180111.1 | Last Updated 2 Jun 2009
Article Copyright 2009 by Catherine Wright
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid