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 Apps
Answered

Passwords

(0) ShareShare
ReportReport
Posted on by 26

I have a power app that leads to a sharepoint. I would like to have restrictions on who can edit a specific row based on what the location cell says. So say John is the only one who can edit an item that has Texas as one of it's values. I would like to create this restriction and or create a passrod so they can only edit their own locations 

Categories:
  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @aleisure99,

    Could you please share a bit more about your scenario?

    Do you want to make the user edit only the records including the same location?

     

    Here is what I assume, John has a location Texas and some users has Texas too, so only those who share the same location Texas could edit the records with the Texas, right?

     

    If so, please tell me how you edit a specific row, select within a Gallery and then navigate you to the edit form?

    If there is a Gallery, then you could set the Items property as below:

    Filter(List,Location=LookUp(List,User().Email=PersonColumn.Email).Location)

    So that current user could only view the records sharing the same location.

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 354 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 330

#3
Mohsin Ali Profile Picture

Mohsin Ali 232

Last 30 days Overall leaderboard