Forum Discussion

rautchetan's avatar
rautchetan
Brass Contributor
May 20, 2020

filting/restricting list items on the basis of user group 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/

9 Replies

  • 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"

    1. Item Level IT items only "IT Users" group will have access - You can give read/write/fc as per your need
    2. 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

    • rautchetan's avatar
      rautchetan
      Brass Contributor

      Vikram_Samal 

       

      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_Samal's avatar
        Vikram_Samal
        MCT
        Yes 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