I have been banging my head for a week and need help...
I have a simple list populating information into SharePoint 2010 using Infopath 2010 called Notifications. The list contains the following:
Name (which is the file name also), Email_Select, Email_Address, General, Email, Internet
There is more data but this will be sufficient if I can get this to work.
What I am attempting to do is have Infopath on another form (Call this Send Notifications) retrieve the information from this list and then use it to send an email to those that selected Email_Select and one of the applications, General, Email, Internet, etc...(Double Filter)
This is what I've got so far and am stuck:
On the Send Notifications form I have created a standard text box field to concat the email addresses(I may need to use another field type due to length constraints, or this could be one of the issues) Called Email_Concat
I have created a data connection to the first list called Notifications and selected all fields.
I put a button on the Send Notifications form to populate a field Email_Concat with this formula:
eval(eval(SharePointListItem_RW, 'concat(xdXDocument:GetDOM("Notifications")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Email_x0020_Address, ";")'), "..")
What I get back is the email address of the first row concatenated with the first row again the correct number of times. It appears the loop is not going to the next row of the table. When I look at the form data, it appears to be correct, and I can insert a filter at eval(SharePointListItem_RW[Filter} and this will populate a row I selected by filtering, but it then concatenates the same row.
Can anyone help me with what I'm doing wrong?
Barry