My lookup columns that have been working stopped working.

Question

I have been using my Sharepoint list for almost 3 years without issue. On this list I have two lookup columns that pull information from the same source/parent list. The columns are Primary and Secondary, the Secondary column does not work, but the Primary column does. Both Primary and Secondary are set up exactly the same pulling from the same parent list. Why has it stopped populating information in the second lookup? How can I fix this? I do not have powershell, my department restricts use of this.

Answer 1

I have created a new lookup column and I could not reproduce the issue. This may be an occasional issue.

Please try to create a new lookup column in a new list to check whether the issue persists.

If the issue persists, you could go to Microsoft 365 admin center -> Health -> Service health -> Report the issue.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.