Contents
How to filter people and groups in list?
Our list has a people and group column (called Users) which we want to filter using [Me]. It works when the field only contains individual users, but when the field contains a group (either SP group or AD group) then rows for which [Me] is a member of the group it fails to match.
1. Create the STANDARD view and filter to [Me] on the Person or Group column that contains the sharepoint group in which a person exists. 2. Open this view in SharePoint Designer…if it ever says you do not have permission to do something, simply click ‘Cancel’ and everything will be fine. 3.
How to get user details from person or Group Field?
This article helps to understand, how to get user details like FirstName, LastName, Email Address etc. for a Person/Group field using REST API. Normally, in a list where we have Person/Group column (say Employee), when we use REST API to get this column value, we get User ID instead of actual value what we see in list column.
How to use lookup fields in a filter?
The lookup column points back to the User Information List so you’ll want to use that list to find the person by name or login name to get their ID and then use that in your filter within the content list using the above technique. These fields are stored in a different way, as you can see from the Relevant Offices column in my list:
How to filter a view by ” me ” without a people column?
Pick the “Current Approver” or whatever field contains your user names, and click Finish, and exit edit mode. This is what the final, filtered view looks like: In SharePoint 2010, you can safely remove the “Current Approver” column from the view if you don’t need to see it.
How to add a me filter in SharePoint?
In the Select A Field Or Group dialog box, select SharePoint Users from the Data Source drop-down list. Select :ID, click Filter Data, and then click Add. In the Specify Filter Conditions dialog box, select Title from the first drop-down list, and then select Select A Field Or Group from the third drop-down list.
Is it possible to filter people using [ me ]?
Assuming that John is an engineer, I would expect the filter using [Me] (when John is using it) to return rows 1 and 3 (because John is part of the Engineering Active Directory group), but alas only row 1 is returned. Is this behavior possible when declaring a view over this list?