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, a distinguished professional, boasts an impressive track record as a Microsoft MVP, having achieved this prestigious recognition for the eighth consecutive year since 2015. With an extensive career spanning over 18 years, Adnan has honed his expertise in various domains, notably excelling in SharePoint, Microsoft 365, Microsoft Teams, the .Net Platform, and Microsoft BI. Presently, he holds the esteemed position of Senior Microsoft Consultant at Olive + Goose. Notably, Adnan served as the MCT Regional Lead for the Pakistan Chapter from 2012 to 2017, showcasing his leadership and commitment to fostering growth within the tech community. His journey in the realm of SharePoint spans 14 years, during which he has undertaken diverse projects involving both intranet and internet solutions for both private and government sectors. His impact has transcended geographical boundaries, leaving a mark on projects in the United States and the Gulf region, often collaborating with Fortune 500 companies. Beyond his roles, Adnan is a dedicated educator, sharing his insights and knowledge as a trainer. He also passionately advocates for technology, frequently engaging with the community through speaking engagements in various forums. His multifaceted contributions exemplify his dedication to the tech field and his role in driving its evolution.

Leave a Reply