InfoPath Dev

Perfect, glad they were able to help. Another option sometimes instead of modifying the SQL connection is to use a SQL view that has the data combined. And in case future thread readers want to do this in the source files: https://www.infopathdev.com/blogs/greg/archive/2004/07/08/Display-Multiple-Fields-in-a-Drop_2D00_Down-List-Box.aspx

Hi - what is your data source for your dropdown? Is it SQL or SharePoint? The approach mentioned here involves modifying the form's source files for populating the dropdown with a concatenated value which I really don't recommend if there are other alternatives. If your data source is a SharePoint list - the easiest thing to do would be to ...

I'd suggest something like this article to begin with: https://support.office.com/en-us/article/send-e-mail-in-a-workflow-11d5f9dd-955f-412c-b70f-cde4214204f4 - but perhaps that is the one you are already looking at?

Do you mind attaching your form under the options tab in a reply? Or a simple sample that outlines the issue? Basically, rules fire when a field changes - so if the value being set is the same as the prior value, your rule won't fire again - but it sounds like you have placed rules on all fields involved, which is what I'd expect to work ...

I replied to your other post as well - basically, if you want to send email using a data connection in the form, it is another type of submit connection. You can then use submit rules to submit to email followed by your submit to your main data connection. But we can continue this conversation in your other post - I think that if it's a ...

Since this is a list form, and you just want a notification sent, I would suggest using SharePoint Workflow for this, if that's an option? Or MS Flow - are you using SharePoint Online, or is this an On-Prem SharePoint server? Do you have access to SharePoint Designer so you can create a workflow for the list?

Is this a browser or a filler form? If this is in the browser, you might try adjusting the postback settings on the button. Right click it in the designer, and under properties, find the browser tab. Then set postback to always, republish and see what happens.... If that doesn't do it, double check your rules are doing what you think they are ...

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!

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

So - does this form work the way you intend in general? I'm concerned about all the repeating sections - I'm assuming when you add a repeating section at the top, all the others would then have a second instance as well. It seems like that might be confusing for the user - I'd be more likely to use a single repeating section with the ...