modern list view Filter list view based on membership in SharePoint group

%3CLINGO-SUB%20id%3D%22lingo-sub-1358158%22%20slang%3D%22en-US%22%3Emodern%20list%20view%20Filter%20list%20view%20based%20on%20membership%20in%20SharePoint%20group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1358158%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20filter%20list%20items%20in%20modern%20SP%20site%20list%20based%20on%20SP%20security%20group.%20I%20want%20to%20create%202%20different%20list%20views%20%2C%201%20which%20shows%20status%20%3D%20in%20progress%20list%20items%20to%20members%20and%20status%3D%20completed%20to%20all%20visitors.%20This%20will%20be%20large%20list%20containing%20items%20more%20than%2070-80k%20and%20don't%20want%20to%20go%20with%20item%20level%20security%20route.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1358158%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1359050%22%20slang%3D%22en-US%22%3ERe%3A%20modern%20list%20view%20Filter%20list%20view%20based%20on%20membership%20in%20SharePoint%20group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1359050%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397897%22%20target%3D%22_blank%22%3E%40maheshKhiste%3C%2FA%3E%26nbsp%3BAa%20you%20have%20mentioned%20that%20you%20don't%20want%20to%20go%20with%20the%20permission%20route%20you%20are%20eliminating%20the%20best%20and%20robust%20option%20in%20terms%20of%20the%20design%20in%20my%20view.%20So%20now%20I%20can%20thin%20of%20this%20option%3A%26nbsp%3B%26nbsp%3BGo%20to%20your%20list%20settings%20and%20in%20the%20versioning%20setting%20set%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_1-1588639134989.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188881i5BFCC67A3AE7BA15%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_1-1588639134989.png%22%20alt%3D%22Vikram_Samal_1-1588639134989.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOnce%20you%20set%20that%20each%20item%20will%20required%20content%20approval%20and%20unless%20its%20approved%20user%20with%20view%20access%20they%20wont%20be%20able%20view%20them%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1588639040745.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188880i133ACA27CB7A12C8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1588639040745.png%22%20alt%3D%22Vikram_Samal_0-1588639040745.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%2C%20I%20have%20some%20other%20options%20but%20they%20are%20much%20cumbersome%20than%20what%20we%20are%20discussing%20here.%20Please%20let%20me%20know%20if%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1362129%22%20slang%3D%22en-US%22%3ERe%3A%20modern%20list%20view%20Filter%20list%20view%20based%20on%20membership%20in%20SharePoint%20group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1362129%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394813%22%20target%3D%22_blank%22%3E%40Vikram_Samal%3C%2FA%3E%26nbsp%3B%20i%20ruled%20out%20item%20level%20permissions%20as%20MS%20reco%20to%20have%205k%20unique%20and%20max%20supported%20is%2050k%20and%20as%20i%20mentioned%20in%20my%20requirement%20my%20list%20will%20have%2080k%20items%20or%20more%20than%20that%2C%20if%20you%20have%20any%20other%20solution%20security%20%2F%20permisssion%20solution%20that%20can%20work%20for%20such%20large%20items%20list%20%2C%20please%20let%20me%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20current%20option%20which%20you%20mentioned%20doesn't%20go%20with%20requirement%2C%20i%20have%20edited%20the%20question%20to%20provide%20more%20information%20on%20the%20scenario%2C%20sorry%20for%20the%20confusion%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1364578%22%20slang%3D%22en-US%22%3ERe%3A%20modern%20list%20view%20Filter%20list%20view%20based%20on%20membership%20in%20SharePoint%20group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1364578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397897%22%20target%3D%22_blank%22%3E%40maheshKhiste%3C%2FA%3E%26nbsp%3Bthanks%20for%20the%20explanation.%20You%20can%20do%20this%20using%20Folders%20in%20a%20list%20and%20achieve%20this%20.%3C%2FP%3E%3CP%3EStart%20with%20creating%20two%20folders%20named%20such%20as%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_1-1588785041667.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189543i7E4E39A54AAE7FAF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_1-1588785041667.png%22%20alt%3D%22Vikram_Samal_1-1588785041667.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20set%20the%20permission%20in%20the%20folders%20so%20that%20in%20progress%20items%20are%20not%20visible%20to%20regular%20users%20but%20approved%20items%20will.%20Once%20the%20item%20is%20approved%20move%20them%20to%20approved%20items%20folder%20so%20that%20they%20will%20be%20visible%20to%20all%20users.%20You%20can%20also%20set%20the%20rule%20that%20when%20item%20is%20created%20move%20them%20to%20in%20progress.%3C%2FP%3E%3CP%3EThen%20create%20a%20new%20view%20which%20will%20show%20the%20items%20without%20folders%20so%20that%20it%20will%20so%20one%20the%20basis%20of%20permission.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_2-1588785251713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189545iB49C2D372717D839%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_2-1588785251713.png%22%20alt%3D%22Vikram_Samal_2-1588785251713.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ethen%20finally%20this%20will%20happen.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_3-1588785274530.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189546iAD24BFD02BC616CE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_3-1588785274530.png%22%20alt%3D%22Vikram_Samal_3-1588785274530.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20will%20help%20eliminating%20the%20permission%20restriction%20but%20it%20will%20still%20control%20who%20sees%20what.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20things%20to%20remember%20make%20sure%20you%20enable%20the%20folder%20creation%20in%20the%20list%20and%20disable%20it%20after%20the%20two%20folders%20are%20created%20so%20other%20users%20don't%20create%20any.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi , 

 

