SOLVED
Home

Authenticate Lists based in list fields

%3CLINGO-SUB%20id%3D%22lingo-sub-1196675%22%20slang%3D%22en-US%22%3EAuthenticate%20Lists%20based%20in%20list%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1196675%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20site.%20I%20have%20a%20member%20group%20called%20'Allowed'%20and%20only%20the%20members%20in%20this%20group%20can%20see%20a%20List%20that%20I%20have%20created%2C%20called%20List1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInside%20List1%2C%20there%20are%20a%20number%20of%20fields.%20One%20of%20the%20fields%20is%20called%20'Owner%20Member'.%20This%20field%20is%20populated%20by%20the%20username%20of%20Members%20in%20the%20'Allowed'%20group.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20that%20I%20can%20set%20-%20that%20only%20the%20members%20whose%20name%20is%20in%20the%20'Owner%20Member'%20field%20can%20see%20their%20own%20list%20items%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI.e.%20list%20items%20are%20divided%20per-member%20of%20staff%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1196675%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1196741%22%20slang%3D%22en-US%22%3ERe%3A%20Authenticate%20Lists%20based%20in%20list%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1196741%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F568438%22%20target%3D%22_blank%22%3E%40hy1hy1%3C%2FA%3E%26nbsp%3Bcreate%20a%20view%20of%20the%20list%20and%20in%20the%20list%20settings%20add%20a%20filter%20where%20the%20column%20with%20the%20name%20of%20the%20person%20is%20equal%20to%20%5BMe%5D.%20Each%20person%20looking%20at%20the%20list%20will%20only%20see%20the%20items%20where%20they%20are%20in%20that%20column%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22People-eq-Me.png%22%20style%3D%22width%3A%20828px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173667i25F84AE89888D0D6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22People-eq-Me.png%22%20alt%3D%22People-eq-Me.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20our%20full%20list%20looks%20like%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22People-eq-Me-Full.png%22%20style%3D%22width%3A%20663px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173666i7F82DC2EA92D0924%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22People-eq-Me-Full.png%22%20alt%3D%22People-eq-Me-Full.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20looking%20at%20the%20new%20view%20it%20only%20shows%20the%20items%20for%20the%20current%20user%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22People-eq-Me-Rob.png%22%20style%3D%22width%3A%20699px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173669iADF794CAEB6BBB12%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22People-eq-Me-Rob.png%22%20alt%3D%22People-eq-Me-Rob.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20anyone%20who%20know%20how%20to%20access%20the%20list%20of%20views%20in%20the%20top%20right%20of%20the%20list%20will%20be%20able%20to%20see%20the%20full%20list.%20You'd%20have%20to%20apply%20row%20level%20permission%20to%20prevent%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1197030%22%20slang%3D%22en-US%22%3ERe%3A%20Authenticate%20Lists%20based%20in%20list%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1197030%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F568438%22%20target%3D%22_blank%22%3E%40hy1hy1%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20each%20item%20is%20created%20run%20a%20Flow%20to%20permission%20the%20item%20based%20on%20the%20member%20column.%20That%20would%20do%20the%20trick.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1198039%22%20slang%3D%22en-US%22%3ERe%3A%20Authenticate%20Lists%20based%20in%20list%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1198039%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much%20for%20your%20solution!%20It%20has%20really%20helped.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1198043%22%20slang%3D%22en-US%22%3ERe%3A%20Authenticate%20Lists%20based%20in%20list%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1198043%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214649%22%20target%3D%22_blank%22%3E%40Andrew%20Hodges%3C%2FA%3E%26nbsp%3BHi%20Andrew%2C%20would%20you%20be%20able%20to%20point%20me%20in%20the%20right%20direction%20in%20how%20such%20a%20flow%20would%20be%20structured%3F%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

I have a SharePoint site. I have a member group called 'Allowed' and only the members in this group can see a List that I have created, called List1.

 

Inside List1, there are a number of fields. One of the fields is called 'Owner Member'. This field is populated by the username of Members in the 'Allowed' group.

 

Is there any way that I can set - that only the members whose name is in the 'Owner Member' field can see their own list items?

 

I.e. list items are divided per-member of staff?

 

Thanks.

4 Replies
Highlighted
Solution

@hy1hy1 create a view of the list and in the list settings add a filter where the column with the name of the person is equal to [Me]. Each person looking at the list will only see the items where they are in that column:

People-eq-Me.png

 

So our full list looks like this:

People-eq-Me-Full.png

 

But looking at the new view it only shows the items for the current user:

 

People-eq-Me-Rob.png

 

However, anyone who know how to access the list of views in the top right of the list will be able to see the full list. You'd have to apply row level permission to prevent that.

 

Rob
Los Gallardos

Highlighted

Hi @hy1hy1 ,

 

When each item is created run a Flow to permission the item based on the member column. That would do the trick. 

Highlighted

@Rob Elliott Thank you so much for your solution! It has really helped.

Highlighted

@Andrew Hodges Hi Andrew, would you be able to point me in the right direction in how such a flow would be structured? Thank you.

Related Conversations
Format list view => icon if attachment
chhe5 in SharePoint on
0 Replies
Resulting NaN when calculating between two dates
JunHo_KIM in SharePoint on
0 Replies
List column customization
chinmaykulkarni in SharePoint on
1 Replies
How to manage multiple lists
BangorKeith in SharePoint on
2 Replies
Question about the 5000 items threshold
288088 in SharePoint on
3 Replies