Remove field from sharepoint list form

%3CLINGO-SUB%20id%3D%22lingo-sub-3457538%22%20slang%3D%22en-US%22%3ERemove%20field%20from%20sharepoint%20list%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3457538%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20creating%20a%20custom%20IT%20Ticket%20System%20using%20sharepoint%20list.%20I%20have%20a%20column%20called%20status%2C%20and%20i%20want%20only%20administrators%20to%20modify%20then.%20I%20searched%20for%20solutions%20but%20i%20can't%20find.%20So%20i%20have%20the%20idea%20to%20hide%20status%20when%20i%20have%20created%20the%20ticket%20(because%20only%20users%20will%20create%20requests).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20to%20implement%20the%20conditional%20formula%20in%20the%20form%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3Dif(%5B%24Author%5D%20%3D%3D%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F31142%22%20target%3D%22_blank%22%3E%40me%3C%2FA%3E%2C%20'true'%2C%20'false')%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20didn't%20work%20as%20i%20expect.%20Can%20someone%20help%20me%20to%20hide%20the%20status%20field%20from%20the%20user%20creator%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3457538%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%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-3459020%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20field%20from%20sharepoint%20list%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3459020%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1410692%22%20target%3D%22_blank%22%3E%40jpcarpanezi%3C%2FA%3E%26nbsp%3BTry%20using%20below%20formula.%20Hope%20it%20works%20for%20you%20else%20you%20have%20to%20customize%20the%20list%20form%20using%20Power%20Apps%20to%20show%2Fhide%20the%20fields%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3Dif(%5B%24Author.email%5D%20%3D%3D%20%40me%2C%20'true'%2C%20'false')%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3460910%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20field%20from%20sharepoint%20list%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3460910%22%20slang%3D%22en-US%22%3E%3CP%3EDidn't%20work%2C%20is%20there%20any%20way%20to%20avoid%20to%20edit%20self%20ticket%20status%2C%20without%20PowerApps%3F%20I%20wan't%20just%20SharePoint%20admnistrators%20to%20edit%20the%20items.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm creating a custom IT Ticket System using sharepoint list. I have a column called status, and i want only administrators to modify then. I searched for solutions but i can't find. So i have the idea to hide status when i have created the ticket (because only users will create requests).

 

I've tried to implement the conditional formula in the form:

 

=if([$Author] == @me, 'true', 'false')

 

But didn't work as i expect. Can someone help me to hide the status field from the user creator? 

2 Replies

@jpcarpanezi Try using below formula. Hope it works for you else you have to customize the list form using Power Apps to show/hide the fields:

 

=if([$Author.email] == @me, 'true', 'false')

 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Didn't work, is there any way to avoid to edit self ticket status, without PowerApps? I wan't just SharePoint admnistrators to edit the items.