Skip to main content

Notifications

Community site session details

Community site session details

Session Id : rBK+ieLoFfq+IzaEKwSu3g
Power Pages - Design & Build
Answered

Permission settings for LookUp tables

Like (0) ShareShare
ReportReport
Posted on 22 Sep 2023 08:03:15 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.

 

  • Verified answer
    Gary_Eden Profile Picture
    375 on 22 Sep 2023 at 08:20:36
    Re: Permission settings for LookUp tables

    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Pages - Design & Build

#1
oliver.rodrigues Profile Picture

oliver.rodrigues 16 Most Valuable Professional

#2
Ă–E-05091504-0 Profile Picture

Ă–E-05091504-0 6

#3
JB-10040341-0 Profile Picture

JB-10040341-0 2

Overall leaderboard

Featured topics