Patch function that is working within an envorinment fails in another

[aulibrisuser]

I have a canvas app that creates a new record in a SharePoint list, this app has a Patch functions which sends a data to the SharePoint list. This function works as expected in one environment, but when I export the application to a new environment it fails with the following error message:

The requested operation is invalid. Server Response: Teams Request failed, the specified user i:0#.f|membership|John Smith could not be found.

I have refreshed the connectors withing the new environment, here is the code for creating the request properties and the ptach function.

Creating the form/patch properties:

Navigate(Screen_Opprett_Team_Review);
ClearCollect(
colTeamsProperties,
{
Title: Concatenate(
Text(txt_TeamName.Text)
),
Owners: ClearCollect(
colOwners,
ForAll(
cmb_RoomOwners.SelectedItems As owner,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Department: owner.Department,
Claims: "i:0#.f|membership|" & owner.DisplayName,
DisplayName: owner.DisplayName,
Email: owner.Mail,
JobTitle: owner.JobTitle,
Picture: ""
}
)
),
Approval: {Value: "Pending"},
RoomDescription: Text(txt_RoomDescription.Text),
Members: ClearCollect(
colMembers,
ForAll(
cmb_RoomMembers.SelectedItems As member,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Department: member.Department,
Claims: "i:0#.f|membership|" & member.DisplayName,
DisplayName: member.DisplayName,
Email: member.Mail,
JobTitle: member.JobTitle,
Picture: ""
}
)
),
Template: If(
IsBlank(cmb_SelectTemplate.Selected.Value),
"Blank",
Text(cmb_SelectTemplate.Selected.Value)
),
RoomPrivacy: If(
tgl_RoomPrivacy.Value = false,
{Value: "Public"},
{Value: "Private"}
),
RoomScope: If(
tgl_RoomScope.Value = false,
{Value: "Yes"},
{Value: "No"}
)/*
RoomScope: tgl_RoomScope.Value*/
}
)

Sending the patch request:

Patch(
TeamsRequest,
colTeamsProperties
);
If(
// check if there were any errors when the request was submitted
!IsEmpty(Errors(TeamsRequest)),
// if true, show any error message
Notify(
Concat(Errors(TeamsRequest), Column & "Team order failed. Error details : " & Message),
NotificationType.Error
),
// else, go to success screen
Navigate(
Screen_Success,
Fade
);
)

[iAm_ManCat]

Hi @aulibrisuser 

Normally the claims field uses an email address or User Principal Name, but you are using displayname?

I'm not sure why it was working in your original environment (shouldn't have), but could you try using Email or UPN instead?

Claims: "i:0#.f|membership|" & owner.Mail,

[aulibrisuser]

The app was using "owner.Mail" initially but changing it to "DisplayName" solved this issue in the previous environment. I have now changed the claims to use "Mail", and that results in the same error message, just without the user name. So the error message now looks like this:

The requested operation is invalid. Server Response: Teams Request failed, the specified user i:0#.f|membership| could not be found.

[iAm_ManCat · Accepted solution]

ok, so that means that the particular account it's trying to reference does not have an email set, as its adding (blank) to the end of 

i:0#.f|membership|

- have you put your colMembers in a gallery to ensure that all of your items have data?

You might need to filter your colMembers to only have items with a valid email address.

Claims works in the SharePoint person column context by using an email address to associate that person object with a unique account - displayname can't be used for this as there could be more than one person with the same name, but there can't be more than one person with the same email address in Active Directory

[aulibrisuser]

Thanks! You are correct, looking at my collection after running the "ClearCollect" function I could see that the collection containing the user does not contain a user email. I found out that this is due to the user being unlicensed.

Appreciate your fast responses @iAm_ManCat, thanks a lot!