Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
Answered

Permission issue when changing lookup field on Opportunity

(0) ShareShare
ReportReport
Posted on by 6

I have a Powerapps Portal basic form displaying an Opportunity. I have a table permission that allows the user to update the opportunity as necessary. For most fields, the update is successful. 

 

However, I want to update a lookup field that contains the contact who owns the opportunity. The popup window shows the correct list of contacts, I select one and when I save the record I get the dreaded:

  • You don't have the appropriate permissions.

I have a table permission for contacts, Access type "account" as they should only see contacts related to their own account. I have read, write, create, append, append to privileges set, and granted to the web role assigned to my user. 

 

What am I missing?

Categories:
  • mojomark Profile Picture
    6 on at
    Re: Permission issue when changing lookup field on Opportunity

    Thanks for the extra eyeballs. That was the issue.

  • Verified answer
    domliu37 Profile Picture
    314 Super User 2024 Season 1 on at
    Re: Permission issue when changing lookup field on Opportunity

    Hi @mojomark,

    Try change the contact table permission from Account access type to Parent, and select that opportunity table permission as the parent.

     

    Cheers,

    Dom 

  • mojomark Profile Picture
    6 on at
    Re: Permission issue when changing lookup field on Opportunity

    Thanks for the look....

     

    Yes, the lookup is on a filtered list of contacts who are related to the assigned account.

     

    Perms seem to be set appropriately.

    Does the contact permission need to be a Child permission of the opportunity?

  • domliu37 Profile Picture
    314 Super User 2024 Season 1 on at
    Re: Permission issue when changing lookup field on Opportunity

    Hi @mojomark ,

     

    So does that lookup just for the contact table?

     

    Can you please share the current table permission set up for opportunity table and contact table?

    Based on your description:

    the opportunity table permission should have read/create/write/Append/Append To 

    the contact table permission should have read/Append/Append To 

     

    Cheers,

    Dom

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >