.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

Get fields from InfoPath?

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

Hi all

I am using an web enabled infopath form to register leads for our crm system from sharepoint.

I want to get data from theese fields in infopath, and put them in our crm system, via a web service. I am using MOSS 2007 Enterprise.
I am having problems retrieving the fields from infopath, and map them to crm.

Any suggestions how that can be done or samples would be highly appreciated.


View Complete Post

More Related Resource Links

Changing fields while updating an InfoPath Form to a SharePoint 2010 Document library

My document library has following EventReceiver: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Receivers ListTemplateId="101"> <Receiver> <Name>EventReceiverDocumentLibraryItemUpdating</Name> <Type>ItemUpdating</Type> <Assembly>$SharePoint.Project.AssemblyFullName$</Assembly> <Class>EventHandling.EventReceiverDocumentLibrary</Class> <SequenceNumber>10000</SequenceNumber> </Receiver> </Receivers> </Elements> Updating a browser enabled InfoPath form in the document library fires following event: Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties) Try Me.EventFiringEnabled = False properties.ListItem("Lastname") = "Testperson" properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = True properties.ListItem.SystemUpdate(False) ' solution 1 properties.ListItem.Update() ' solution 2 properties.ListItem.UpdateOverwriteVersion() ' solution 3 properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = False Me.EventFiringEnabled = True MyBase.ItemUpdated(properties) Catch ex As Exception Me.EventFiringEnabled = True E

Using UserName to enable disable access to InfoPath form fields

Hi Everyone, I have created a browser enable form in InfoPath and restrict certain fields depending on the official logged on User Name. Now this works most of the time but my problem has to do with the "case" of User Names for some of the site users. In most cases the User Name is an exact match but for some reason, some user's names are reported by SharePoint (the Welcome at top of screen) with some parts captilized. Example - my hidden filed on the form reports my user name as xrs_master but the Welcome up top says XRS_Master - and the fields act as though I am not the correct user and won't enable. On the other hand there are users who's user name matches the case exactly and all works fine. Why is SharePoint reporting the user name differently? And if this is the reason they don't match, how do I fix it? Any Ideas? Many thanks in advance for help!

How to sum up InfoPath calculated fields

I have a repeating table with calculated fields on each row.  At the end, I need to sum up all these calculated fields into total.  Which total is also a calculated field to sum up 2 calculated fields in the repeating table.  The total never show anything after data entry.  How can I sum up total from the calculated fields?  For example: QTY 1 of a Computer would cost $1000.  In the repeating row, I will allow customer to fill in multiple rows.  A field named line item total is a calculated field named EXTCOST which is set to QTY X Computer = $1000.  At the bottom of the form, I would like to sum up EXTCOST to get the Grand Total Cost.  The Grand Total Cost is fomat as SUM(EXTCOST) which is zero at all time. Please advise. Brian.

How to remove * for validation fields in Infopath 2010



I am using Infopath 2010 and i had written validation rule for a fields.While loading the form field is showing with red * mark.It will go away as soon as i enter value but i don't want to diaply red * even i don't enter value just display a tooltip message saying that "Please enter vale" on submit button click.

Please help me in this out?


Update Infopath Fields with SharePoint Designer Workflow


Hi All,

Is there any way to update InfoPath Field and column with SharePoint Designer Workflow? I have an InfoPath Form Library on which I have published an InfoPath form. Now I want to change values of submitted infopath forms using SharePoint Designer Workflows ?

For your Information:

I am using SharePoint 2007 updated with SP2.




Update Infopath Fields with SharePoint Designer Workflow


Hi All,

Is there any way to update InfoPath Field and column with SharePoint Designer Workflow? I have an InfoPath Form Library on which I have published an InfoPath form. Now I want to change values of submitted infopath forms using SharePoint Designer Workflows ?

For your Information:

I am using SharePoint 2007 updated with SP2.

load users records in infopath fields without using "run the query" button



is it posible to instead of clicking the "run the query" button to load the users records in the fields that the fields load automatically.

can this only be done with a role and a "set a value's field" action? 

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!

Workflow <=> Infopath Fields


I have an initialisation infopath-based form with text fields in it (ad accounts, like domain\user).

Can i make an input field like in sharepoint field of "User or Group" Type, where u can search users over domain?

Projected Fields not available in InfoPath data connections


Projected fields are a nice way to join lists and show fields from related lists in the same view without physically duplicating fields. Unfortunately, these projected fields are not available in InfoPath data connections. I am now tempted to duplicate data and to maintain physical copies of fields in multiple lists to overcome this limitation, but it makes me uneasy ;-) 

I must add, the InfoPath form is a list based form without code behind. 

If you guys have a better idea, please let me know. thanks.


fx Controls instead of Drop Down Lists for Lookup fields in InfoPath Secondary Data Connections


I have a secondary data connection with a lookup field into another list. To display the fields text value instead of the index, I am using a drop down list which gets its choices from the linked list. This information is read-only so I disabled the control via formatting rule.

A calculated value control might be better suited, but my XPath skills are not very "developed". Has anyone done this before? Taken the index from the bound field and extracted the text value from a second data connection? Thx


Show/Hide fields on InfoPath based on context User Group Membership

I am reading a book on SharePoint 2010 Development by Wrox and although it is a good book, the InfoPath section is limited. I am Googling to see if I can find anywhere where i can perhaps have this type of functionality to hide and show a specific field based on their Group Membership?
Victor Palma

InfoPath Repeating Fields Bindings


there is a form lib

in its template there is a repeating table

when i bind fields to sharepoint list only options are:

  • first value
  • last value
  • united values
  • number of values

I want to be able to point all the values. It is expected that there will be over 10 lines.

Is it possible ?

Infopath will not allow to customize list forms if the list contains lookup fields with "link to ite


I am posting this here, because the error message is a little misleading: It will say that you may have an incompatible field types, corrupt fields, or fields are mandatory and should not be. As a remedy it's suggested to either make them non-mandatory fields or to delete them and recreate them.

Solution: Just lookup to your field without the "link to item" option. 


Infopath 2007 Form with the repeating / non repeating fields in the same table



Hi ,

I am trying to create infopath 2007 form with the repeating / non repeating fields with in the same table. Basically i have to get the few column values  from the sharepoint List and remaining will be free text.


A     B   C     D      E    F  

x    x    x     e        a    y

x    x    x    s      s     g

x    x    x    h       t    w

x    x    x    j       h    t


X - Values getting from the sharepoint list by using repeating table

remaing values should be not repeating fields and  should be text fields.

anyideas on this. please let me know.



Check the InfoPath all mandatory fields in a section


We have created an form in our company with the InfoPath 2010.
This form must not changed, so it must be digitally signed. Because this form has many required fields, we don't want that this incomplete form can be saved.

How can we hide the section to the signed, as long as all the required fields are not correctly filled in?

Validate Fields in InfoPath form 2010 before submit


I have designed a InfoPath form with some fields and a Submit Button which has got

Submit Action,

when the Submit button is clicked before it gets submitted to sharepoint list, i want ot validate all the fields

how could i do this

or should i use rules,

but using rules can i submit data to sharepoint list(if possible how)


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