Skip to main content

Notifications

Power Apps - Building Power Apps
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Update SharePoint list record permissions based on another SharePoint List (as a table to manage permissions)

Posted on by

Hi everyone,

 

I've been trying to build this flow for a few days and cannot seem to get it working properly. I have two SharePoint Lists: 

Example:

List_1_Items: This is a list of unique actions and includes items like City, State, Country

List_2_Access_Table: This list only has City (unique), State (there are duplicates), Country (there are duplicates) and person/user field

 

When a new item is created or modified in List_1_Items, I want the flow to look up List_2_Access_Table, find the matching City record and assign the person/user as someone who now has permission to that record.

 

My flow uses:

- When an item is created or modeifield (List_1_Items)

- Get Item (List_1_Items)

- Get Items(List_2_Access_Table) 

- Grant Access to an Item or Folder (List_1_Items)

 

I have tried using a condition (true: City = City; false: do nothing) as well as a Filter Query (for Get Items(List_2_Access_Table)), but the flow doesn't work....

 

Any help would be appreciated.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard