May 20 2020 11:52 AM
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?
May 20 2020 09:01 PM
@rautchetan You can achieve this by using item level permission
Start with creating let 2 group "IT Users" and "Finance Users"
Then when item is getting created trigger a flow or workflow to set the permission for those groups accordingly.
So you permission will look some thing like this:
List level - Read access to "IT Users" and "Finance Users"
Hope this helps. Mark the response appropriately if it helps you achieve the solution.
Thanks
Vik
May 20 2020 10:17 PM
Hi,
its not just about restricting access, I don't want to show list items which having different item groups.
so IT sharepoint group user can see only IT list items and no other list item.
similarly Finance sharepoint group user can see only Finance list items and no other list items.
May 20 2020 10:33 PM
May 20 2020 10:52 PM
what about solution, mentioned in following link, its easy solution using CAML query, will it work?
any idea?
May 20 2020 11:00 PM
May 20 2020 11:29 PM
I got it, thanks!
but my question is , I already have list items, how I will change there permissions, do I need it to do manually, assigned it to each sharepoint group.
May 21 2020 03:24 AM
can I put Recipients as SharePoint group name(please see attached image)
do I need to put it as IT_Group@onmicrosoft.com, its not finding IT_group automatically
May 23 2020 02:40 AM
I am using following CAML query for filtering list , but its not showing correct filter data, whats issue in this
<And><Membership Type="CurrentUserGroups"><FieldRef Name="Vendor"/></Membership></And>
May 28 2020 07:35 AM
@rautchetan Sorry for delay in reply you can set up a MS flow where you can set up condition which group should have permission and you can add some conditional block saying if IT which group should be given if finance which group should be given permission. I have shown how you can implement using flow:
Hopefully this helps.
Thanks
Vik