InfoPath Dev

I'm using InfoPath 2007 and connecting to SharePoint 2010.  I have created a secondary data source by pulling in the XML of the SharePoint list.

I'm trying to concatenate all email addresses from the list into one field.  I'm using the following xpath:

eval(eval(row, 'concat(xdXDocument:GetDOM("Group1")/xml/rs:data/z:row/@ows_Email, "; ")'), "..")

It's moving through the entire list (which is 6 items), but it keeps repeating the email from the first entry on the list.  What am I doing wrong?

Thanks for any help!

Try:  eval(eval(row, 'concat(@ows_Email, "; ")'), "..")

With row selected via the field picker.

I did select row with the field picker.  After using the field picker, it changes it to what I had above.

Below is a screen shot after I select everything with the field picker.

 Do not select ows_Email with the field picker. Use the text for that as per my previous post - the relative path to ows_Email from row.

Wow, that did it!  Thank you so much!

 Now that you have it working, take a read through this blog:

http://blogs.msdn.com/b/infopath/archive/2006/04/05/569338.aspx

There's a "here's how it's done" section that will help you understand how the formula works. :)

This is the article I've been referencing... I just missed that tiny note in there that mentioned the part that had to be typed!  :)