Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
InfoPath Repeating Table Data to SharePoint List

Answered InfoPath Repeating Table Data to SharePoint List

  • Thursday, June 07, 2012 5:56 PM
     
     
    Sign In to Vote
    0
    Is there a way to view the infopath repeating table data in a list form or datasheet view?  For example, if i have a repeating table that have 5 rows of data, without opening the form, can i see the 5 rows in a sharepoint list?
     

All Replies

  • Friday, June 08, 2012 7:01 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Tang,

    For this issue, if I don’t misunderstand your requirement, you want to submit multiple rows of repeating table to SharePoint List, then you can view the data through the list.

    Here is an article about how to submit data to SharePoint list:

    http://blogs.msdn.com/b/infopath/archive/2007/03/26/submitting-to-a-sharepoint-list.aspx

    Above this article, you can submit only one row at one time. If you want to submit multiple rows, you can add more method(you should only change the ID) tags to the CAML xml file.

    More information:

    http://msdn.microsoft.com/en-us/library/cc162745%28v=office.12%29.aspx

    http://www.bizsupportonline.net/infopath2007/how-to-submit-items-rows-repeating-table-infopath-sharepoint-list.htm

    Best Regards,

    Qiao Wei

    TechNet Community Support

     
  • Monday, June 11, 2012 9:33 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    This is possible to show the data of a repating table in a list by publishing the value as metadata.

    So, when you publish the form, don't forget to select to publish column in metadate selection, and select "merge".

    This will concat all the values that are in the repeating table.

    Visit my blog : http://rmatayron.blogspot.com/

     
  • Sunday, May 05, 2013 1:21 AM
     
     
    Sign In to Vote
    0

    I am trying the same thing. I added check boxes to repeating tables, the data structure being:

    Group1

         -Repeatingtablegroup

              -field1(checkbox)

              -field2(checkbox)

    When I click on Property promotion -->Repeatingtablegroup, it shows only "count". Hence SharePoint shows the column name as "Repeatingtablegroupt" and under that "1". Any idea why this could happen?

     
  • Monday, May 06, 2013 2:57 PM
     
     
    Sign In to Vote
    0

    Hi,

    Ok I understand what you try to do: You try to publish field 1 and field 2 on the same time but this is not possible.

    You have to select directly "field1" and selecting "merge" and do the same thing on field 2 on another property.

    Maybe can you try to add a third field in the repeating table that contactenate the 2 previous field et then promote this new field with merge option...

    Hope this helps.

    Visit my blog : http://rmatayron.blogspot.com/

     
  • Tuesday, May 07, 2013 1:23 AM
     
     
    Sign In to Vote
    0

    Ok...I am a little confused...here is an image of what I have:

    Chkbox1: FieldName="Chkbox1", Datatype="text/string", Default state: Cleared, Value when checked:yes

    Chkbox2: FieldName="Chkbox2", Datatype="text/string", Default state: Cleared, Value when checked:yes 

    3rd column: FieldName="Total", Datatype="text/string"

    I am not sure if I have set it up right, but in Property Promotion it shows like this:

    I want to somehow promote Group13 (a repeating table) so that it will show me the values "Chkbox1,Chkbox2" in the SharePoint list column.


    • Edited by mikello Tuesday, May 07, 2013 1:26 AM
    •