Bind InfoPath 2010 Dropdown List With SharePoint 2010 List

Introduction

InfoPath is based on the Extensible Markup Language (XML) that can be easily designed and published.

Use the following procedure to create a sample.

1. Create a List Region and add some entries as below.
   
   
   
2. To start open the InfoPath designer and select blank form.
   
   
   
   
3. Design the form as below.
   
   
   
   
4. Select the Region Dropdownlist control.
5. On the Control Tools Properties tab, click Control Properties.
   
   
   
   
6. On the Data tab, in List box choices, select Get Choices from an external source.
   
   
   
   
7. Click the Add button.
   
   
   
   
8. Click Next, keeping the default options in the first page of the wizard.
   
   
   
   
9. Select SharePoint library or list, and then click Next.
   
   
   
   
10. Type in the SharePoint site URL, http://<SiteUrl> and then click Next.
    
    
    
    
11. Provide credentials if asked.
    
    
    
    
12. Select the Region list, and then click Next.
    
    
    
    
13. Select the Title check box in the fields list (you do not need the other fields in this form), and then click Next.
    
    
    
    
14. On the following page of the wizard, click Next.
    
    
    
    
15. Click Finish on the final page of the wizard.
    
    
    
    
16. Click Apply then OK
    
    
    
    
17. Now Publish the form.
18. In my case I have published the form in the EmployeeInformation Form library.
19. When you open the form the form will show the dropdown as below.
    
    
    
    
20. Add an entry to the form as below.
    
    
    
    
21. Entries in the Form Library are displayed as below.
    
    
    

Conclusion

In this article I have explained how to create an InfoPath and get a record in the InfoPath dropdown list from the SharePoint List.