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
Step 3: Select from where do you want to receive your data
Select SharePoint Library or List
Step 4: Provide SharePoint site address, use this option to provide your SharePoint site, i.e select your SharePoint URL .
Step 5: Select the list which from which you want to receive the data
Step 6: Select the fields which are needed from the list
Step 7: You can store the copy of data in the form of template If needed
Step 8:Give a name for your data connection
Step 9: Select the column which you need in the drop down box
In you SharePoint site! :