Modifying column so certain groups can't view it

%3CLINGO-SUB%20id%3D%22lingo-sub-1094784%22%20slang%3D%22en-US%22%3EModifying%20column%20so%20certain%20groups%20can't%20view%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1094784%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20developing%20a%20help%20desk%20for%20employees%20at%20my%20company%20to%20submit%20tickets%20to%20the%20'Help%20Desk'%20list%20via%20Powerapps%20forms.%20At%20the%20moment%2C%20I%20have%20everything%20working%20except%20I%20would%20like%20to%20include%20a%20column%20in%20the%20list%20named%20%22IT%20Comments%22%20that%20should%20only%20be%20visible%20and%20modifiable%20by%20Techs%20in%20the%20company.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20achieve%20this%3F%20Maybe%20it%20has%20something%20to%20do%20with%20the%20Powerapps%20integration%20with%20sharepoint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20all%20responses%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1094784%22%20slang%3D%22en-US%22%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-1095233%22%20slang%3D%22en-US%22%3ERe%3A%20Modifying%20column%20so%20certain%20groups%20can't%20view%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1095233%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F509221%22%20target%3D%22_blank%22%3E%40qhenry%3C%2FA%3E%26nbsp%3B%20In%20SharePoint%20there%20is%20no%20OOTB%20way%20to%20%22hide%22%20a%20column%20using%20groups%20or%20permissions.%26nbsp%3B%20You%20can%20not%20include%20to%20column%20in%20the%20PowerApp%2C%20but%20it%20will%20be%20visible%20in%20the%20list.%26nbsp%3B%20You%20can%20change%20the%20default%20view%20of%20the%20list%20to%20not%20show%20the%20column%20as%20well%2C%20but%20a%20savvy%20end%20user%20that%20knows%20how%20to%20change%20views%20would%20be%20able%20to%20see%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1095730%22%20slang%3D%22en-US%22%3ERe%3A%20Modifying%20column%20so%20certain%20groups%20can't%20view%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1095730%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%2F509221%22%20target%3D%22_blank%22%3E%40qhenry%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20not%20possible%20to%20securely%20hide%20columns%20to%20some%20people.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20would%20suggest%20if%20possible%20in%20your%20scenario%20is%20to%20have%20a%20different%20list%20for%20the%20comments%20that%20only%20those%20who%20are%20allowed%20can%20access.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20SharePoint%20you%20could%20solve%20this%20by%20using%20javascript%20for%20example%3A%3C%2FP%3E%3CP%3EOn%20the%20ticket%20list%20you%20can%20add%20column%20that%20contains%20hyperlink%20%22add%20comment%22%20that%20will%20open%20%22comment%22%20dialog%20for%20those%20who%20are%20allowed%20to%20and%20bind%20it%20together%20on%20the%20ticket%20itemid%20so%20each%20comment%20has%20a%20reference%20id%20to%20the%20ticket.%20Then%20maybe%20you%20could%20add%20another%20column%20to%20the%20ticekt%20list%20that%20contains%20hyperlink%20%22Show%20all%20comments%22%2C%20that%20action%20would%20query%20the%20comments%20list%20by%20ticket%20itemid.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20you%20could%20do%20same%20thing%20on%20the%20item%20view%20form%20by%20adding%20button%20or%20link%20with%20script%20editor.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20I'm%20sure%20you%20can%20solve%20this%20in%20a%20similar%20way%20in%20PowerApps%20for%20example%20when%20you%20view%20single%20item%20you%20add%20extra%20action%20or%20controls%20if%20current%20user%20is%20allowed%20to%20see%20it%20and%20then%20submit%20comment%20to%20different%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

 

I'm developing a help desk for employees at my company to submit tickets to the 'Help Desk' list via Powerapps forms. At the moment, I have everything working except I would like to include a column in the list named "IT Comments" that should only be visible and modifiable by Techs in the company.

 

Is there any way to achieve this? Maybe it has something to do with the Powerapps integration with sharepoint?

 

Thanks for all responses in advance!

2 Replies
Highlighted

@qhenry  In SharePoint there is no OOTB way to "hide" a column using groups or permissions.  You can not include to column in the PowerApp, but it will be visible in the list.  You can change the default view of the list to not show the column as well, but a savvy end user that knows how to change views would be able to see it.

Highlighted

Hi @qhenry 

 

It is not possible to securely hide columns to some people. 

 

What I would suggest if possible in your scenario is to have a different list for the comments that only those who are allowed can access. 

 

In SharePoint you could solve this by using javascript for example:

On the ticket list you can add column that contains hyperlink "add comment" that will open "comment" dialog for those who are allowed to and bind it together on the ticket itemid so each comment has a reference id to the ticket. Then maybe you could add another column to the ticekt list that contains hyperlink "Show all comments", that action would query the comments list by ticket itemid.  

Or you could do same thing on the item view form by adding button or link with script editor.

 

And I'm sure you can solve this in a similar way in PowerApps for example when you view single item you add extra action or controls if current user is allowed to see it and then submit comment to different list.