In my list there is a column for email addresses and one for usernames. The email addresses are added through a workflow and are not necessarily the same as the ones stored in the user profiles.
I want to create a list view that is filtered to show only those entries where the current user's email address is the SAME as the email address supplied in the list.
Apparently, there is no variable that can be used in the regular list-view filter. And I can't figure out any way to get the current user's email address via calculated columns.
Maybe it's possible to use an xsl trick to fetch the current user's email address?