locked
SPD Workflow Lookup field Value RRS feed

  • Question

  • Hi All,

    Can we retreive just the value from a lookup field throug a sharepoint designer workflow?

    As in only the value of the lookup field is supposed to be stored in another list.

    Normally, if we try to retreive the data from a lookup field it will get the data in the following format:
    ID;#Value.
    I require just the value

    Help is appreciated

    Regards,

    Huzefa Mala.

    Wednesday, April 21, 2010 10:34 AM

Answers

  • Hi,

    Select the option for "Return field as" to "Lookup Value (as Text)". Hope this fixes your issue.

    Regards,

    Deepak

    • Proposed as answer by kurtvd Wednesday, May 4, 2011 8:58 AM
    • Marked as answer by Mike Walsh FIN Wednesday, September 14, 2011 10:04 AM
    Thursday, March 17, 2011 11:24 AM

All replies

  • Hi Mala,

    can you explain little bit more because i tested your requirement and i found its value.

    -Hardesh

    Wednesday, April 21, 2010 10:57 AM
  • Hi,

    I meant that if you transfer the value of a lookup field to a single line of text field through sharepoint designer then the entry that will be made in the single line text field is in this format:
    [ID of the Lookup Item];#[Display text of the Lookup Item].

    I wanted inly "Display text of the Lookup Item"

    Hope its clear now.

    Regards,

    Huzefa Mala.

    Wednesday, April 21, 2010 12:09 PM
  • Hi Mala,

    Ya it's clear now and i did same thing.

    i created a look up field in a list and also create a column field (Text Type).

    and then i set Text field value as look up field value by using SPD workflow.

    then it give me value not as you mentioned.

    can you tell me about your primary list column type(source for look up field)?

    -Hardesh

    • Marked as answer by Stanfford Liu Friday, April 30, 2010 8:19 AM
    • Unmarked as answer by Mike Walsh FIN Sunday, January 2, 2011 10:17 AM
    Thursday, April 22, 2010 5:04 AM
  • HI Husefa,

    Have you resolved this matter? I am in the same case.

    Giuseppe


    Giuseppe Porcelli
    Sunday, January 2, 2011 7:48 AM
  • Hi,

    Select the option for "Return field as" to "Lookup Value (as Text)". Hope this fixes your issue.

    Regards,

    Deepak

    • Proposed as answer by kurtvd Wednesday, May 4, 2011 8:58 AM
    • Marked as answer by Mike Walsh FIN Wednesday, September 14, 2011 10:04 AM
    Thursday, March 17, 2011 11:24 AM
  • Thanks Deepak!

    I had the same problem.
    By setting the lookup in the SharePoint designer workflow to return as "lookup value (as text)" it gives me just the lookup text value, not the complete string with the id etc.

    Wednesday, May 4, 2011 8:58 AM
  • I had the same problem, except I was retrieving the value from Current Item in a Condition and it wouldn't let me choose lookup value as text, the field was disabled.

    What I did was comparing the value to [%LIST:CLIENT ID%][%LIST:TITLE%]


    Probably not the best way to do it but it works IF you are trying to compare the value and not display it.


    Wednesday, September 14, 2011 8:55 AM