Filtering group in Datasheet view RRS feed

  • Question

  • Hi all,

    I have a requirement which I am not sure how to proceed. Consider that there is a sharepoint group called Leads and that there are two users LeadA and LeadB. There is also another group called Users which has LeadA, LeadB, UserA, UserB.

    There is a list which has several columns. Two of the columns in that are Lead and User which are both people column where Lead column references the sharepoint group Leads and User column references the Users sharepoint group.

    When LeadA opens the list in Datasheet view, he can assign an item to anybody in the Users group to the User column in the list except for himself.Similarly for LeadB who can assign anybody except for himself in the User column.

    How can I do this in Datasheet view? I understand that we could create a visual webpart for implementing this but I would want this to be O365 compatible and avoid custom coding.
    Wednesday, July 6, 2016 12:06 PM