Hi,
In Canvas App I would like to have 2 roles:
1 - master role with ability to see and edit all items in App
2 - with ability to see and edit only items created/assigned to the user
I found some articles how to filter gallery by current user:
Filter('Performance Reviews', Employee.Email=varUserEmail)
But I have no idea how to set 1st Master role, because If I filter gallery by function above that means my master role users also will see filtered gallery. And I want them to see all of items 😞
Users in master role have similar work position names, maybe it is possible to create var based on position in AD, and then using filtering basing on IF condition?
Please, give me some hints 😞