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/122237.aspxThu, 09 Jan 2020 22:06:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122237Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122237.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122237Glad you have it working & thanks for the compliments - have a great day!https://www.infopathdev.com:443/forums/thread/122236.aspxThu, 09 Jan 2020 22:03:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122236Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122236.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122236The InfoPath Whisperer...you never cease to amaze me. Your solution has my form working like a charm. Is there a survey I can fill out to let your employer know how amazing you are and how well you know your stuff? Thanks so very much! 10 Star Service...https://www.infopathdev.com:443/forums/thread/122235.aspxThu, 09 Jan 2020 00:08:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122235Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122235.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122235I didn't realize the field in question was in your repeating table - your hidden field also needs to be in the repeating group, because if there are 15 rows, you might have 15 different values for the SHIP Plant, right? I've attached an updated file here - save it locally, right click and select Design to open in InfoPath Designer. The formula, once your field is inside your repeating data source, would be: xdXDocument:GetDOM("MDList2")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Plant[../d:Email = current()/../my:Ship]https://www.infopathdev.com:443/forums/thread/122234.aspxWed, 08 Jan 2020 22:30:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122234Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122234.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122234oh, and sorry, here's the latest xsn file...i played with another rule for the hidden fieldhttps://www.infopathdev.com:443/forums/thread/122233.aspxWed, 08 Jan 2020 21:58:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122233Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122233.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122233The hidden field...tried various formulas but none are getting me the result...https://www.infopathdev.com:443/forums/thread/122232.aspxWed, 08 Jan 2020 21:56:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122232Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122232.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122232Yes Hilary, I already had the SP list and had the Ship field set with a data connection and email as Value and Plant # as Display.https://www.infopathdev.com:443/forums/thread/122231.aspxWed, 08 Jan 2020 20:38:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122231Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122231.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122231This gets a little tricky with a hardcoded dropdown. If we put this data in a secondary data source instead, it gets a lot easier. I'd suggest you create a SharePoint List for this data - it would have two columns - one for email, one for name. Then you can add a data connection to that list, and use it for your dropdown, with the email for the value, and the name for the display. Finally, you can add another field to your form (doesn't have to display on the form) that you use a default value for - basically, the default would be the display name for the selected email - and you'd promote THAT field. It sounds more complicated than it is -- if you create the list and add a data connection to it, and re-attach your template, I can help you with the new field and the default value. :-)https://www.infopathdev.com:443/forums/thread/122230.aspxWed, 08 Jan 2020 20:34:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122230Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122230.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122230Attaching your screenshot to this post, and closing the other thread - you can always just add a reply to your thread with each additional file.https://www.infopathdev.com:443/forums/thread/122228.aspxWed, 08 Jan 2020 19:29:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122228Jaci Tomkinson0https://www.infopathdev.com:443/forums/thread/122228.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122228Hello, I have a dropdown list in my InfoPath that has site locations. It is also tied to email for each location so they receive a notification. For example, the datasource that populates the Ship Plant field is in SharePoint and looks like this: ID Plant LocType Email 301 000-Test Test Location jaci.tomkinson@xxx.com My form is attached. In the form, I have the Plant set to Display, but the Value is equal to the Email address. When I promote the field to SharePoint, it displays the Email and not the Plant # I don't see an option in the promote section to select what to display. Help?