InfoPath Dev

I'm fairly new to InfoPath and have run into a problem on a form I'm trying to build.  The form is hosted on SharePoint and will be used by employees to submit a request for a new team site to be created.  Within the form there are repeating tables with drop downs to select employees to be designated as site owners, site contributors and site visitors.  I've got the drop downs in the repeating tables merging into a column on the form library so that I can create the site and grant the appropriate permissions, however I would like to build a workflow that would send an email to all the employees in the team when the site has been created. 

 The drop downs are populated by a secondary data source on SharePoint which is our Master Employee List.  The drop downs use the Full Name column.  Also in the list is an email address column.  What I would like to do is create a setup that when an employee is selected in one of the repeating tables, their email address from the Master Employee List is added to a list of recipients that would then later receive an email when the site has been created.

I've been playing with the master/detail control for a bit thinking it is what I need, but so far I'm not getting it to work how I want to.  If any of you have an idea for me I'd be very thankful as this is bugging me to no end.

Thanks,
Josh

I would create a text field for saving the recipients in that you can use with your email submit.

I would then put a rule on the drop downs which set a fields value.  Set the value of your new recipients field with concat(recipients, email[fullname=dropdown], "; ")  When you select the email field from your data connection, use the filter button in the lower left to setup a filter where the fullname is equal to the field value in the drop down the user just selected.  The concatenation will build your list of email recipients in the proper format email1; email2; etc.

Thanks for your reply.  Just to make sure I'm understanding what you were suggesting...here's what I tried. 

I created a new field and then created a rule on dropdown1 that says to set the new field's value to the email address from the data connection when fullname=dropdown1. Then I created another field that is supposed to concatenate those values with the semicolon between them that will provide a nice list of emails for use in the workflow.  Unfortunately, when I was testing this, the field that was set by the dropdown doesn't change when a new row is inserted.  It remains the email address of the employee whose name was selected in the first row of the repeating table. 

 Is there a way to get the value to change with each row of the repeating table?  I will say it's highly probable that I misunderstood what you were suggesting, if that's the case just let me know.  I'm eager to learn here, InfoPath has been a lot of frustrating fun so far!

Thanks for you help!
Josh

You need to look at the current() function if you are using a repeating group.