Bind InfoPath 2010 Dropdown List With SharePoint 2010 List

InfoPath is based on the Extensible Markup Language (XML) that can be easily designed and published. In this article I am going to explain in detail, how bind Infopath form dropdown List with SharePoint List and Save the data in SharePoint repository.


Use the following procedure to create a sample.

  1. Create a List Region and add some entries as below.

    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
  2. To start open the InfoPath designer and select blank form.



    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
  3. Design the form as below.


    how to bind InfoPath 2010 Dropdown List With SharePoint 2010 List
    how to bind InfoPath 2010 Dropdown List With SharePoint 2010 List
  4. Select the Region Dropdownlist control.
  5. On the Control Tools Properties tab, click Control Properties.

    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
  6. On the Data tab, in List box choices, select Get Choices from an external source.

    how to Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
    how to Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
  7. Click the Add button.


    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
  8. Click Next, keeping the default options in the first page of the wizard.

    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
  9. Select SharePoint library or list, and then click Next.

    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List
  10. Type in the SharePoint site URL, http://<SiteUrl> and then click Next.

    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List dynamically
    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List dynamically
  11. Provide credentials if asked.

    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List dynamically
    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List dynamically
  12. Select the Region list, and then click Next.

    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List in sharepoint
    Bind InfoPath 2010 Dropdown List With SharePoint 2010 List in sharepoint
  13. Select the Title check box in the fields list (you do not need the other fields in this form), and then click Next.

    Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
  14. On the following page of the wizard, click Next.

    how to Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
    how to Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
  15. Click Finish on the final page of the wizard.

    Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
  16. Click Apply then OK

    Bind InfoPath 2010 Dropdown List With SharePoint 2016 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2016 List
  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.

    Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
  20. Add an entry to the form as below.

    Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
  21. Entries in the Form Library are displayed as below.

    Bind InfoPath 2010 Dropdown List With SharePoint 2013 List
    Bind InfoPath 2010 Dropdown List With SharePoint 2013 List

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.v


You May Also like the Following SharePoint Online Tutorials:

Leave a Reply