When you use a lookup column in SharePoint, you expect it to show only valid items from the source list. But sometimes the lookup column displays items that have been deleted from the source list. This can cause confusion for users who see old or irrelevant data in forms, views, and reports. The root cause … Read more
When you delete a list item that is referenced by a lookup column in SharePoint, the lookup column continues to display the deleted item. This behavior causes confusion because users see entries in a lookup field that no longer exist in the source list. The root cause is that SharePoint lookup columns store a static … Read more
When a SharePoint lookup column displays items that you have deleted from the source list, site owners often find the behavior confusing. The root cause is that a lookup column stores the ID of the source item, not the item itself. If the source item is deleted, the lookup column still retains the ID, which … Read more
When you type a name in a SharePoint Person or Group column, the search may return no results for a new user who was recently added to the organization. This happens because SharePoint maintains its own user profile cache that does not update immediately when a new user is created in Microsoft 365. This article … Read more
When you type a name in a SharePoint person column, the search often returns no results for a user who was just added to the organization. This happens because SharePoint does not automatically sync new user profiles from Microsoft Entra ID. The person column relies on the SharePoint User Profile service, which can take 24 … Read more
You created a calculated column in SharePoint to display a future date, a past date, or a date difference, but the result is off by one day, shows a serial number, or returns an error. This happens because SharePoint stores dates as serial numbers in Coordinated Universal Time and applies the site collection time zone … Read more
You create a calculated column in a SharePoint list that should show a future date, a past date, or a date difference. Instead, the column displays a date that is off by exactly one day or shows an unexpected year. This problem almost always happens because SharePoint interprets the date formula differently than you expect, … Read more
When you open a SharePoint list view that should display only a few items but instead shows an error message or an empty result, the list view threshold is likely blocking the view. This happens because SharePoint enforces a 5,000-item limit per view for lists and libraries in SharePoint Server and SharePoint Online. The threshold … Read more
When you open a filtered view in a SharePoint list, you may see an error message stating that the view is blocked because it exceeds the list view threshold. This happens even when the filter should reduce the number of items shown. The root cause is that SharePoint evaluates the total number of items in … Read more
You built a filtered view in SharePoint to show only the items you need. But when you or your team members open that view, you see an error instead of the filtered data. The error says the view exceeds the list view threshold, which is 5,000 items for a default SharePoint list or library. This … Read more