Controls

Re: Concatenate repeating fields from a secondary source

clawrence — Thu, 05 Dec 2013 16:39:21 GMT

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! :)

Hilary Stoupa — Thu, 05 Dec 2013 16:23:54 GMT

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

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

clawrence — Thu, 05 Dec 2013 16:17:30 GMT

Wow, that did it! Thank you so much!

Hilary Stoupa — Thu, 05 Dec 2013 16:06:03 GMT

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.

clawrence — Thu, 05 Dec 2013 15:58:51 GMT

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.

Hilary Stoupa — Thu, 05 Dec 2013 15:47:52 GMT

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

With row selected via the field picker.

clawrence — Thu, 05 Dec 2013 15:46:22 GMT

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!