May 25 2020
I have list which having column Vendor- which have values 'IBM', 'Microsoft', 'Paypal'
for each vendor i have SP user groups
i want to filter list items,so That each group members can only see list items having value of there group name in Vendor Column
So IBM_Grp users can see only list items with value 'IBM' in Column vendor
Microsoft_Grp users can see only list items with value 'Microsoft' in column vendor
like this, how can we achieve this.
I tried to user CAML query,
<Membership Type=\"CurrentUserGroups\"><FieldRef Name=\"Vendor\"/></Membership>
But its not working, any better way to achieve this?