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
Occasional Visitor

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.

1 Reply

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.