The specified user i:0#.f|membership| could not be found

(2) Share

Report

Posted on by niklasjegg

505

Hello,

i have a strange problem that has never occured to me.

I am trying to Update some SPO Person Columns but i get this error

My Patch for my person columns looks like this.

I have also tried it without the O365 Lookup because im useing a Combobox with O365 Datasource. Still doesn´t work.

'Project manager': {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Claims: "i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUserV2().value,DisplayName = Responsible_Input_1.Selected.DisplayName).Mail),
 Department: "",
 DisplayName: Responsible_Input_1.Selected.DisplayName,
 Email: "",
 JobTitle: "",
 Picture: ""},
 Calculant:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Claims: "i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUserV2().value,DisplayName = Calculant_Input_1.Selected.DisplayName).Mail),
 Department: "",
 DisplayName: Calculant_Input_1.Selected.DisplayName,
 Email: "",
 JobTitle: "",
 Picture: ""},
 Pers_Div: Members,
 'Key account manager': {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Claims: "i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUserV2().value,DisplayName = KAM_Input_1.Selected.DisplayName).Mail),
 Department: "",
 DisplayName: KAM_Input_1.Selected.DisplayName,
 Email: "",
 JobTitle: "",
 Picture: ""},

Did i misspell something?

BR Niklas

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report
I would suggest debugging this with a label, make the label text the value you are intending to use after

"i:0#.f|membership|"

Then you can see why the value is not being correctly found - if it is blank it will fail to patch, additionally, I found out very recently that searchUser will also return contacts (whose Mail address will include the letters #EXT# and be invalid when patching to a People field) so the Mail address may be invalid for the returned value as it can't populate a people column in SharePoint with a contact (has to be an AD user or group)

If you have already used dropdowns then might I suggest a different approach? The values your dropdown searches (ie its Items) should be

Choices(Datasource[@ColumnName])

Then your patch contents will change to:

'Project manager': {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Claims: "i:0#.f|membership|" & Responsible_Input_1.Selected.mail), Department: "", DisplayName: Responsible_Input_1.Selected.displayName, Email: "", JobTitle: "", Picture: ""}, Calculant:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Claims: "i:0#.f|membership|" & Calculant_Input_1.Selected.mail), Department: "", DisplayName: Calculant_Input_1.Selected.displayName, Email: "", JobTitle: "", Picture: ""}, Pers_Div: Members, 'Key account manager': {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Claims: "i:0#.f|membership|" & KAM_Input_1.Selected.mail), Department: "", DisplayName: KAM_Input_1.Selected.displayName, Email: "", JobTitle: "", Picture: ""},

Was this reply helpful? Yes No
niklasjegg 505 on at

Like (1)

Report
Hello @iAm_ManCat

first of all for debugging. The label shows the selected displayname.

now patching like this
'Project manager': {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Lower(Responsible_Input_1.Selected.DisplayName), Department: "", DisplayName: Responsible_Input_1.Selected.DisplayName, Email: "", JobTitle: "", Picture: ""},

I tried to use the Choices in my Combobox and edited my patch to for now only patch the Choices Combobox.
This works. However i am useing a Filter for my O365 Accounts. Can i filter them too in choices?
Filter(Office365Users.SearchUserV2({searchTerm:Self.SearchText}).value,AccountEnabled = true,!IsBlank(Department),!IsBlank(Mail))
Thanks for the help!

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Claims needs to be an email address - that's why I had that in my example code 🙂

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

I'm not sure about filtering with the Choices option as those properties won't be exposed - if you use that and modify your patch to use a valid email address then it should be ok - for your label, we need to be debugging the Mail, not the displayname, as Mail is what the Claims field needs, and if it has an invalid mail then the patch will fail

Was this reply helpful? Yes No
niklasjegg 505 on at

Like (0)

Report
@iAm_ManCat
thanks i kinda got it. i don´t know why this is a problem right now. have been doing it so many times.

'Project manager': {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Lower(First(Office365Users.SearchUser({searchTerm:Responsible_Input_1.Selected.DisplayName}).Mail).Mail), Department: "", DisplayName: Responsible_Input_1.Selected.DisplayName, Email: "", JobTitle: "", Picture: ""},

Was this reply helpful? Yes No
niklasjegg 505 on at

Like (1)

Report
@iAm_ManCat this works without the choices 🙂
i am selecing the SPO item in a gallery first and setting
Set(varItem,ThisItem)
default selected property for combobox is
varItem.'Project Manager'
and only the displayname is working in the default selected options haha

pls kill me

Was this reply helpful? Yes No
AHMADSHOBARI 4 on at

Like (1)

Report

i dont know to solve this issue but popup message still :
The specified user i:0#.f|membership| could not be found

'IT Person': {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & ISM.Selected.Mail,
Department: "",
DisplayName: "",
Email: ISM.Selected.Mail,
JobTitle: "",
Picture: ""

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report

This is saying that ISM.Selected.Mail is blank at the point its being evaluated, the error message would be different if the value was not blank:

Blank:
The specified user i:0#.f|membership| could not be found

Not Blank:

The specified user i:0#.f|membership|jane.doe@example.com could not be found

Was this reply helpful? Yes No
Suggested answer

ranaansshahzad 2 on at

Like (0)

Report

I’m facing this error:

"The specified user i:O#.f|membership|8EVJ303@pennylane.org could not be found. clientRequestId: b153f1b2-fda9-4f17-919f-f565831735a5 serviceRequestId: fdcd92a1-f0a5-0000-8e96-f5."

This error appears on the *DefaultSelectedItems* of the **Person-type field**. When I open the form, the current logged-in user’s name shows up in the person field as expected.

However, when I submit the form, this error appears. But if I manually reselect or add the person again in that field, then the error doesn’t appear — which means the issue lies with the *DefaultSelectedItems* setup.

Please help me find a solution to this.

Error on Person F...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

1 people found this reply helpful.

Was this reply helpful? Yes No