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.