i have come across a scenario where i should update lookup field value from single line text field in the same list (lookup field used for splitting text/string).

Is this possible to update the lookup field using workflow in the same list..

i have tried using spd 2010 workflow,

ListA has 2 fields, Destinations (Single line text) and Destinations1 (lookup field mapped to ID of same list),

Here i need to update Destinations1 with user input values from Destinations using workflow.

enter image description here

1 Answer 1


We are not able to use workflow to update the Lookup type of column value with the text column value.


Since the value of Lookup column formats as ID + ;# + lookup text value, if we don't change the type of lookup, we cannot change the value based on a text column.

Besides, since the lookup column get information from another column, if the text value is not including in this column, it will not get the information.

The workaround I can give is change the lookup column type.


We can create a workflow as below to update lookup column based on a text column:

enter image description here

My List1 is the list which lookup column get information from, Title is the column which lookup column get information from, field2 is the Single line text column.

  • if not, can i have alternative solution. Maybe using 2 lists
    – Sudhir
    Dec 2, 2019 at 8:36
  • Hi Sudhir, I update my reply, check it. Dec 2, 2019 at 9:18
  • Hi Hellofiona, Can i use two lists A and B and update lookup field (since i need this for splitting the text ;Delimited Text).
    – Sudhir
    Dec 2, 2019 at 9:27
  • sharepoint.stackexchange.com/questions/165456/… please check this link, there are similar queries and have been solved but are not clear. Can you help to solve
    – Sudhir
    Dec 17, 2019 at 5:33
  • Hi Sudhir, based on the link you provide, I update my reply, check if it helps. Dec 17, 2019 at 6:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.