Contents
How does a query data connection work in InfoPath?
A query data connection gets data from an external data source and stores that data in fields in the main or secondary data source of a form. You can then bind controls to those fields to display that data in the form. You can create a query data connection in the following ways:
What can I do with InfoPath in SharePoint?
InfoPath – Query Specific SharePoint List Data. With InfoPath and SharePoint 2010, one of the awesome new capabilities is that you can query specific SharePoint list data from data connections that receive from SharePoint lists and libraries.
Can You disable submit data connection in InfoPath?
You can choose to disable the Submit feature if you want your users to submit their completed forms by using another type of submit data connection. In most cases, you will configure one submit data connection as the main submit action for your form template.
How to set region and state fields in InfoPath?
Place the Region and State fields on the form as drop-down boxes. For the Regions drop-down box, set it up like this. Be sure to set the value as ID and the Display name as title. For the States drop-down box, set it up like this.
Certain of those InfoPath fields (as you decide) are exposed to SharePoint and will appear as fields in the Forms List. As Ashish said, the data is stored in an XML file. You can download InfoPath file as XML from Form Library and open by using text editor to check stored values in the form.
How are regions and states different in InfoPath?
There are two lists: Regions and States, both custom lists. Regions has one field called Region, just a text field. States has two fields: Region is a lookup to the region field in the list of regions, and State a text field. The states list is much longer than the regions.
With InfoPath and SharePoint 2010, one of the awesome new capabilities is that you can query specific SharePoint list data from data connections that receive from SharePoint lists and libraries. This applies to all versions of SharePoint 2010 and Office 365, and is compatible with BOTH client based and browser-based forms.