Skip to main content

Notifications

Community site session details

Community site session details

Session Id : m0cCPwzN39AVSdM7pPV9Tj
Power Apps - Building Power Apps
Unanswered

Column level Security in Powerapps

Like (0) ShareShare
ReportReport
Posted on 26 Dec 2024 13:54:45 by
Hello All, 
 
I have requirement to hide/show some column in Canvas app. So, we have enabled the column level security in dataverse table and created column level security profile in the environment . But how to get that whether logged in user is present in the column level security profile or not. 
 
 
Thanks 
Satyam 
Categories:
  • Pstork1 Profile Picture
    66,015 Most Valuable Professional on 26 Dec 2024 at 18:55:47
    Column level Security in Powerapps
    This walkthrough explains how it works. Column-level security - Power Platform | Microsoft Learn You don't need to determine what profile a user is in. If they don't have read or edit authority for the column they will just see a masked input field that can't be edited.  It doesn't hide the field, but doesn't show the value to those who don't have permission.

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     
  • SaiRT14 Profile Picture
    1,966 Super User 2025 Season 1 on 26 Dec 2024 at 16:29:14
    Column level Security in Powerapps
     
    try below approach
    • Create a view in Dataverse that filters users based on the security profile.
    • In your app, use this view to determine whether the logged-in user has access.
    • Use a Filter function to fetch records from the custom view and check for a match with the logged-in user.

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!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard
Loading started