Forum Discussion
mohitosh12
Mar 25, 2023Copper Contributor
SharePoint List Lookup column new Item not visible on the drop-down menu
I am using SharePoint in Microsoft 365 where several Lists are connected together to form a master list for team requests tracker. One of the SP lists contain a list of Resource Names which is conne...
RobElliott
Mar 25, 2023Silver Contributor
The odd number will clear after a short while or a few refreshes and be replaced by the actual ID.
mohitosh12
Mar 25, 2023Copper Contributor
I agree with you, but I waited for around 4-5 hrs. to see the change, but it doesn't change, and the scenario is different for other list or if I create a new list same data from this above list then it works fine and immediately, I notice a new incremental ID without such odd prefix.
Bigger concern is that the new Item is not visible in the corresponding lookup column in the connected list.
I can get around with this if I create a new list from the above data and add the new item which shows up into the lookup column if I connect it to the new list, but I will lose the saved content from the old lookup column (which connects to the old list) on the master list.