Introduction
A much-awaited feature in the SharePoint Online list was the conditional show/hide columns based on the values of other columns. We now have this feature available in targeted releases and will be available very soon to all tenants.
This feature will help customize the new form in the SharePoint list to show or hide columns based on some conditions. Let's look at how we can use the conditional show/hide columns in a SharePoint List.
Steps to Specify the Condition Formula
Step 1
Create a Custom List and create all the required columns as per the need once the list and columns are provisioned.
To Configure a conditional formula, click on the new button.
Step 2
Once the new form is available, we can now click on Edit form, which would provide us a flyout with values as "Edit Column" and "Customize with Power Apps".
Select the Edit Column Option.
Step 3
Now a new Panel will appear with the list of all the columns present in the list now we can navigate to the right side and click on the (:) three dots to edit the conditional formula.
Below is the table of a reference formula for the different columns.
| Column Type | Reference formula |
| Choice column | =if([$Category]=='Information Technology','true', 'false') |
| Number column | =if([$Cost]<=120, 'true','false') |
| Date column | =if([$StartDate]>=Date('4/6/2020'),'true','false') |
| Person column | =if([$User.email]=='[email protected]', 'true', 'false') |
| Boolean (Yes/No) column | =if([$Flag]==true,'true','false') |
Note
We can use @me for current User
Also, the below logical operators are allowed with the formula.
| Operator | Description |
| && | Logical AND operator |
| || | Logical OR Operator |
| ! | Logical NOT Operator |
Conclusion
We can now create an out-of-the-box form in SharePoint with custom show hide logic this can be very helpful when we do not want to use PowerApp
Eddie VbpPosted Sep 17, 2021, 9:07 PM
If I have a choice column name Paymenttype with 4 selections e.g. bank, cash, online, cheque. And have another column name BankInfo only will appear for user to type info if user select either online or cheque at the Paymenttype choice column. I tried few formula e.g. =if([$Paymenttype] == 'online' || [$Paymenttype] == 'cheque', 'true', 'false') . So I need guidance/advice does have any formula to show the BankInfo column if meet either one of choices selection?
Bhavya PatnamPosted Sep 1, 2021, 12:09 PM
Is there a way to Hide "Choice" column types for folders only and make the choice clickable or visible for the files but not folders?\
Ekta DobariaPosted Dec 9, 2020, 3:01 AM
Can we enable disable controls?
cesar gonzalezPosted Aug 12, 2020, 8:56 AM
Hello, could you help me in my problem, all the conditions do not work for me. [email protected]
Sagar PardeshiPosted Jun 14, 2020, 11:47 PM
Good concept explores for modern SharePoint keet it up