I have to filter list items in modern SP site list based on SP security group. I have a custom status column with choice values first-level-approver, second-level-approver, third-level-approver.

Respectively i will have 3 security groups 1stlevel approver, 2nd, 3rd 

 

I want to create a list view which will show list items based on the status of choice value and security group. If i am part of 1stlevel group it should show me items where status = first-level-approver

 

The one way to achieve i could think of is , create a assignee columns and add all names from that security group then create filter of listview as assignee contains [Me] but what if there are 20 -30 names in the group

 

other option could be create 3 views and apply security trimming on each view but not sure how that can be achieved in modern site without coding 

 

 This will be large list containing items more than 70-80k and as per MS 5k is reco limit for unique permission ( even though 50 k is supported ) but it won't work considering my list will have 90k or more items in it.

3 Replies
Highlighted

@maheshKhiste Aa you have mentioned that you don't want to go with the permission route you are eliminating the best and robust option in terms of the design in my view. So now I can thin of this option:  Go to your list settings and in the versioning setting set this:

Vikram_Samal_1-1588639134989.png

Once you set that each item will required content approval and unless its approved user with view access they wont be able view them

 

Vikram_Samal_0-1588639040745.png

 

Hope this helps, I have some other options but they are much cumbersome than what we are discussing here. Please let me know if this helps.

@Vikram_Samal  i ruled out item level permissions as MS reco to have 5k unique and max supported is 50k and as i mentioned in my requirement my list will have 80k items or more than that, if you have any other solution security / permisssion solution that can work for such large items list , please let me know.

 

The current option which you mentioned doesn't go with requirement, i have edited the question to provide more information on the scenario, sorry for the confusion

Highlighted

@maheshKhiste thanks for the explanation. You can do this using Folders in a list and achieve this .

Start with creating two folders named such as 

Vikram_Samal_1-1588785041667.png

Then set the permission in the folders so that in progress items are not visible to regular users but approved items will. Once the item is approved move them to approved items folder so that they will be visible to all users. You can also set the rule that when item is created move them to in progress.

Then create a new view which will show the items without folders so that it will so one the basis of permission.

Vikram_Samal_2-1588785251713.png

then finally this will happen.

Vikram_Samal_3-1588785274530.png

This will help eliminating the permission restriction but it will still control who sees what.

 

Some things to remember make sure you enable the folder creation in the list and disable it after the two folders are created so other users don't create any.