Forum Discussion
filting/restricting list items on the basis of user group in sharepoint online classic
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"
- Item Level IT items only "IT Users" group will have access - You can give read/write/fc as per your need
- Item Level Finance items only "Finance Users" group will have access - You can give read/write/fc as per your need
Hope this helps. Mark the response appropriately if it helps you achieve the solution.
Thanks
Vik
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.
- Vikram_SamalMay 20, 2020MCTYes I meant that when you will be allowing IT group permission remove others and same for others as well for finance items give only finance team permission. That will ensure the respective group will see only their items not others.
Vik- rautchetanMay 20, 2020Brass Contributor
what about solution, mentioned in following link, its easy solution using CAML query, will it work?
any idea?
https://www.crowcanyon.help/article/304/
- Vikram_SamalMay 20, 2020MCTThere are two aspects the solution you have shared one this is old will have lot of limitation using SharePoint designer approaches. Finally when you want to show and hide items you need to have the robust approach like item level permission which gives you 100% certainty of people having access on right items.
So if I will be in you place I will be inclined to the permission based approach as it will give peace of mind.
Thanks
Vik