Retrieving data from InfoPath repeating tables

When trying to retreive and view data from InfoPath repeating tables using a no code solution you have a couple of options.

1.
When publising your form you can select the column in the repeating table and modify the column function from (first) to (merge). This merges all the repeating values into one column so you can see all the values in your SharePoint View. One problem with this approach
is that the output doesn’t contain a delimiter for each column value so this makes it difficult for reporting

2.
Another option is to add a textbox to the form which will concatinate the values and seperate them via a deliminator (in this case a semi-              colon ‘;’).

In the value area of the textbox add the following formula.
xdMath:Eval(xdMath:Eval(/my:travelRequest/my:trips/my:trip, ‘concat(concat(concat(my:Airline_Name, concat(” – “, my:Flight_Identifier)), concat(” – “, my:Destination_EndDate)), “;”)’), “..”)

This outputs “Air France – GL3444 – 2009-11-05;Qantas – DJ3456 – 2009-11-27;”

To display this information in a SharePoint view you need to create a column in the Form Library for example FlightDetails and when you publish the form add a column mapping that maps FlightDetails to your textbox identifier.

Fill out a form and view the Flight information in a SharePoint view concatenated via a semi-colon. Now we have a ‘;’ deliminator we can easily extract/filter data when exported to an excel spreadsheet.

If you want to you can hide the textbox so users don’t see the value when filling out the form.