.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Using infopath and SharePoint together for selecting a single attribute and having the other data au

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#


Version: Infopath 2007

I have a process that is currently handled in SharePoint with the following data (employee ID ((4 digit ID)), employee name, employee contact, employee start date etc.) in multiple columns.  I would like to create a new employee form that will autofill the information from my SharePoint site into the fields I want populated.  So if I choose employee ID 1234 I would like the employee name, employee contact, and so forth to fill in the appropriate box on my form.  The data is already populated in my SharePoint site but I am just having a hard time getting this to work.  Infopath recognizes my SharePoint site but I cannot get the autofill function to work. 

Also on this form I would like to include other functionality. I only have 4 employee types (A, B, C, D) but when a employee starts with the company we have a list of multiple choice questions that have check boxes under each question but you can only choose one.  So I would like to have a sheet that if I select employee type A all the questions that are not related be either grayed out or disappear and have the form only show the items that are appropriate for the employee type. 

If anyone is willing to send a sample of what I am looking for that would be great!  I only need one example to go off of.


View Complete Post

More Related Resource Links

Submitting InfoPath data to a SharePoint 2007 List

Clayton, i sure hope you get this.  I would like to let the form get published to the form library and then workflow can create the new list item with all the required metadata mapped.  if data is updated i would like for the list item data to update as well.  currently i have an infopath form that is web-enabled.  i several views based on a status field as which view to open to.  this form have drop-down fields linked to list already on the sharepoint site.  i have tried using the "Submitting Data from Infopath 2007 to Sharepoint List" and it works as designed but unfortunately i cant customize the fields.  i need a dynamic user friendly form with drop downs etc.  any suggestions?

Best way to display data of a single column from a Sharepoint Custom List

I'm trying to create pages that will automatically populate with data pulled from a sharepoint list (like title, department, contact info, etc.).   I'm using publishing pages. What would be the easiest way to do this, and how would I specify which data to pull from the list? For example, the page would be set up like this: [Title:biology] [Department:biology] [Contact Info:biology]   and when the page loads, it would look like this: Biology Lab Biology Department 123-456-7890   I want it to just pull the data -- I don't want a list view or anything like that.  I need this page to look pretty, and I need the each column's data to show up in a very specific place. How could I make pages that would do that?

Infopath Form Data submitting to Sharepoint 2010 List

Making a Client intake form that once submitted will send data to  a sharepoint 2010 List called contacts. Short Summary the form will have repeating fields and alot of information to submit. I have looked and read all over but I cannot find an easy step by step guild on how to submit the form data like that. Long Summary on the sharepoint site a button will open a form for adding a new client.  once the form has been filled out and the user hits submit sharepoint will then create a User File, in clients file, and take the data and put it into contacts list. I am trying to make use of Sharepoint as I would with access, meaning the more information I have on a client the easier it will be to mail merge letters, motions, basicly any file prepaired stuff. So once I have css designed forsharepoint to make it look the way I want then the forms should intergrate perfect

Getting error while retrieving data from sql server 2008 to infopath 2007 in sharepoint 2007

Hi, I have created an InfoPath form in InfoPath 2007. In this form I am getting data from SQL Server. To do this I have created data source for SQL Server 2008’s Tables. I have created 4 connections for 4 tables. When I am previewing this form from InfoPath Designer 2007, it is working. But when I am publishing this, it is giving me an error ‘Can not update content type’. If I skip this error then my form published but when I open this form from Share Point 2007. It gives me an error:   There has been an error while processing the form. Click Continue to resume filling out the form. You may want to check your form data for errors. Click Start Over to load a new copy of the form.   An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID: 6932 G. Goyal

SharePoint Data Source for InfoPath Issue

I've setup an InfoPath form which uses web services to pull an XML data source into the form.  The form works great internally, but when users on the extranet try to use it they get a "Cannot Access Data Source" error.  I have tried connecting to the web service via the extranet and it works just fine, but as a data source in the InfoPath form, extranet users cannot access it.  I've tried using both the intranet and extranet paths to the web service with no luck.  Any ideas?

import data from infopath xml forms to SharePoint list

Hi. I have this issue, a customer has an old application that consists of a SharePoint 2003 site and a 'forms library' with forms listing information about physical servers. The infopath (2003) form is pretty straight forward and has a few dropdowns from lists and so on. Now, we need to move this to 2010 and preferably to a list only using oob functionality. I would like to know if anyone has a clue as to how I can get the data from the hundreds of xml files into a list, could be to excel and then to SharePoint, or any means Necessary. I would prefer it if it can be scripted or done using standard tools from Microsoft, no 3rd party custom xml importer...(if it's not really good and free :-) ) ThanksThomas BalkestÃ¥hl - Technical Specialist - SharePoint

Infopath bug in windows 7 to convert datasource to data connection library in sharepoint?

Any ideas about this bug: Windows 7, infopath 2007, did not check in the data connection file when converting a data source? Also it did not set title and kept the file checked out so that you can not even update the items by SharePoint UI. I did everything successfully with Infopath 2007 on a windows xp machine. Is the OS related in this case? Thanks,

SharePoint 2010 External Content Type and InfoPath 2010 - Numeric data type fields missing in InfoPa


Connected SQL data table to SP 2010 ECT from SQL table.  The SQL table has several fields that have a type of "numeric(3,0)".  The SP 2010 list shows all fields form SQL.  When we open up InfoPath Designer and reference the SP List data (from SQL) all of our numer fields are missing from the available fields list.

I amd going to try another data type but that hardly feels like a solution.  If anyone has any ideas please let me know!

update SharePoint list with data from infopath form using the Command Prompt or similar


i have a InfoPath form that is updating a SharePoint list when it is submitted. Now i added some extra Fields to the Sharepoint List. All these new Fields are empty till I open the InfoPath form and hit the submit buttion again.

Is there a way to update all the empty fields from the old entrys I made.

My first Idea was to search for a Powershell Solution but unfortunately I am using Windows Server 2003 R2, Sharepoint 2007 and IndoPath 2007.

Hopefully someone can Help ;)

