Submitting data of repeating table of info path form to sharepoint form  library.

Posted on 2011-10-11
Last Modified: 2012-06-27
i have a repeating table in my info path form, when i trying to store the value of multiple row of repeating table to sharepoint library. It  shows only the one of the data not a multiple row. If there any way to store the multiple row iinto the sharepoint library without the coding. If there is any way please let me know it will be great help for me. I am new in the sharepoint as well as the infopath form.
thank you
Question by:Igiwwa
    LVL 28

    Expert Comment

    No, SharePoint is a flat data structure and does not support repeating elements with a row.

    So you have to create a column for the max number of items to get them out flat or find some way of deliminating them inside one large field.  Either way not a real good solution.
    To support repeating secondary elements you need a relational database like SQL or not promote and open the form to see the data, or push the repeating elements into a seperate list, like you referenced with coding.

    Author Comment

    Thank you so much yor the reply.
    As i am new in the info path form so i don't have the idea about to do using the sql server database, or also we do using the Ms Access database. If we can you please let me know how we can do using the MS access database in detail. It is will great help to me.
    Thank you
    LVL 4

    Accepted Solution

    If you have the freedom to buy add ons, you could try the Repeating Rows Field type from Kwizcom - we are using this to replace our InfoPath forms and submit data directly to a SharePoint list.

    LVL 28

    Expert Comment

    by:clayfox has some information. has a tool / solution as well.

    Access is not probably the best solution in your scenario. Not geared for a Enterprise shared solution or really compatible with SharePoint.

    Author Closing Comment

    Actually i am not able to use other tools.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now