Unanswered

[Specified user i:0.f|membership| could not be found] when patching Person/Group record

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all, I'm getting an error that states "The requested operation is invalid. Server Response: Employee Changes failed: The specified user i:0#.f|membership| could not be found" I've seen several other posts about this with solutions marked, but none of them have worked for me. Not sure if I'm missing something. My submit button code is below. The form is always in FormMode.New if that makes a difference as these forms don't get edited in this use case. Any help is appreciated 🙂

SubmitForm(Form2);
Patch(
'Employee Changes',
Form2.LastSubmit,
{
Title: "EmployeeName",
'Employee Name': {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(DataCardValue11.Selected.Mail),
DisplayName: DataCardValue11.Selected.DisplayName,
Department: "",
Email: DataCardValue11.Selected.Mail,
JobTitle: "",
Picture: ""
}
}
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Pulling up a monitor, I see this when I click the Submit button on the app.

"data": {
    "context": {
      "entityName": "SubmitButton",
      "propertyName": "OnSelect",
      "id": 573,
      "nodeId": 29,
      "diagnosticContext": {
        "dataOperation": {
          "protocol": "cdp",
          "operation": "patchRow",
          "apiId": "/providers/microsoft.powerapps/apis/shared_sharepointonline",
          "dataSource": "Employee Changes",
          "table": "5e9621ae-5bf7-4c45-931c-7cf8afeb2119",
          "operationName": "CdpConnector.patchRowAsync"
        },
        "formula": "SubmitForm(Form2);\nPatch(\n    'Employee Changes',\n    Form2.LastSubmit,\n    {\n        Title: \"EmployeeName\",\n        'Employee Name': {\n            '@odata.type': \"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser\",\n            Claims: Concatenate(\"i:0#.f|membership|\" & Lower(DataCardValue11.Selected.Mail)),\n            DisplayName: DataCardValue11.Selected.DisplayName,\n            Department: \"\",\n            Email: DataCardValue11.Selected.Mail,\n            JobTitle: \"\",\n            Picture: \"\"\n        }\n    }\n)",
        "span": {
          "start": 19,
          "end": 526
        }
      }
    },
This part confuses me, why is the second quotation outside of the \ bracket? \"i:0#.f|membership|\"
Claims: Concatenate(\"i:0#.f|membership|\" & Lower(DataCardValue11.Selected.Mail)),\n

Later in the monitor I'm seeing this, which I'm assuming is an indication that the Concatenate failed and why I'm getting the error message I'm getting.
"body": {
        "EmployeeName": {
          "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
          "Claims": "i:0#.f|membership|",
          "Department": "",
          "JobTitle": "",
          "Picture": ""
        },
        "Title": "EmployeeName"
      }
    },

Was this reply helpful? Yes No
RacRig5407 74 on at

Like
a
(0)

Report
Copy link

Link copied!

I am fighting with this as well. I can see that the variable I'm using absolutely does have a value and it's correct. But for some reason it's not making it to SharePoint.

Was this reply helpful? Yes No