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 settings fo...
Power Pages
Unanswered

Permission settings for LookUp tables

(0) ShareShare
ReportReport
Posted on by 375

Hi

I'm building a Power Pages site (my second one) and I'm gradually understanding the quirks.

However, this one is perplexing.

 

I have a table that includes a lookup to another table.

In the data section (where you create Views & Forms) I can happily select and save an option in the lookup column.

However, when I open up the form in the web page to add/edit and click the search option to find an option I get a 'You don't have permissions to view these records'.

 

At this stage I'm keeping the permissions quite open (all options and roles added) and will reduce access in due course. Currently I can save/view/edit/delete entries but I can't pull through the lookup values into the Form to add/edit them. Additionally, when editing items where I've selected an option in the data section I get a 'Form could not be submitted due to appropriate permissions' error.

 

What permission do I need to set (and on what) to be able to pull the lookup options through and be able to save them?

 

Thanks in advance.

 

Categories:
I have the same question (0)
  • Verified answer
    Gary_Eden Profile Picture
    375 on at

    Typical, I've just figured it out.

     

    For the table used as the LookUp you need to add a Table Permission to it with Read and Append selected with the same roles as the main table permission.

     

    It now works.

     

     

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