cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Replacing Text Field With List Lookup

Hi,

I am being asked to replace a text field column ("Category") with a dropdown field that gets its values from another list. I was thinking of using a List Lookup field to do this.

Newly created records (e.g. list items created after the change) have no issue. However, if I attempt to view older records, I encounter an issue: the data stored in the "Category" column does not load correctly in the List Lookup dropdown. The value (ex. "Emergency") exists in the list being referenced by the List Lookup field, but it does not appear.

Is there something I can do to force the List Lookup field to display the value of its "Text Connected to" column?

Labels: (2)
0 Kudos
Reply
2 Replies
achilles_aditya
Nintex Newbie

Re: Replacing Text Field With List Lookup

You have connected a dropdown to a column instead of text hence it will work for the future values. But since the text of the existing values don't match with the values in the dropdown you are facing the issue. Check it by putting the values of already existing text as dropdown values. I guess you will need to delete already existing records

0 Kudos
Reply
Automation Master
Automation Master

Re: Replacing Text Field With List Lookup

how have you set it up in list?

I would expect lookup being a new column ...

0 Kudos
Reply