Forum Discussion
MS List suddenly not displaying (or saving) multiple selections from column
It’s quite an interesting issue. I’ve never experienced this behavior myself. But here are a few troubleshooting steps you can try, in case you haven’t already explored them:
1. Confirm whether the data is actually being saved
Open the item in Edit mode (click on Edit all) and check the lookup field.
- If only one value appears: the issue is with saving
- If all values appear: the issue is with display/rendering
This helps narrow down the root cause.
2. Check if the source list has unique permissions
If the lookup source list or individual items have restricted permissions, SharePoint can sometimes fail to save multiple lookup values correctly.
3. Edit a property to refresh the lookup column schema: You can try updating the original lookup column (for example, add a description, save it, then remove the description and save again). This sometimes forces SharePoint to refresh the column schema and resolve the issue.
If that doesn’t help, re‑creating the column is the most reliable fix.
4. Try creating a brand‑new lookup column
This is the quickest way to confirm whether the issue is with the column itself.
Create a new test column with:
- Lookup > same source list
- Allow multiple values > Yes
Then try saving multiple selections.
If the new column works: The original column is likely corrupted. Re‑create it and migrate the data to the new column.
If my post solved your issue or answered your query, please mark it as a Solution and give it a Like.