Answered

Network Error when using the patch function. The requested operation is invalid

(0) Share

Report

Posted on by zayarminaye

Dear All,

I am having error described in title. It worked fine when i started to build the app. After I have released for users, user cannot patch the record and I (as developer) cannot also patch the record for Person column only. Other column types worked fine. Required permission to perform the operation like Read/Write access to SP list is in placed. Here is my patch function in the app.

Patch('SharePointList', LookUp('SharePointList', ID = varSelectedItem), {Title:txtAccountName.Text, TYPE: {Value: txtAccountType.Text}, Owner:{Claims: "i:0#.f|membership|" & If(IsBlank(cbOwnerName.Selected.Mail), LookUp('SharePointList', ID = varSelectedItem).Owner.Email),
Department: cbOwnerName.Selected.Department,
DisplayName: cbOwnerName.Selected.DisplayName,
Email: cbOwnerName.Selected.Mail,
JobTitle: cbOwnerName.Selected.JobTitle,
Picture: ""}, Team: {Value: ddTeam.Selected.Value}, Description: txtDescription.Text, 'Interactive Logon?': Radio1.Selected, StillUseOrNot: Radio1_1.Selected});

I have no idea how to fix the issue. Any idea what went wrong ?

Any support is highly appreciated.

Best Regards,

Zayar

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @zayarminaye ,

The first thing to try is getting the calculation out of the patch as below

With( { _Mail: Coalesce( cbOwnerName.Selected.Mail, LookUp( 'SharePointList', ID = varSelectedItem ).Owner.Email ) }, Patch( 'SharePointList', { ID: varSelectedItem, Title: txtAccountName.Text, TYPE: {Value: txtAccountType.Text}, Owner: { Claims: "i:0#.f|membership|" & Lower(_Mail), Department: cbOwnerName.Selected.Department, DisplayName: cbOwnerName.Selected.DisplayName, Email: cbOwnerName.Selected.Mail, JobTitle: cbOwnerName.Selected.JobTitle, Picture: "" }, Team: {Value: ddTeam.Selected.Value}, Description: txtDescription.Text, 'Interactive Logon?': Radio1.Selected, StillUseOrNot: Radio1_1.Selected } ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
zayarminaye 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz , Sir, It worked like a charm. Thank you so much for your solution. Appreciate it.

Was this reply helpful? Yes No