InfoPath 2010

Re: Populate a text field using a multi-value lookup column in "ID;#Title" format

BryanJones — Thu, 10 May 2012 17:47:17 GMT

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 out in sharepoint. If 1 item is selected, I get something like "alue1;1;#Value;" If more are selected, it seems to set all the values to the last one selected along with doubling the title somehow. Anyone have any ideas?

Populate a text field using a multi-value lookup column in "ID;#Title" format

BryanJones — Wed, 09 May 2012 18:43:13 GMT

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 passes (with Value set to ID).

I tired using translate() to replace "title" with a filtered version of the same data source, but that doesnt work either, just populates it with the first letter of the last one I selected.

Any help would be appreciated!