Forum Discussion

SA-KRP15's avatar
SA-KRP15
Copper Contributor
Jul 04, 2024

SharePoint form "Edit Columns" with "Conditional Formula" and available field properties

I am trying to find out where I can find a complete list of the available "properties" of a column, so I don't have to continually ask in a forum.    For example, I am trying to set a "conditional ...
SharePoint Online
ganeshsanap's avatar
ganeshsanap
MVP
Jul 05, 2024

SA-KRP15 You have to use the internal name of SharePoint list columns in conditional formulas and JSON formatting. Example: Internal name of "Created By" column is "Author".

 

You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?

 

Person or Group (people) column supports these properties (with example values): 

 

{
  "id": "122",
  "title": "Kalya Tucker",
  "email": "email address removed for privacy reasons",
  "sip": "email address removed for privacy reasons",
  "picture": "https://contoso.sharepoint.com/kaylat_contoso_com_MThumb.jpg?t=63576928822",
  "department":"Human Resources",
  "jobTitle":"HR Manager"
}

 

Similarly, other column types support different properties.

 

You can find those at: SharePoint JSON formatting syntax reference - special string values 

 

Related documentation: Conditionally show or hide columns in a list or library form 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

SA-KRP's avatar
SA-KRP
Copper Contributor
Jul 08, 2024

Thanks ganeshsanap , the syntax link is helpful and what I was looking for.

 

I used the @Me to compare against another column from the same list (as a test) and that is working,
=if([$Partner.email] == @me, 'true', 'false')

 

The issue is, currently the user I want the column visible for is not listed in a people column on this list (possible future change I'll look at) but as a quick fix I was hoping to simply hardcode the email of the person. eg

=if(@me == 'user @ domain dot com', 'true', 'false')

 

  1. Can you confirm is it possible to use the @Me and compare against a static/hardcoded email address?
  2. The user I want to compare is in another list, but I assume the conditional formulas can only compare against columns in the current list only?

Resources