I'm trying to figure out how to show a view of a library only to users who are a member of a SharePoint group, which is also specified in the document library as a value in a column.
If I add a document and I need to add extra information about that document to a column named "Groups" and I add a group named "Administrators", then I want to make sure only members of the "Administrators" group can see that document. When I add another document and this time add a group named "Visitors" to the "Groups" column, then only members of that group should see that document but not the document I uploaded earlier (so not the one only members of the "Administrators" group should see).
Basically, view permissions on document level.
I'm trying not to sound too complicated here, but language might be a barrier.
I tried the answer that was mentioned in this question but it does not seem to work for me.
I thought this would work if I set a filter where I'd select the column containing the name of the group (it's a person or group column) and then check if it contains [Me]. Unfortunately that gave me an error similar to the screenshot posted in the question I mentioned above, and even if I change it to "equals" instead of "contains" it doesn't give the desired result (no more error though, but not a solution either).
I made sure that the page that holds the library web part has been checked in, as well as the web part being updated by reselecting the view, yet it is to no avail.
Any help about this would greatly be appreciated.