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 / Column permission impl...
Power Pages
Unanswered

Column permission implementation is not working as expected

(0) ShareShare
ReportReport
Posted on by 26

Hello Team,
We are working on adding column permissions for tables where we don't want to the Authenticated user to have write and create access to some columns. But after creating some column permissions with only read access, we were able to call web API and create entry to the column which have only read access.
Our site is having Enhanced Data Model, where we were not able to add column permissions through web roles. But we have added the column permissions directly through column permission profile, where we added columns permissions, role access and also added "Authenticated Web Roles" in the web role section. But it is not working as expected and we are able to update the columns which is only having read access through web API.

Categories:
I have the same question (0)
  • Fubar Profile Picture
    8,487 Super User 2026 Season 1 on at

    It is most likely your Web Role.  Having a Web Role with the Authenticated ticked/checked means that any user that is signed in could inherit that Web Roles table permissions (i.e. gets the Permissions without direct assignment of the Web Role). Also,

    • If making use of inheritance, then you should only ever have 1 Web Role with authenticated checked for a site, as users will inherit from only 1 if there are multiple
    • If there are multiple with authenticated checked, the system will choose which one each user inherits

     

  • NikhilDey Profile Picture
    26 on at

    Hello @Fubar 
    Thanks for your reply.
    We are only using one web role that is "Authenticated User" which was there by default.

    I think this is the issue with the data model which my site is using i.e Enhanced data model.
    I tried adding the same column permission in Standard data model site, where the functionality is working as expected. We have raised the support ticket for the same but they are also unable to help us as the Enhanced data model is in preview mode.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Pages

#1
DP_Prabh Profile Picture

DP_Prabh 41

#2
oliver.rodrigues Profile Picture

oliver.rodrigues 35 Most Valuable Professional

#3
rezarizvii Profile Picture

rezarizvii 28

Last 30 days Overall leaderboard