Eval Function between SharePoint List and InfoPath Form

mwcoplin — Tue, 03 May 2011 20:16:48 GMT

I have read all of the posts concerning the double-eval and how it works well with a repeating table that exists in an InfoPath form, but I am hoping to be able to use this function to display multiple rows of data from a SharePoint list in a single field of an InfoPath form. This is basically what I have and what I'm trying to do:

1) SharePoint list with individual rows (column 1 has Group Name, column 2 has the Blg-Floor) for each floor a conference group is assigned to for their stay (ie, Football Blg A - Floor1, Football Blg A - Floor2)

2) InfoPath form that contains specific data about the conference group (ie, when they are arriving, group leader, etc)

What I am hoping to do is use the double eval to put all of the Blg-Floor information for a specific group into one field in the InfoPath form for quick reference, but I have not been able to get it to work yet (I have a dropdown in the InfoPath form to select the specific group and have my eval rule on this field). I am getting results, and the number of results is correct, but instead of showing Blg A - Floor1; Blg A - Floor2, it's showing Blg A - Floor 1; Blg A - Floor1.

This is my formula as it is right now:

eval(eval(@ows_LinkTitle[. = Group], 'concat(xdXDocument:GetDOM("Locations - Attendees")/xml/rs:data/z:row/@ows_Floors, ";")'), "..")

Thanks for your time!

SharePoint Integration

Eval Function between SharePoint List and InfoPath Form