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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Permission issue when ...
Power Pages
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:
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?

    contact_perms.PNG
    opp_perms.PNG
  • 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
11manish Profile Picture

11manish 50

#2
Valantis Profile Picture

Valantis 26

#3
omkarsupreme Profile Picture

omkarsupreme 24

Last 30 days Overall leaderboard