Home

Making some list fields visible only to certain users?

%3CLINGO-SUB%20id%3D%22lingo-sub-557046%22%20slang%3D%22en-US%22%3EMaking%20some%20list%20fields%20visible%20only%20to%20certain%20users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-557046%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20situation%20where%20we%20need%20a%20SharePoint%20list%20that%20stores%20information%20about%20employees.%20The%20list%20would%20have%2C%20say%2C%2010%20fields%2C%20but%20the%20employee%20should%20only%20be%20able%20to%20see%20and%20edit%205%20of%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20way%20this%20would%20work%20is%20that%20the%20employee%20creates%20a%20list%20item%20and%20submits%20some%20information%20(e.g.%20their%20employee%20number%2C%20some%20documents%20they've%20signed%2C%20etc).%20Afterwards%2C%20an%20admin%20would%20view%20the%20list%20item%2C%20review%20what%20the%20employee%20submitted%2C%20and%20then%20modify%20the%20remaining%20empty%20fields.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20I%20can%20do%20this%3F%20I%20thought%20about%20creating%20a%20PowerApp%20that%20displays%20only%20the%20fields%20an%20employee%20needs%20to%20be%20concerned%20with.%20However%2C%20I'm%20not%20sure%20how%20an%20admin%20would%20then%20be%20able%20to%20view%20the%20remaining%20fields%20and%20modify%20them%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20great!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-557046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%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-557657%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20some%20list%20fields%20visible%20only%20to%20certain%20users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-557657%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F190211%22%20target%3D%22_blank%22%3E%40Toby%20McDaid%3C%2FA%3E%26nbsp%3Byou%20can%20check%20user%20permissions%2Fgroup%20membership%20in%20PowerApp%20and%20then%20construct%20your%20logic%20accordingly.%20Laura%20Rogers%20has%20an%20example%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwonderlaura.com%2F2019%2F04%2F03%2Fpowerapps-with-sharepoint-permissions%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwonderlaura.com%2F2019%2F04%2F03%2Fpowerapps-with-sharepoint-permissions%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-557685%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20some%20list%20fields%20visible%20only%20to%20certain%20users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-557685%22%20slang%3D%22en-US%22%3E%3CP%3EPowerApps%20is%20the%20more%20elegant%20solution%20but%20you%20could%20use%20SharePoint%20content%20types%20for%20this%20too.%20Just%20give%20the%20people%20you%20want%20to%20see%20the%20hidden%20fields%20%22Design%22%20permission.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-558567%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20some%20list%20fields%20visible%20only%20to%20certain%20users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-558567%22%20slang%3D%22en-US%22%3EIf%20this%20is%20sensitive%20information%20thou%2C%20you%20cannot%20secure%20it%20using%20SharePoint.%20You%20could%20use%202%20lists%20thou%20and%20use%20flow%20to%20copy%20the%20information%20over%20to%20a%20list%20the%20admins%20have%20access%20to%2C%20to%20finish%20it%20out%2C%20but%20if%20the%20original%20submitter%20need%20access%20after%20the%20fact%20this%20wouldn't%20work.%20In%20that%20case%20content%20types%20could%20be%20utilized%20as%20David%20said%2C%20but%20it%20really%20depends%20on%20the%20security%20of%20the%20data%20afterwards.%20If%20it%20has%20to%20at%20all%20cost%20stay%20private%20from%20the%20submitter%20then%20you'll%20need%20to%20come%20up%20with%20some%20fancy%20way%20of%20doing%20the%20security%20or%20using%20powerapps%20and%20sql%20instead%20%3Ap.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-558863%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20some%20list%20fields%20visible%20only%20to%20certain%20users%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-558863%22%20slang%3D%22en-US%22%3EYep%20the%20security%20would%20decide%20everything.%20We've%20done%20something%20like%20this%20which%20allows%20a%20user%20to%20submit%20from%20a%20list%2C%20the%20submission%20gets%20copied%20to%20a%20new%20list%20and%20the%20requester%20gets%20an%20email%20copy%20of%20their%20submission.%3C%2FLINGO-BODY%3E
Highlighted
Toby McDaid
Contributor

I have a situation where we need a SharePoint list that stores information about employees. The list would have, say, 10 fields, but the employee should only be able to see and edit 5 of them.

 

The way this would work is that the employee creates a list item and submits some information (e.g. their employee number, some documents they've signed, etc). Afterwards, an admin would view the list item, review what the employee submitted, and then modify the remaining empty fields. 

 

Is there any way I can do this? I thought about creating a PowerApp that displays only the fields an employee needs to be concerned with. However, I'm not sure how an admin would then be able to view the remaining fields and modify them?

 

Any help would be great!

4 Replies

@Toby McDaid you can check user permissions/group membership in PowerApp and then construct your logic accordingly. Laura Rogers has an example: https://wonderlaura.com/2019/04/03/powerapps-with-sharepoint-permissions/

PowerApps is the more elegant solution but you could use SharePoint content types for this too. Just give the people you want to see the hidden fields "Design" permission.

If this is sensitive information thou, you cannot secure it using SharePoint. You could use 2 lists thou and use flow to copy the information over to a list the admins have access to, to finish it out, but if the original submitter need access after the fact this wouldn't work. In that case content types could be utilized as David said, but it really depends on the security of the data afterwards. If it has to at all cost stay private from the submitter then you'll need to come up with some fancy way of doing the security or using powerapps and sql instead :p.
Yep the security would decide everything. We've done something like this which allows a user to submit from a list, the submission gets copied to a new list and the requester gets an email copy of their submission.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies