Forum Discussion
Filtering List items on the basis of sharepoint group using CAML query in sharepoint online classic
I want to filter items of list library on the basis of sharepoint groups. users belong to one sharepoint group-IT can only see list items which having value in one column Vendor='IT' users belong to another sharepoint group -Finance can only see list items which having value in column Vendor='finance' when user visit page he can only see list items which having value in column mapped with user group. how can I achieve this in sharepoint online classic please find following article for solution,will it work?
https://www.crowcanyon.help/article/304/
I added following code of CAML query through sharepoint designer to default view, but its not giving expected result
where Vendor is column in list which I want to compare with current users sharepoint group.
<And><Membership Type="CurrentUserGroups"><FieldRef Name="Vendor"/></Membership></And>