InfoPath Dev

Hi, 

I am new to using SharePoint Lists as a source of data in an InfoPath form and need a little help. I created two SharePoint lists (Primary Assignment) and (Secondary Assignment).  Both lists contain two columns: one column for the user name (Title) and the other column for their corresponding email (Email).

In my data connections, I created two connections to retrieve the data from SharePoint: ID, Title and Email.

In my InfoPath form, I have two drop down lists configured to pull the Titles from each SharePoint list. 

I also have two text fields [Email1], [Email2] which I have set up on an email data connection.  

The end result I am trying to accomplish is that when a selection is made in the primary dropdown, that the email for that person is set to the [Email1] field and similarly, when a selection is made in the secondary dropdown that the email for that person is set to the [Email2] field. 

I tried creating a rule but it keeps pulling back the very first email on the SharePoint list and not the email for the person selected.  I am just not getting how to do this.  Any guidance you can provide is much appreciated.  Thanks in advance!

 

You are most of the way there! You need to add a filter when you create the rule, so that you get the "right" row from your Emails. Samples are easier to understand, so I've attached one. Mine uses a secondary data source from an XML file so you can preview it and see how it works. If you have an questions, just let me know. :)

 Hilary!!!!  You just blew my mind with combining both SharePoint lists.  That is so much more efficient!  Thank you for the sample, I was able to get what I needed to finish this form and yes, I combined the SharePoint lists.  Many thanks for the quick, thorough, helpful response - from your #1 fan! 

I knew you'd figure it out. Samples make it a little easier - it would have taken a ton of text to describe. Have a great day!