List row level security - user groups see only rows assigned to their business area

%3CLINGO-SUB%20id%3D%22lingo-sub-1991090%22%20slang%3D%22en-US%22%3EList%20row%20level%20security%20-%20user%20groups%20see%20only%20rows%20assigned%20to%20their%20business%20area%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1991090%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20please%20how%20(if%20possible)%20to%20achieve%20row%20level%20security%20on%20a%20SharePoint%20list%20so%20that%20for%20example%2C%20only%20users%20in%20user%20group%20x%20can%20see%20list%20items%20assigned%20to%20business%20area%20x%2C%20only%20users%20in%20user%20group%20y%20can%20see%20list%20items%20assigned%20to%20business%20area%20y%2C%20etc.%3F%20I%20have%20a%20business%20area%20choice%20column%20in%20the%20list%20I'm%20hoping%20to%20leverage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22paragraph-329%22%3EI'd%20love%20a%20way%20to%20achieve%20this%20for%20maintenance%20purposes%20-%20to%20avoid%20having%20one%20list%20per%20business%20area%20(will%20be%20over%2020)%20and%20therefore%20avoiding%20having%20multiple%20Power%20Apps%2C%20Power%20Automate%20flows%2C%20Power%20BI%20integrations%2C%20etc.%3C%2FP%3E%3CP%20class%3D%22paragraph-329%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22paragraph-329%22%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1991090%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2060838%22%20slang%3D%22en-US%22%3ERe%3A%20List%20row%20level%20security%20-%20user%20groups%20see%20only%20rows%20assigned%20to%20their%20business%20area%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060838%22%20slang%3D%22en-US%22%3E%3CP%3EI%20do%20not%20have%20any%20solution%20but%20have%20been%20facing%20the%20issue%20a%20couple%20times%20as%20well.%20Would%20be%20really%20interested%20to%20hear%20a%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F903107%22%20target%3D%22_blank%22%3E%40cmurray1%3C%2FA%3E%26nbsp%3Bfor%20now%2C%20maybe%20list%20workflows%20like%20described%20in%20this%20video%20would%20help%20you%20in%20the%20meantime%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D_nzGszA15C4%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D_nzGszA15C4%3C%2FA%3E%26nbsp%3BIt%20will%20for%20sure%20work%20with%20individuals%2C%20just%20not%20sure%20how%20to%20map%20people%20to%20business%20area%20then.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2343361%22%20slang%3D%22en-US%22%3ERe%3A%20List%20row%20level%20security%20-%20user%20groups%20see%20only%20rows%20assigned%20to%20their%20business%20area%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2343361%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F903107%22%20target%3D%22_blank%22%3E%40cmurray1%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20you%20have%20found%20a%20solution%20for%20your%20problem%3F%3CBR%20%2F%3E%3CBR%20%2F%3EOur%20team%20is%20wondering%20if%20it%20possible%20to%20SP%20list%20row's%20access%20for%20specific%20groups%20based%20on%20the%20country%20column%20(for%20example%2C%20people%20added%20to%20the%20SharePoint%20group%20%22UK%22%2C%20can%20only%20see%20rows%20where%20country%20column's%20value%20is%20%22UK%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi there,

 

Does anyone know please how (if possible) to achieve row level security on a SharePoint list so that for example, only users in user group x can see list items assigned to business area x, only users in user group y can see list items assigned to business area y, etc.? I have a business area choice column in the list I'm hoping to leverage.

 

I'd love a way to achieve this for maintenance purposes - to avoid having one list per business area (will be over 20) and therefore avoiding having multiple Power Apps, Power Automate flows, Power BI integrations, etc.

 

Thanks in advance.

5 Replies

I do not have any solution but have been facing the issue a couple times as well. Would be really interested to hear a solution.

 

@cmurray1 for now, maybe list workflows like described in this video would help you in the meantime? https://www.youtube.com/watch?v=_nzGszA15C4 It will for sure work with individuals, just not sure how to map people to business area then.

Show SharePoint content only to the user it is relevant to and hide it for the other users.

hi @cmurray1 ,

 

Perhaps you have found a solution for your problem?

Our team is wondering if it possible to SP list row's access for specific groups based on the country column (for example, people added to the SharePoint group "UK", can only see rows where country column's value is "UK".

@mantas180 @cmurray1 Have you found a solution? I have the same need!

 

Thanks!

Hi all,

No, unfortunately I didn't manage to find a solution in time and ended up going with a cumbersome, manual business process. Still interested if anyone knows how to do this.

Thanks.

Hi @cmurray1 , @Cris80 , 

 

Found the following tutorial helpful: Power Automate SharePoint Permissions and Security - Grant, Remove, and inherit with Flow - YouTube

 

Also, built the flow that seems to work:)

mantas180_0-1621409611888.png