CJ

The circle of life – ** .Net – Training – MOSS **

  • Past Post

  • Vistor Locations

Retrieving data from InfoPath repeating tables

Posted by Clayton James on November 3, 2009

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.

Advertisements

25 Responses to “Retrieving data from InfoPath repeating tables”

  1. Nichelle said

    Hi CJ,

    Thanks for this solution but I am still having some problems.

    I have 2 fields in a repeating table – TL_Description and TL_Platform.
    I was able to build half of the formula – concat(TL_Description, ” – “, TL_Platform). And it is working.

    But I don’t understand how to build the formula to capture all the data in the repeating table.

    Please advise.

    Thanks,
    Nichelle

  2. Thank you. A problem solved!

  3. I have 2 fields in a repeating table – TL_Description and TL_Platform.I was able to build half of the formula – concat(TL_Description, ” – “, TL_Platform). And it is working.
    +1

  4. Azam said

    Thanks for the information. I have tried this but I do not see any of the repeating fields in the publish wizard. I also tried the second approach which seems to just repeat the information it finds in the first record, e.g. if the values I expect back are 1;2;3;4 all I get is 1;1;1;1

    Any advice would be appreciated.

    Thanks

  5. Maria F said

    Hopefully you are still monitoring this post.

    I am working with a repeating section, not a repeating table. I have about 5 fields within this section that I want to merge into SharePoint columns. I am having a little trouble understanding how I can set up this formula and what it will look like.

    With your solution would my 5 columns be merged together with a semicolon delimitor at the end?

    Example: column1 – column2 – column3 – column4 – column5;

    Do they have to be merged together? Can I have one merged column displayed at a time?

    Example: column1;

  6. electric snow blower…

    […]Retrieving data from InfoPath repeating tables « CJ[…]…

  7. free website audit report, seo audit document, google seo audit, free seo audit tool, seo technical audit, seo audit service, search engine optimzation audit, free seo site audit…

    […]Retrieving data from InfoPath repeating tables « CJ[…]…

  8. Seo (seo ) may be the traditionally used term in the field of “internet promotion.” i’m able to definitely point out “search engine optimization is the anchor associated with internet marketing.” i want to …skyscraper seo

  9. IM said

    IM…

    […]Retrieving data from InfoPath repeating tables « CJ[…]…

  10. wei cheng said

    how about situation like this one? any suggestion? thanks!

    http://www.infopathdev.com/forums/p/22267/77072.aspx#77072

  11. Have you ever thought about writing an ebook or guest authoring
    on other blogs? I have a blog based on the same information you
    discuss and would love to have you share some stories/information.
    I know my visitors would enjoy your work. If you’re even remotely interested, feel free to shoot me an e-mail.

  12. Hi, just wanted to say, I liked this article. It was helpful.
    Keep on posting!

  13. Having read this I believed it was really enlightening.
    I appreciate you taking the time and effort to put this information together.
    I once again find myself personally spending a lot of
    time both reading and leaving comments. But so what, it
    was still worth it!

    • Pierrecili said

      Тяжело обожать тех, кого мы совершенно не уважаем, но еще сложнее обожать тех, кого уважаем больше, чем самих себя.

    • Сижу, психую, что инет виснет, на компьютер ору, папа гласит : “Молоток принести?” Блин, капец.

    • Georgeopa said

      Пошутили друг над другом вконтакте!.. И эта шуточка обернулась большой любовью! )

  14. Great post. I was checking constantly this blog and I’m impressed! Very useful info specifically the last part 🙂 I care for such information a lot. I was seeking this certain information for a long time. Thank you and good luck.

  15. I am really pleased to read this website posts which carries lots of
    useful data, thanks for providing such information.

  16. Christi said

    I read this piece of writing completely on the topic of the difference of most up-to-date and earlier technologies,
    it’s amazing article.

  17. Mavis said

    What’s up, the whole thing is going sound here and ofcourse every one is sharing data, that’s really good,
    keep up writing.

  18. Sb bomber said

    I’m truly enjoying the design and layout of your site. It’s a
    very easy on the eyes which makes it much more enjoyable for me to come here and visit more often.
    Did you hire out a designer to create your theme?
    Fantastic work!

  19. Hello, i think that i saw you visited my website so i came to “return
    the favor”.I’m attempting to find things to enhance my web site!I suppose its ok to use some of your ideas!!

  20. Good day! I simply wish to offer you a big thumbs up for the excellent info you’ve got right here on this post.
    I’ll be returning to your site for more soon.

  21. If you want to query repeating table data with Microsoft SQL Report Builder 3.0, SSRS, SSIS, Excel, Access, or Performance Point be sure to check out

    http://infopathdb.codeplex.com

    Over the years I’ve tried many InfoPath reporting options with PowerShell scripts, Scheduled Tasks, code behind, and multiple submit data connections. Having a real-time web service to merge XML data for easy query works well and I published that in case it can help others too.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: