I would like to filter a list based upon a user group that the user may belong to and a specific value found in the User Information List for that user.
I tried doing this with CAML in SharePoint Designer but was not able to retrieve a value from the User Information List based upon the current user. (I was able to filter by the user group though.)
I found a tool that did a lookup on this list, but it required WSS 3.0 and I am running SharePoint Foundation.
Can I do a lookup on certain field in the User Information List for the logged in user and store that value in a variable in Sharepoint Designer? Will I need to use VS?