I have been looking at the view filter area in a SharePoint list and wondering if the ability to check if a column is equal to [Me] can be expanded to allow some views to only show items to specific admin like users? This is to get around the fact that individual views cannot be shown or hidden from specific users, and the built in item level permissions only work for the item creators (which in this case any user can create items).
Essentially what I am trying to do is control the visibility of certain views, since there are some views which are intended to be admin only (eg. see everyone's items) and others that anyone can see (eg. see only their items). So far the solution I have thought of is to add a hidden people column to the list where the names of the admins would be, which I can then filter to equal [Me] and therefore any user not in this column (not an admin) will see no items in this view. Now in order to not have to populate such a column manually each time, I am thinking of creating a flow that will populate it on item creation. So the only manual part will be when creating a new view and deciding whether it needs to have the filtering added or not (whether only admins can see the items or not). I could then create a second flow which runs periodically and checks this column is up to date eg. if the users who are admins changes.
Is this the only way I could achieve this kind of functionality or is there a better way or perhaps feature I have missed?
