Newbie Questions

Re: Using sharepoint list to determine email recipient on infopath form

Hilary Stoupa — Thu, 16 May 2019 17:32:43 GMT

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!

Re: Using sharepoint list to determine email recipient on infopath form

jvazquez — Thu, 16 May 2019 17:24:55 GMT

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!

Re: Using sharepoint list to determine email recipient on infopath form

Hilary Stoupa — Thu, 16 May 2019 16:16:11 GMT

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

Using sharepoint list to determine email recipient on infopath form

jvazquez — Thu, 16 May 2019 15:55:35 GMT

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!