Forum Discussion
Error 'Cannot get value for projected field...' when users without email were set to the field
SharePoint List Setup I have a simple list with a Person field Approvers which allows multiple selections. One of the list items has a user set to the Approvers but the said user does not have email...
This is a known limitation in the SharePoint REST API. If any user in a Person field (like Approvers) lacks an email, projecting Approvers/EMail will cause the query to fail.
Instead, you can use the Name field to extract the UPN (User Principal Name), which often contains the email. Then, in your code, parse the email from the login name.
items?$filter=Id eq xxx&$select=Id,Title,Approvers/Id,Approvers/Title,Approvers/Name&$expand=Approvers