Getting list item id from another list with excel value for import

Copper Contributor

Hi everyone,


today, I've got a rather hard task on my doorstep:


I have two lists, which are connected via one lookup field.

Now, I need to import values from an excel list into the first list with the lookup field.

At this moment, an Id of the lookup value is needed, which I can't provide, because I only have the text value. The text values are already within the second list.


My problem is, that I cannot import value 2 into list 1, because I'm missing the Id of the value.


Is there any chance to make this import work?




0 Replies