InfoPath Dev

I have a form (see attached). When the person selects location, if the different locations have the same email contact, it makes all locations point to one place. Each location is unique. For example: Loc XYZ - email: [email protected] Loc ABC - email: [email protected] When the user clicks XYZ, then it reverts to ABC How do I fix this? It seems like the problem only occurs if the locations share the same email associated.

Any chance I can see a copy of the form? Is the locations field using a dropdown or an external item picker or some other type of control?

external item picker

Sorry - I'm not finding it on this template - where can I find it? Is it in the repeating table? If you can tell me where to look, I'd be happy to try to help. :)

In the attached InfoPath form, the drop down list are in the Rec and Ship Loc columns. When you click on preview, if you select 154, 164, 165, 208, 209, 211, 213, 216, 217, 218, or 233 they revert to 234 location. The external source is in SharePoint inside the companies firewall, so not sure how I give you access to it.

i tried to attach an excel file with the SP table list items, but keep getting an error message

I see no "Rec" or "Ship Loc" columns. Here are the columns I see in the form you attached.

Oh, perhaps you mean the list box on Ship Plant? Your value is set to email, and since email is not unique, you'll have the result you describe. You'll want to change that value to something unique, then you can get the email with an XPath filter if needed.

Well darn, I have it set as email because when the user clicks submit it sends notification to the contact tied to that plant. Do I need to create a hidden field that puts the email in it and then use that field to send the notification too??

Yup, that's what you'll have to do.

thanks for investigating...it proves i'm always overlooking something...:-)

so would my hidden files value be something like this: xdXDocument:GetDOM("MDList")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Email[. = current()/../my:Ship] As that's what I put but no value is returning. Help? What I want to happen is when a person selects a location, the workflow would email the contact affiliated with the plant selected. For example: Loc XYZ email [email protected] Loc = XYZ Hidden Field = Email assoc with Loc XYZ When you fill out form and press submit, Email for XYZ is sent.

You were super close - just missing the "Plant" from the MDList in your XPath filter. Try this: xdXDocument:GetDOM("MDList")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Email[../d:Plant = current()/../my:Ship]