Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (3 items) Re: Populate a text field using a multi-value lookup column in "ID;#Title" format I got this to work in preview-mode with this: substring(xdMath:Eval(xdMath:Eval(../my:ChgNtcSvcsAffected, 'concat(., ";#", string(xdXDocument:GetDOM("IT Services")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Title[current() = ../d:ID]), ";")'), ".."), 4) but it doesnt work when publshed ... Posted to InfoPath 2010 (Forum) by BryanJones on 05-10-2012 Re: filtered dropdown returning ShP id I realize this was a while ago, but can you tell me how you were able to get the ID#Value; format out of the lookup column? This is exactly what Im trying to do but i cant select both (ID and Title), it will ony let me choose whatever the value is for the lookup. Posted to General (Forum) by BryanJones on 05-10-2012 Populate a text field using a multi-value lookup column in "ID;#Title" format I already (with help from folks here) am able to get this: 1;#title;2;#title;3;#title; using this: substring(xdMath:Eval(xdMath:Eval(../my:MyLookup, 'concat(., ";#", "title", ";")'), ".."), 9) but I need to replace "title" with the actual Title associated with the ID that the lookup ... Posted to InfoPath 2010 (Forum) by BryanJones on 05-09-2012 Page 1 of 1 (3 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.