I am trying to restrict view to my list and only allow specific members to see specific items when a condition is met.
Certain users should only be able to view those items in the list that match a condition:
Let's say I add new item and set location as KSA - only a specific member of my team should see those under KSA, and another can only see those in Lebanon. Applying different views won't work as they are not allowed to be able to see any of the other items except for those in their region.
Is there a way I can apply a workflow to achieve this?