This is a known behavior with Dataverse lookups. If a value populates correctly on the main form but appears blank within a system view, it typically comes down to one of these core issues:
Security Restrictions: This is the most common cause. If the running user lacks Read permissions on the targeted table (in this case, the User table), or if Column-Level Security is enabled on that specific lookup field, the grid engine will mask the data and display it as blank.
A View is essentially a SQL-like join. To display a lookup column in a grid, the view engine has to look at your main table, follow the lookup relationship, and pull the "Primary Name" from the other table. If the user's security role lacks Read access to that secondary table, the system will still let them see the main rows in the view, but the grid engine will silently fail to pull the related name, leaving just that specific column completely blank.
Field Mismatch in the View Canvas: Double-check that the view is referencing the exact same schema name as the form field. If a field was ever recreated, renamed, or duplicated with similar display names, the view might simply be pointing to a different, unpopulated column.
Primary Name Column Resolution: Dataverse views display the value stored in the Primary Name column of the lookup's target record. If the targeted record has an empty or unpopulated primary text field, the lookup column in the view will have no string to display and will appear empty.
Asynchronous Caching: Occasionally, metadata changes do not immediately sync to the grid rendering engine. Try performing a "Publish All Customizations" in your solution, then clear your browser cache or test in a private browsing window.
Since your other lookup fields are rendering correctly, start by verifying your security roles and read access boundaries on the target table.
✅ If one of the responses here solved your issue, please mark it as Accepted so others facing the same problem can benefit as well.
👍 If this or any other reply here helped you, feel free to give it a Like. It helps others and is always appreciated.
