.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

Is there any way to populate an InfoPath form field with the data from the site content type column?

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :SharePoint

I have a Form library with a form template.

The templat has a field "Office name" which should not be a fixed list of values, but a dynamical list, feeded from a different type of form. I'm a novice with InfoPath - Sharepoint and I want to find out, how can I can give users a possibility to create and maintain a list of offices and also have this list as a selection list inside main library form - ALL inside one library, if possible.

I assumed that if I publish main form (Itinerary) as a library template form and lookup form (OfficeInfo) as a SiteContent, I should be able somehow to connect to siteContent column and it's information. But I cannot see how - Site Content Gallery is not appering as a Connection item.

Can I use SiteConenct for this purpose or there are other ways to create end-user lookup lists?

Thank you!


View Complete Post

More Related Resource Links

Site content type's column with wrong field type that was created once will not work if re-created


I've created the column 'MyDescription' with type 'Multiline Enchanced Text' in my custom content type derived from 'Page'. But later I understood that 'Publishing HTML' is better for me. I've removed the 'MyDescription' column and recreated 'MyDescription' with type 'Publishing HTML'.

Page layout for my custom content type uses this code to display field

<PublishingWebControls:RichHtmlField FieldName="MyDescription" runat="server"/>

But page falls without any error information. I've deleted and recreated page: it fell always.

When I created column 'MyDescription1' with 'Publishing HTML' type in my custom content type and changed code to this


How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

Form opening in infopath client despite Content Type settings "Display as a Web Page"

Hi all,   I have a strange behavior with my forms. The infopath template is defined as Content Type for my Form library, in the advanced settings I have checked "Display as a Web page" for the "Opening browser-enabled documents" setting. Despite that when the client is availble on the computer which is browsing the Form Library, I'm asked to "Open", "Save" or "Cancel" instead of opening the form in the browser.   Any idea why this is happening ?

Map an InfoPath form field to a SharePoint column

I am trying to create a custom SharePoint list template feature (feature.xml, schema.xml, the whole nine yards), which is based on the OOTB XML Form Library in MOSS 2007. I copied the XmlFormLibrary feature out of the FEATURES folder on my SharePoint server, and made a few minor modifications (changed the feature name, new GUID, added some fields in schema.xml, created a new content type for it, etc...).

What I ultimately want to do is publish an InfoPath form template into it as the document template for the library, and I would like to be able to map certain fields in the form template to fields in my custom SharePoint library template. In InfoPath, I open the Publishing Wizard and go through the typical steps to publish to a Document Library. I then choose the columns in my form that I want to promote to fields in the form library, and select the appopriate fields to map to in the form library. I publish the form, and do not get any errors or warnings.

However, when I choose "New" from the form library and fill out the form and save it, only certain fields in the library are actually being populated from the form. Specifically, this seems to work fine for a date/time field I am using, but does not work for the "Location" field. I am using the OOTB "Location" field from the "Core Contact and Calendar Columns" group. Ev

auto-populate infopath form with sql server data connection



is it possible to auto-populate an infopath form with a sql data connection?

i have a form that only populate the username of the logged in user. but i want to use a secondary data source to auto-populate the user his email, id and department all comming from a sql server database.

and after that auto-populate the user's manager name using sql server db

is this possible in infopath 2007 and how can i do this?

publish infopath form to sharepoint services 3.0 as content type



can an infopath form be published as content type to a sharepoint services 3.0 form library?

i have created 2 form libraries. one to store the tamplate an the other to store the form itself and where you can open a new form.

but whenever i click new to open a new form i get this error message:

the element "comment" is used but not declared in the DTD/schema.

does any one know what this error could be?

Need help on Select button column in Data Grid to populate fields in Form View


 When I have a select a row in a Data Grid that when I click on it I want it to show the info for the person I selected in a form view on the same page as the Data Grid. Here are the columns for the Data Grid that I have set up, the column is highlighted:

<asp:DataGrid ID="MHGrid" AutoGenerateColumns="False"  
        DataSourceID="MHFoundation" DataKeyField="POPULATION_LIST_ID" 
        AllowPaging="True" AllowSorting="True" BorderStyle="Solid" 
        BorderColor="#999999" BorderWidth="3px" CellPadding="4" PageSize="4" 
        CellSpacing="2" runat="server" BackColor="Gray" Font-Bold="False" 
        Font-Italic="False" Font-Overline="False" Font-Strikeout="False" 
        <SelectedItemStyle BackColor="#FF9900" Font-Bold="False" Font-Italic="False" 
            Font-Overline="False" Font-Strikeout="False" Font-Underline="False" />
            <asp:ButtonColumn CommandName="Select"  Text="Select"></asp:ButtonColumn>
            <asp:BoundColumn D

Cannot delete certain site column(s) from new content type



I make a new content type, based of event.

If I add the (existing) site columns, Active, Aliases, Article Date, Byline (and some others?), these columns cannot be deleted afterwards!

is there a workaround ? 

Thank you 

P.S. After testing, this also happens in 2007.



InfoPath 2007 Form Content Type does not save as infopath form but as xml document.


