Edit item people column The specified user i:0#.f|membership| could not be found

(0) Share

Report

Posted on by JimmyW

2,563

I have a weird issue in my power app.

I have a form with a column named "Select Approver"

Items list users.
Update =

If(DataCardValue1.Selected.Value = "Access Request",
{ 
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 Department: "", 
 DisplayName:DataCardValue29.Selected.displayName,
 Claims:"i:0#.f|membership|" & DataCardValue29.Selected.mail, 
 Email:DataCardValue29.Selected.mail,
 JobTitle: "",
 Picture: ""
}, Blank())

When i create and submit a new item to SharePoint using SubmitForm everything works and the user is displayed correctly in the SharePoint people column.

Now if i go to the item and select Edit and i try to save it i get the following error.
The specified user i:0#.f|membership| could not be found.

But if i Edit the item and re-select the user in the combobox "Select Approver" then saving it works fine without any error. But i need to re-select the user even if it is already selected.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

mdevaney 29,989 Moderator on at

Like (1)

Report
@JimmyWork

Type this code into the Text property of a label. What does it display when your form is in Edit Mode right before clicking Save where the problem occurs.

"i:0#.f|membership|" & DataCardValue29.Selected.mail

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

JimmyW 2,563 on at

Like (0)

Report
@mdevaney Thank you for answering.

I found the issue.
In the update i need to put = DataCardValue29.Selected
And in Default i put

If(DataCardValue1.Selected.Value = "Access Request", { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Department: "", DisplayName:DataCardValue29.Selected.displayName, Claims:"i:0#.f|membership|" & DataCardValue29.Selected.mail, Email:DataCardValue29.Selected.mail, JobTitle: "", Picture: "" }, Blank())

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (1)

Report

@JimmyWork
I'm not sure why it works but i'm glad you found the answer. Be sure to accept your own post as the solution. 😀

Best of luck building your app!

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report

Hi

I'm getting the same error.

Can you help me because it doesn't work for me.

Was this reply helpful? Yes No