https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/122429.aspxThu, 13 Feb 2020 19:30:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122429Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122429.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122429You 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]https://www.infopathdev.com:443/forums/thread/122428.aspxThu, 13 Feb 2020 19:21:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122428Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122428.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122428so 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 jaci.tomkinson@company.com Loc = XYZ Hidden Field = Email assoc with Loc XYZ When you fill out form and press submit, Email for XYZ is sent.https://www.infopathdev.com:443/forums/thread/122426.aspxThu, 13 Feb 2020 18:39:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122426Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122426.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122426thanks for investigating...it proves i'm always overlooking something...:-)https://www.infopathdev.com:443/forums/thread/122425.aspxThu, 13 Feb 2020 18:34:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122425Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122425.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122425Yup, that's what you'll have to do.https://www.infopathdev.com:443/forums/thread/122423.aspxThu, 13 Feb 2020 18:15:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122423Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122423.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122423Well 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??https://www.infopathdev.com:443/forums/thread/122422.aspxThu, 13 Feb 2020 18:10:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122422Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122422.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122422Oh, 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.https://www.infopathdev.com:443/forums/thread/122421.aspxThu, 13 Feb 2020 18:08:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122421Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122421.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122421I see no "Rec" or "Ship Loc" columns. Here are the columns I see in the form you attached.https://www.infopathdev.com:443/forums/thread/122420.aspxThu, 13 Feb 2020 18:07:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122420Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122420.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122420i tried to attach an excel file with the SP table list items, but keep getting an error messagehttps://www.infopathdev.com:443/forums/thread/122419.aspxThu, 13 Feb 2020 18:04:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122419Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122419.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122419In 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.https://www.infopathdev.com:443/forums/thread/122418.aspxThu, 13 Feb 2020 17:57:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122418Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122418.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122418Sorry - 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. :)https://www.infopathdev.com:443/forums/thread/122416.aspxThu, 13 Feb 2020 17:54:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122416Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122416.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122416external item pickerhttps://www.infopathdev.com:443/forums/thread/122415.aspxThu, 13 Feb 2020 17:52:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122415Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122415.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122415Any 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?https://www.infopathdev.com:443/forums/thread/122413.aspxThu, 13 Feb 2020 17:49:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122413Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122413.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122413I 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: jaci.tomkinson@company.com Loc ABC - email: jaci.tomkinson@company.com 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.