We are calling expand on a people picker column of a custom list but get the following error due to a particular SharePoint user having a null value for EMail.

Cannot get value for projected field Designee_x005f_EMail

The REST call is _api/lists/getbytitle('TestList')/items?&$select=Id,Title,Designee/Id,Designee/Title,Designee/EMail&$expand=Designee

enter image description here

  • Have you tried using $filter=Email gt ''? – MickB Jun 12 '15 at 21:48
  • Yes, but the Designee/EMail portion of the select still causes it to fail. Not only that, but we don't want to filter out the users that do not have an Email; we still want to include the user as part of the search result. – Danny Bullis Jun 12 '15 at 21:52
  • Danny, Did you ever find a workaround? – Susan Anspaugh Jun 16 '17 at 18:19
  • Unfortunately, this was long enough ago that I can't really help out, I'm sorry. Best of luck! – Danny Bullis Jun 16 '17 at 18:21

According to this Microsoft Support Post link, it won't work unless you have a value specified for referenced item field added as lookup column item.

On the post you can read:

Please make sure the users you typed in BTApprover1 column have the FirstName. If not, the API REST will go wrong. If you aren’t sure if they have FirstName property, you can use Name property to test.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.