Skip to main content
Question

Sudden failure to return email address from SharePoint Online Person of Group column

  • 11 July 2024
  • 1 reply
  • 11 views

We have a component workflow running in NAC which returns values from a Person or Group column in SharePoint Online based on a text role name that is passed in to the component. We use the results from this column to create a string of email addresses which are passed back to the caller workflow for use with task approval and email notification actions.

 

This effectively allows us to keep a single master list of all roles used for various task approvers on workflows throughout our organization.

 

This component has been working fine since February and we have not changed the workflow actions nor the SharePoint list since that time. Yesterday July 10th, around midday EST, the component started returning an empty string after querying the list. The Person or Group column used to return the email address for a Person by default, now there is nothing.

 

We have verified the query a list action is not failing, the column in question contains data, we can return values from other columns in the list which are not ‘Person or Group’ type, and verified that no structural changes were made to the list in recent history.

 

We have put in a ticket with Nintex, but has anyone else experienced an issue querying a list with a Person or Group column (with allow multiple selections set to Yes) that has suddenly started returning empty string?

1 reply

Badge +2

We figured out how to get it working again, but still no root cause.

 

In the Person or Group column, we had to go to edit, then change the ‘Show field’ drop down from ‘Work email’ to ‘Name (with presence)’.

 

Problem is we’ve had it set to ‘Work email’ the whole lifetime of the component without issue, until yesterday. For whatever reason this worked, in case anyone has a similar issue.

Reply