none
Submit data from Infopath form to SharePoint List RRS feed

  • Question

  • Hi All,

    Can any one of you explain the procedure for submitting data from Infopath form to SharePoint List?

    I would like to know Basic concepts of Infopath form in MOSS 2007 (How Infopath form plays an Important role in MOSS).

    Please help me regarding this issue

     

    Thanks In Advance,

    Kumar.

    Friday, June 4, 2010 5:22 AM

Answers

  • Two very different topics.  Please separate them into 2 threads.

    InfoPath does not submit to lists - it submits to Form Libraries.  To get your data to automatically submit to lists from the form itself, you'll need to incorporate some custom methods.  Here are some options:

    1) Use the CAML method: http://msdn.microsoft.com/en-us/library/cc162745(office.12).aspx (Jeroen referenced this link)

    2) Use the pre-built code-based method in Qdabra's qRules: http://www.qdabra.com/en/products/qRules.aspx (Submit to SharePoint List)

    3) Write your own code to do it.

    There is an indirect method, which is what I use, and that is to use workflow to create and/or update list items upon submission of the form to a Form Library.  I do this with SharePoint Designer, but you can also do it with Visual Studio if you are a developer.


    SharePoint Architect || Microsoft MVP || My Blog

    • Edited by Clayton Cobb Wednesday, June 9, 2010 6:55 AM
    • Marked as answer by Kumar9999 Wednesday, June 9, 2010 9:26 AM
    Friday, June 4, 2010 5:18 PM
  • Hi I have resolved the Issue. Please refer the following link.

     

    http://www.bronios.com/index.php/2008/08/23/error-while-writing-managed-code-for-infopath-2007-forms-infopath-cannot-add-the-event-handler/

     

    Regards,

    Kumar.

    • Marked as answer by Kumar9999 Wednesday, June 9, 2010 7:40 AM
    Wednesday, June 9, 2010 7:40 AM

All replies

  • Hello,

    You might want to check the MSDN site: http://msdn.microsoft.com/en-us/library/cc162745(office.12).aspx

     

    Jeroen

    Friday, June 4, 2010 1:15 PM
  • Two very different topics.  Please separate them into 2 threads.

    InfoPath does not submit to lists - it submits to Form Libraries.  To get your data to automatically submit to lists from the form itself, you'll need to incorporate some custom methods.  Here are some options:

    1) Use the CAML method: http://msdn.microsoft.com/en-us/library/cc162745(office.12).aspx (Jeroen referenced this link)

    2) Use the pre-built code-based method in Qdabra's qRules: http://www.qdabra.com/en/products/qRules.aspx (Submit to SharePoint List)

    3) Write your own code to do it.

    There is an indirect method, which is what I use, and that is to use workflow to create and/or update list items upon submission of the form to a Form Library.  I do this with SharePoint Designer, but you can also do it with Visual Studio if you are a developer.


    SharePoint Architect || Microsoft MVP || My Blog

    • Edited by Clayton Cobb Wednesday, June 9, 2010 6:55 AM
    • Marked as answer by Kumar9999 Wednesday, June 9, 2010 9:26 AM
    Friday, June 4, 2010 5:18 PM
  • Hi,

    Thanks a lot for your kind response,

    I have already checked the above link sent by you people.

    Everything fine expect the "Cleaning Up the Layout of the Form ".

    Let me know if you have any Queries?

     

    Regards,

    Kumar.

    Wednesday, June 9, 2010 6:29 AM
  • What?
    SharePoint Architect || Microsoft MVP || My Blog
    • Proposed as answer by EssPow Wednesday, June 20, 2012 8:25 PM
    • Unproposed as answer by Steven AndrewsEditor Monday, November 11, 2013 1:33 PM
    Wednesday, June 9, 2010 6:55 AM
  • Ok, I have resolved the Issue,

    But getting error while "Adding Event Handler Code to the Add New Contacts Check Box ".

    Infopath cannot add event handler.

    To work with visual basic or visual c# code, Microsoft Visual Studio Tools for Applications(VSTA) is required. The Microsoft .Net Framework 2.0 and Microsoft core XML Services must be installed prior to installing VSTA. To install VSTA, open Add or Remove Programs, locate your 2007 Microsoft Office system installation, and then click change.

     

    Please help me regarding this Issue.

     

    Thanks In Advance,

    Kumar.

    Wednesday, June 9, 2010 7:18 AM
  • Did you do what the error says to do?
    SharePoint Architect || Microsoft MVP || My Blog
    Wednesday, June 9, 2010 7:38 AM
  • Hi I have resolved the Issue. Please refer the following link.

     

    http://www.bronios.com/index.php/2008/08/23/error-while-writing-managed-code-for-infopath-2007-forms-infopath-cannot-add-the-event-handler/

     

    Regards,

    Kumar.

    • Marked as answer by Kumar9999 Wednesday, June 9, 2010 7:40 AM
    Wednesday, June 9, 2010 7:40 AM
  • So this event handler link was the answer to your original question, and you got your answer without any help?
    SharePoint Architect || Microsoft MVP || My Blog
    Wednesday, June 9, 2010 8:35 AM
  • It is part of the problem for my original question.
    Wednesday, June 9, 2010 9:26 AM
  • Clayton

    We tried using the sample you posted on  http://msdn.microsoft.com/en-us/library/cc162745(office.12).aspx

    but this does not work. We have InfoPath 2007 and sharepoint 2010. I wonder if this is a problem of compatibility? When we submit changes, we get the following error message:

    System.Net.WebException
    InfoPath cannot submit the form.
    An error occurred while the form was being submitted.

    The form definition (.xsf) file has an invalid mapping from the document to the submit Web service.

       at Microsoft.Office.InfoPath.Internal.MomExceptionHelper.ExecuteDataConnectionAction(OMCall d)
       at Microsoft.Office.InfoPath.Internal.WebServiceConnectionHost.Execute()
       at Template.FormCode.btnSendChanges_Clicked(Object sender, ClickedEventArgs e)
       at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
       at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

    Also, we noticed that when attempting to open the list in SharePoint, we don't see the form created in InfoPath, but rather, we see a standard form of Sharepoint? Please confirm this is due to incompatibility between InforPath 2007 and sharepoint 2010. Please advise, is there a correct version available?

    Tuesday, June 5, 2012 3:02 PM
  • Hi Clayton,

    Will the above options work for InfoPath 2010 Offline forms?

    Thanks

    Binu


    Thanks, Binu Raj V, binu.vengattu@ust-global.com

    Thursday, December 13, 2012 4:46 PM