Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Suggested answer

User is missing prvAppendTo privilege (Canvas App, Dataverse)

(1) ShareShare
ReportReport
Posted on by 49
Hi!
 
When user tries to create a Dataverse table record from my Canvas App (entity, let's call it Table A, is in 1:N relationship to another entity, Country) they see the following error:
 
Principal user (Id=guid, type=8, roleCount=3, privilegeCount=217, accessMode='0 Read-Write', AADObjectId='guid', MetadataCachePrivilegesCount=4989, businessUnitId=guid),
is missing prvAppendTonew_Country privilege (Id=guid) on OTC=10471 for entity 'new_country' (LocalizedName='Country').
Consider adding missed privilege to one of the principal (user/team) roles.
 
User is member of a Microsoft Team. Canvas App is shared to that Team with Security Role assigned. 
 
Security Role has the following privileges for Table A entity:
 
 
And for Country entity:
 
 
If I check access to a particular Country I see the following:
 
 
Diagnostics for this user shows:
 
 
If this is the reason for this issue, how can I avoid it? My canvas app users are Team members and inherit their role from that Team and none of them has a security role directly (manually) assigned to them.
Categories:
  • IuriiPalchuk Profile Picture
    IuriiPalchuk 49 on at
    User is missing prvAppendTo privilege (Canvas App, Dataverse)
    @FLMike
     
    Hi!
     
    Well for the record, you said they are Creating... and you do not give them Create privileges, it says so in your own picture.
    They are creating a Table A entity with a lookup to Country. They are not creating a Country. And the error is not "missing Create privilege", it is "missing AppendTo privilege". That's why I specified permissions matrix for both entities. 
     
    As for your question, you cannot avoid it, you must assign them roles to access Dataverse Tables, etc etc.
    User inherits their Role from Team. But they don't have any Role directly assigned to them. Is this a root cause? Why then? If it is, how can I assign security roles directly to my end users automatically and what Role should it be (Basic User, I suppose)?
     
    Are you saying ONLY this user has an issue?
    This is a Test environment. This particular person is an example of a future app end user.
    Idea is to add users to the environment by adding them to a specific Microsoft Team and my canvas app is shared to this particular Team with a Role assigned.
    Other tester face no issues but they have a different set of privileges (e.g. Full Access to Country entity).
  • Suggested answer
    FLMike Profile Picture
    FLMike 31,580 on at
    User is missing prvAppendTo privilege (Canvas App, Dataverse)
    Hi
     
    Well for the record, you said they are Creating... and you do not give them Create privileges, it says so in your own picture.
     
    As for your question, you cannot avoid it, you must assign them roles to access Dataverse Tables, etc etc.
     
    Are you saying ONLY this user has an issue?
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics