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 Automate / SharePoint Columns dat...
Power Automate
Unanswered

SharePoint Columns data used for permission restriction (Custom column metadata or People picker column data for user permission restriction)

(0) ShareShare
ReportReport
Posted on by 25

kk13_0-1674508469539.png

Can People picker column data be considered metadata? And custom filtered view on basis of people picker column be considered filtering through metadata? Additionally Item level restriction in Advanced settings of List is - "Columns (metadata) used for permission restriction"?

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    @kk13 ,

     

    The feature you have there only works on the system Created By field.

    You can achieve conditional (metadata-driven) item permission security using flow.

    Manage list item and file permissions with Power Automate | Microsoft Learn

     

  • kk13 Profile Picture
    25 on at

    If i create a custom View with [Me] filter with read permission to all users.
    It restricts user to view other user created items/documents.
    Can it be considered "Columns (metadata) used for permission restriction"

    I am little bit confused with regards of metadata and if it is possible to have item level permission only with the use of custom column and its metadata (no power automate used)
    Plz help

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    Creating a view does not achieve item-level security.

    View simply filters the data for the user.

    The user can still access (what they can't see) by creating another view or using REST queries.

    So the answer to your first question is No

     

    If you want to restrict their access to the data you need to go with item level permissions

     

  • kk13 Profile Picture
    25 on at

    Is data in people picker field considered metadata?

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    Yes

     

  • kk13 Profile Picture
    25 on at

    is there any other way i can have item level permissions "without" using power automate?
    just by using column metadata like custom JSON List/library view formatting?
    or any other approach?

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    No. You need to either use Flow or PowerShell.

     

     

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 598

#2
Valantis Profile Picture

Valantis 477

#3
Vish WR Profile Picture

Vish WR 370

Last 30 days Overall leaderboard