Lookup Field with Picker

Aug 11, 2009 at 9:58 AM

Hi There,

I need to create a tree list rather then a flat list and am using the lookup field with picker to store my parent value in.

In datasheet mode I can see the value as [ID];#[Mapped Field] (3;#Sample Title)

Is there anyway I can access the ID using XLS for example substring-before(@LookupFieldWithPicker,';#'). The only way I am able to do this at the moment is to use another column and have a workflow copy the lookup field value to this column. This enables me to access tha ID but if the parent is changed will not reflect this change.

Thanks,

James Callaghan

Coordinator
Aug 11, 2009 at 4:58 PM

Hi James,

dont't know. Yozu could try a an expression in a calculated column. 

Bye,

Christian