I have a couple of infopath forms deployed to sharepoint as content types. Normally, when a user creates a new document of an infopath content type, the form opens in browser mode and ,when the user fills in the form and saves the form, a new document is created in the document library with the correct icon and progid.

This was before... Now, whenever I save a form, the form submits correctly, i see the file in de document library, BUT it has the icon of an XML document, all the infopath functionality is gone and when I click the file, I get a save as dialog...

The form itself hasn't changed that much and even when I redeploy a version that worked before it still does not work. However, when I create a new doc lib and associate the malfunctioning form there, the behavior is normal and i can still reopen the saved form.


Little sidenote: I have 7 different forms that now do not work on my test machine. It used to be only one, but after redeploying them, all of them have the same problem. Now when I deployed these forms in a production environement, the same thing started happening there. So I stopped the deployment and in production there is just the newly deployed form that does not work.

I have already tried reassociating the form to the doc lib. And everything looks normal in central administration.

Any suggestions?


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!

Provision an InfoPath form template in a content type, with "view in browser" option

Hi all.
I've to provision an InfoPath form template in SharePoint 2010 within a content type, and my form must be open in a browser.
The provision of the .xsn file and of the content type goes well, but my form always open in the client and not in the browser. Instead, if i publish my form from InfoPath 2010 using the "Publish" option and i select to publish my form within a content type, everything goes well. I can see the form in the browser.

Here is my code.


<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
 <Module Name="OpeningJeans" Url="_cts/MY CONTENT TYPE" RootWebOnly="TRUE">
  <File Path="InfopathModules\MyForm.xsn" Url="MyForm.xsn" />


<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
<!-- Parent ContentType: Form (0x010101) -->
 <ContentType ID="0x0101

MultiLine site column in content type is displayed as NoteField in SPD2010



Problem: When I create a new page layout in SPD2010 based on a custom content type a MultiLine Site column is displayed as:

<SharePointWebControls:NoteField FieldName="6d38fdd6-c4a2-40a0-8da7-8dae477b653e" runat="server"></SharePointWebControls:NoteField>

The user is, of course, not able to add Richt text to it!

Question: I need it to be a RichtTex

Assigning External content type field column value using Client Object Model


I have a problem assinging External column value to ListItem object with client object model-based application I'm developing. To be precise, I am able to retrieve data related to external content type by reading external list created from this content type but I don't know how to properly use it to assign value to this field. By doing some research on my own I concluded that BDC ID column from external list is the way to go since it uniquely defines selected row from external list but that doesn't tell me much since I don't know what to do with it. Currently I ended up with partial solution - to assign plain string value of picker column but that makes this value visible only in "View Properties" option on Sharepoint and not in "Edit Properties" which pritty much makes sence since it isn't properly related to rest of the data in specific row. Does someone have a better solution for this?

Igor S.

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.

InfoPath 2003 - Populate Data Field based on text field from secondary/different data source.


I have a form where the main fields are populated based on the results of a query field.
Ex, Main Data (SQL) Source: 

Fruit         Color
Apple       Red
Orange     Orange
Pear         Green
Banana     Yellow

Secondary Data Source (Sharepoint List)
Fruit         Code
Apple        1001
Orange     1002
Pear         1003
Banana     1004

What I would like to do is create form fields that will automatically populate based on the contents of the text field.
Ex,  (text field)   Please enter your fruit of choice:   [ Apple ]

(Field 2 - from main SQL data source)          The color of your fruit is [ RED ]

(Field 3 - from secondary Sharepoint List data source)  Your fruits code is  [ 1001 ]


Any suggestions would be greatly appreciated.

Error: Updating Site Content Type Failed - InfoPath 07/SharePoint 07


I have been working with InfoPath07 and SharePoint Moss 07 for two years.  I have recieved the Updating Content Type error in the past which I got around by creating new library's. This was over a year ago and happened only a couple times.

Recently, my dept did a database migration.  About 3 weeks prior to the migration I started having troubles with publishing InfoPath.

First issue, it would take about three hours for my form to go through to the form/document library.  Sometimes they would publish, other times I would get Updating Content Type Failed.

Now that our databases have been migrated, I don't have to wait three hours to get my error.  I get my error on (1)existing forms that just needed interface updated (no changes to forms content), (2) existing forms that have no content at all, (3) and brand new forms that have never existed, with no content.

I have tried:

  • Deleting some content (fields)
  • Deleting all content
  • Deleting the entire library and starting fresh (including any content types in Central Admin or workflows associated)
  • Creating a brand new form with no content type

I have been researching and trying to figure this issue out for at least three months. I am still getting this error with every form I publish to update the forms library; howe

InfoPath form as a content type for SharePoint List


 Hi All,

I have designed a InfoPath form and published that form as Site Content type and it is stored in to Shared Document library. I want to set this content type into sharepoint list. So when the user selects "New Item" then the InfoPath form should be opened and user can fill the data and it is stored in that list. And also i want to use SharePoint Object Model to break the permission of the InfoPath form.

Can you please help me?




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