Answered

Dataverse Patch Error - Network error when using Patch function: You don't have permission to create this row.

(0) Share

Report

Posted on by cmanning

228

I have a canvas Power App that executes a Patch() to add a new user to the AssignedUsers table in Dataverse. This has been working for me in both my Dev and Prod environments when I am logged in using my respective service accounts. However, when I test it using my work email, I get this error: "Network error when using Patch function: You don't have permission to create this row."
DV Permissions Issue - PATCH Lack Permissions to Create Row Blurred.png
I have created a dedicated DV role for this app and have the permissions set for the AssignedUsers table as follows.
DV Permissions Issue - PATCH AssignedUsers Permissions.png

My Patch looks like this.

Set( varRecord, Patch( AssignedUserss, {
 cr4de_assignedfullname: dropdownAssignedUser.Selected.'Full-Name',
 cr4de_assignedemail: assignedUserEmail,
 cr4de_roleassigned: dropdownAssignedRole.Selected.cr4de_role,
 cr4de_DRID: LookUp(DealIntakeApps, Name = vSelectedGalleryLHAssignedResources.Name),
 PercentAllocated: 0,
 cr4de_created: Now()
 } )
 );

 // Determine if Patch was successful
 If(!IsBlank(varRecord),

This code has been working for months so it must be a DV-related permissions issue but I have never seen this error before. Thanks in advance to anyone with recommendations.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

AhmedSalih

6,678 Moderator on at

Like (2)

Report

Hello, @cmanning, make sure that your work email account has a security roles assigned for that table you are trying to patch.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Gowri Halan 262 on at

Like (3)

Report

@cmanning If you trying to update any lookup field. Then set append and append to rights as well.

Was this reply helpful? Yes No
cmanning 228 on at

Like (0)

Report

@AhmedSalih - Thank you for the info. I just needed to associate my email with the new DV user role. Marking as the solution, thanks!

Was this reply helpful? Yes No
cmanning 228 on at

Like (0)

Report

@gowrihalan04 - Thank you for the very useful info!

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (1)

Report

@cmanning, Always happy to help 🙂

Was this reply helpful? Yes No
issac_franklin 113 on at

Like (0)

Report

Hello @AhmedSalih @gowrihalan04

It would be great if you could help me as well. I am facing the same error.

I have created a different role which has create/read/write permissions and assigned to this user. However, it doesn't work with custom role or basic user.

When I assign System Administrator role, user can create a row in table.

It would be great if you could help me here 😉

Was this reply helpful? Yes No
Palaces 81 on at

Like (0)

Report

@gowrihalan04,

Awesome!
Thank you for sharing this!!
As a note for you future reader, you have to set Append and Append To permissions on both tables, the one being referenced and the one that contains the lookup field.

Best regards! 🙂

Was this reply helpful? Yes No
Palaces 81 on at

Like (0)

Report

@gowrihalan04,
Thanks for posting this, I almost pass your comment because of focusing my reading on the solution here.
As a note for future readers, you have to add the Append and Append To permissions on both tables, the one containing the Lookup field and the one being referenced.
Best regards,

Was this reply helpful? Yes No
Santhosha 4 on at

Like (0)

Report

@AhmedSalih @cmanning @gowrihalan04 @issac_franklin
I am also facing the same error.
The user is able to add the records from app if I give organisation access.
But it is throwing error if we use Parent child B U access.
I given parent child bu access for read , write, create,append and append to.
We have a BU hirarchy from
All country users to individual country BU.
This is working till last 15 days.But not working now

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

Hello, @Santhosha, would you please create a new Post with your issue. Thank you

Was this reply helpful? Yes No