I have two list:
- Item List: contains beside the item name a column "item short" with a shortened string as our internal item registration text.
- Main list: used like an inventory list. The item list is linked as a lookup column with multiple value input. The linked column is our "item short" text, an additional column shows the title column of the item list.
Now I want to populate the inventory from an Excel file. Besides other infos it contains a column with multiple item short names.
I found this article but it is for the lookup column ID only and doesn't work with my item short.
Is there any solution for this?