web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Permission issue when ...
Power Pages
Unanswered

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:
I have the same question (0)
  • domliu37 Profile Picture
    314 Super User 2024 Season 1 on at

    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

  • mojomark Profile Picture
    6 on at

    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?

  • Verified answer
    domliu37 Profile Picture
    314 Super User 2024 Season 1 on at

    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

    Thanks for the extra eyeballs. That was the 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Jerry-IN Profile Picture

Jerry-IN 71

#2
Fubar Profile Picture

Fubar 62 Super User 2025 Season 2

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard