There are requirements to show hide fields or enable/ disable fields based on business requirements for selected values. Today I am going to share how can we can show hide field in a SharePoint list form based on logged in user.
How to
I have a issue tracker list created using Issue tracking list template which I will be using for logging issues. I will hide issue discovery field on the SharePoint list form if logged in user is the same as Assigned To field so that user cannot modify Issue Description field.
Select any list item / document from the SharePoint list or library and expand the Edit Form button click on the Edit Columns.
This will show you complete list of Columns from the list, you can hide few columns form here and can change the order of the columns. Click on the three dots next Issue Description column name and select Edit conditional formula.
A dialog will be opened, now you need to enter a formula to hide the field if Issue Description option is selected.
=if([$Assignedto.email] == @me, ‘false’,’true’)
Once you hit the save the button, the issue description field will be greyed out because it has the formula. Now you can test it by accessing the list view or edit form.
Adnan is six time Microsoft MVP (Since 2015) with over 16 years of extensive experience with major expertise on SharePoint, SharePoint based development, Microsoft 365, Microsoft Teams, .Net Platform and Microsoft BI. He is currently working Sr Microsoft Consultant at Olive + Goose. He is MCT Regional Lead for Pakistan Chapter since 2012. He is working on SharePoint for past 12 years and worked on different intranet/intranet solutions for private & govt. sector majorly in United states and Gulf region and have experience of working with multiple Fortune 500 companies. He is a trainer, technology evangelist and also speaks in community forums.
No Comments