Share via

Specify conditional formula to show or hide fields in a list form based on choice

Steve Prentice 0 Reputation points
2025-01-09T08:51:49.85+00:00

Hi,

I have a list that includes column names that have spaces in them, e.g. "Third party". I want to be able to conditionally show fields in a list form based on choice. I have followed the guidance in this link https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide#specify-conditional-formula-to-show-or-hide-columns, however conditional formula appears to have an issue with the space between the column name "Third" and Party".

I want to be able to overcome this issue without removing the space in the column name, please can someone help?

Success : =if([$ThirdParty] == 'Yes', 'true', 'false')

Fail : =if([$Third party] == 'Yes', 'true', 'false') **error advising "**Enter a valid condition"

Thanks in advance!!

Microsoft 365 and Office | SharePoint | Development
0 comments No comments

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 51,986 Reputation points Microsoft External Staff
    2025-01-10T02:46:17.25+00:00

    In the conditional formula, you should use internal name of the column.

    Go to List Settings -> Columns section -> Click the "Third party" column -> Find the internal name of the column.

    1 So, you must use [$ThirdParty] in the conditional formula.


    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.

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

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