IsEmpty function in sharepoint list/ form

Thilina Tantirigama 116 Reputation points
2022-06-07T03:53:37.61+00:00

Hi,
I have a modern SPO list with text columns A, B, C. I want to show only Column B if A is not empty, and show Column C if B is not empty. Can someone please advise the JSON formula for this?

Thanks.

Microsoft 365 and Office SharePoint For business Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 51,836 Reputation points Microsoft External Staff
    2022-06-07T09:25:54.787+00:00

    @TantirigamaThilina-7057

    You could follow below steps to hide a column in the list new form.

    1.+New -> In the upper right corner of the form, click 208977-image.png -> Edit columns.

    2.Navigate to the desired column for which you want to set a conditional formula -> Select the far right hand edge of the column name to display the options menu (...) -> Edit conditional formula.

    3.In the column B, =if([$A]=='','false', 'true'). In the column C, =if([$B]=='','false', 'true').

    Reference: https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.