SharePoint list to InfoPath dropdown control


In this article i will show you how to add a SharePoint column values to dropdown control of an InfoPath form, I have explained in step by step way. Infopath form allows you create you own form and embed SharePoint list items to it.

Integrating SharePoint data in Infopath form is pretty easy, Infopath provides excellent GUI which allows you to bind SharePoint data to your Infopath form.

note: Infopath should be installed in your machine.


Open Infopath designer and follow these steps to connect SharePoint data to infopath form

Step 1: Tools -> Data connections
Step 2: Add a new data connection to receive data
Select the library or list option

pic 1


Step 3: Select from where do you want to receive your data
Select SharePoint Library or List


pic 2


Step 4: Provide SharePoint site address, use this option to provide your SharePoint site, i.e select your SharePoint URL .



pic3


Step 5: Select the list which from which you want to receive the data

pic4


Step 6: Select the fields which are needed from the list


pic5


Step 7: You can store the copy of data in the form of template If needed


pic6


Step 8:Give a name for your data connection



pic7


Step 9: Select the column which you need in the drop down box


pic8


In you SharePoint site! :


pic9


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: