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

(0) Share

Report

Posted on by JimmyW

2,567

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

All responses (4)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@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."
Verified answer

JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!
@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())
mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@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!
indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

I'm getting the same error.

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