cant collect person column items, resource not found

[Perez]

Hi,

I'm trying to collect users from a person column in SharePoint,

use case: if this user is from NOC than collect the user, later i will use the concatenated UPNs to send a mail.

for some reason I'm getting a resource not found error although i know the users exist, any idea what I'm doing wrong?

screenshot:

MyTo is the collection im trying to create with the persons

colFocals is a collection of a list of focal points

Focalpoint is a person column

EscalationGroup is a multi choice column with list of group/ teams

 error text:

Office365Users.UserProfileV2 failed: {"error": {"code": "ResourceNotFound', "message": "User not found", "innerError": {"date": "2024-07-01110:36:31", "request-id": "2a30e5b9-fd9d-4b84-8f75- X 173ba3e12437", "client-request-id": "2a30e5b9-fd9d-4b84-8f75-173ba3e12437"}}}

thanks. 

[v-jefferni]

Hi @Perez ,

Could you please check if this Focalpoint set to allow multiple in SP list?

Best regards,

[Perez]

Hi @v-jefferni ,

thanks for your fast reply.

it is not set to a multiple selection but to single.

it is also set to people and groups selection

[v-jefferni · Accepted solution]

Hi @Perez ,

Will you be able to view the preview data from the dropdown of formula bar when selecting the whole formula?

Anyway, please try and add an IfError function to your formula, maybe some user has been deleted from directory but in SP list it's still there:

ForAll(Filter(...).Focalpoint,If(!IsBlank(ThisRecord.Focalpoint), IfError(Office365Users.UserProfileV2(ThisRecord.Focalpoint.Email),Blank())))

Best regards,

[Perez]

the iferror works like a charm!! thanks.

one thing i didn't understood, in my formula i used the ISBALNKORERROR formula, shouldn't it do the same?

[v-jefferni]

Hi @Perez ,

Because this function is used for checking if it's error or blank in a Focalpoint field, but the error was throwing by the Office365Users.GetUserProfile action, due to an invalid Email address as the input value.

Best regads,