thanking you in anticipation

Loop through SharePoint list and copy values into InfoPath Main Data



i have the following problem, i designed an Infopath form which should display the data (in a repeating table) from a SharePoint list, which is connected to the form.

 I found the following code in the internet to copy rows from a sharepoint list to a repeating node in the Main data source and followed the tutorial.

Public Sub CTRL48_6_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs)

      Dim secDSNav As XPathNavigator = DataSources("Projektsummary").CreateNavigator()

      ' Zeilen aus der Projektsummaryliste auslesen
      Dim rows As XPathNodeIterator = secDSNav.Select( _
      "/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW", _

      'Dim Current As XPathNavigator
      'Loop durch die einzelnen Zeilen der Liste

      While rows.MoveNext()

        Dim name As String = rows.Current.SelectSingleNode( _
        "/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Title", NamespaceManager).Value
        Dim nummer As Object = rows.Current.SelectSingleNode( _
        "/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Projektnummer", NamespaceManager).Value

        ' Werte der wiederholten Tabelle (main data source) übergeben 
        AddItem(name, nummer)

      End W

Submitting data from Infopath 2010 to a Sharepoint 2010 list fail


Hello everybody,

I'm trying to submit data from an Infopath 2010 form to a Sharepoint list using the following tutorial: http://msdn.microsoft.com/en-us/library/cc162745(office.12).aspx 

However this doesn't work. The form creates new entries but when you whant to change or delete an entry, I get the following error: Object reference not set to an instance to an object. Any idea what is wrong with the code?

using Microsoft.Office.InfoPath;
using System;
using System.Windows.Forms;
using System.Xml;
using System.Xml.XPath;
using mshtml;

namespace Sharepointupdate
  public partial class FormCode
    // Membervariablen werden in browserfähigen Formularen nicht unterstützt.
    // Schreiben und lesen Sie diese Werte stattdessen aus dem FormState-
    // Wörterbuch, indem Sie Code wie folgt verwenden:
    // private object _memberVariable
    // {
    //   get
    //   {
    //     return FormState["_memberVariable"];
    //   }
    //   set
    //   {
    //     FormState["_memberVariable"] = value;
    //   }
    // }

    // HINWEIS: Das folgende Verfahren ist für Microsoft InfoPath erforderlich.
    // Es kann 

How to change the way the infopath form saves data in SharePoint library (Ex: Person/Groups field is

Person/Group field is taken as an integer field in SharePoint form library when a form is submitted. I need to retain it as Person/Group column in the SharePoint form library too. Please help on the same. Thanks.

Auto populate the list data into infopath-- sharepoint 2007


I have a list with Job code,Apply online,Name.. as columns with two workflows.

When a new item is created in the list,workflows will run(mentioned the workflows below).

1.Job code ---Setting a unique number to JobCode field(i.e 1 and the next Jobcode wil be 2....)

2.Apply Online(it is a hyperlink)---Storing the infopath url into this ApplyOnline field.

Now on clciking on the list item,we will get dispform.aspx page then on clciking on Aply Online field then infopath form wil open.

Infopath has Job code field as Text box.

Now,I want to auto populate the infopath form with the corresponding list job code field.

help me on this.



Building InfoPath forms against Sharepoint 2010 Data Connection Library and Form Services...


Hi Sharepoint Experrts,

I'm trying to develop InfoPath 2010 forms that use External Lists that have been created in Sharepoint Server 2010.  I have problems when testing the forms because access is denied to the external lists.

When I try deploying the forms to the sharepoint site, I cannot upload the form template because it says I have to be a member of the local administrators group.  However, I'm running the administrator account used to install and setup sharepoint on the Windows 7 development machine I'm using.

I also tried loading the InfoPath Data Connections to a data connection library on my Sharepoint site... I can see the files when I login to the site but when I try creating a New form from a Data Connection File, I get an error message "This location does not contain any data connection files with the appropriate settings".  What ARE the appropriate settings?

I'm just really confused about this because I cannot seem to be able to build forms that use data connection files loaded onto a Sharepoint site or central server....

I appreciate any help I can get!




Thanks, KBW

Selecting a Task List in Sharepoint Designer 2007 while setting up "Collect Data from User"

When using Sharepoint Designer 2007 to Collect Data from User the task list cannot be selected.  Instead the Task list that is defaulted is the most recently created Task List.  How can I select a specific Task list to associate with"Collect Data from User"?

Integrating InfoPath 2010 Forms with the SharePoint 2010 Data Connection Library

Learn how to create a data connection library on SharePoint Server 2010, and create a UDC file in InfoPath Designer 2010 to define a SharePoint List connection.

How to pull data from SharePoint List to Infopath field?

I have customer's name, address, account number, etc in Sharepoint list. In infopath I have a field's like Customer Name, Address, Account number..I created a data connection for Customer's name and I want to populte the related data of that customer in Infopath field by calculated formula or something. When ever we pull some one's name ..I need that customer's Address and other details about him in INfopath form. The data should keep changing if I pull out some other customer's name..Does any one know how to do this? Seems simple..but not able to it though...
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend