none
InfoPath- Consolidate information from Repeating Table into a textbox

    Question

  • Hi, In InfoPath, Is there a way to get the repeating table(SampleRepeatingTable) fields consolidated into a text box(ConsolidatedInfo)

    Such that the ConsolidatedInfo text box will have values such as:

    Field 1* (Peoplepicker Display Name) - Field2** (SubjectMatterExpertComments textbox)

    Field 1* (Peoplepicker Display Name) - Field2** (SubjectMatterExpertComments textbox)

    ....

    ....

    where

    *Field 1= /my:myFields/my:SMEComments/my:SampleRepeatingTable/my:SubjectMatterExpert/pc:Person/pc:DisplayName

    **Field 2= /my:myFields/my:SMEComments/my:SampleRepeatingTable/my:SubjectMatterExpertComments

    Any help is appreciated, thanks in advance.

    Saturday, July 20, 2013 6:44 AM

Answers

  • Hi,

    I understand that you want to get the value inside a repeating table to a text box. You can use the formula as the default value for the text box column:

    concat('Field1-',substring-after(xdMath:Eval(xdMath:Eval(../my:group1/my:group2/my:field1, 'concat(., ";")'), ".."), ";"), 'Field2-',substring-after(xdMath:Eval(xdMath:Eval(../my:group1/my:group2/my:field2, 'concat(., ";")'), ".."), ";"))

    Change the xpath for field1 and field2 to you Field1 and Field2's XPath.

    Thanks,
    Entan Ming

    Entan Ming
    TechNet Community Support

    Sunday, July 21, 2013 4:28 AM
    Moderator