I need to create a new view on a custom list that filter only the items that are added (created) by the users department, so any user can view all other items that are added by the other members of his department.
2 Answers
ok. sorry! I dont think that this is possbile out of the box. to get this working you would need to get and save the users department in a separate column on item create for example via an event receiver and after this you would need to create a "dynamic" view on this column.
use Target Audience in Sharepoint for this:
-
I dont know if this works for a dynamic list, the items on this list are not static, each user can add or delete items, but the items can only be viewed by the group or the department of the user– NeuvillCommented Mar 16, 2015 at 19:54