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?
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