Querying a list in SharePoint Online fails to lookup person or group column

  • 26 March 2021
  • 0 replies
  • 346 views

Userlevel 2
Badge +9

Issue

The Query a List action, which queries a list in SharePoint Online, fails when a Person or Group column is on the list.

 

Error Code

{"message":"SharePoint returns exception: InternalServerError, ResponseStatus: Completed - Cannot get value for projected field RenewalContact_x005f_EMail.","correlationId":"0000xx0x-0000-0000-00x0-00x00x0x0x00_0x000x0x-x0x0-0xx0-0000-00x0000xxx0x_1_1"}

 

Resolution

Ensure that all users in the Person or Group column has an email associated with their account. If no email is present, this issue will occur.

 

Additional Information

This errors come from SharePoint Online rather than Nintex Workflow Cloud. Sending the same query manually outside of Nintex Workflow Cloud results in the same error.

 


0 replies

Be the first to reply!

Reply