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 formula” to show a column on the default New Experience forms when the current user a specific person (people column-single input).

eg

=if([$CurrentUser.email] == ‘name @ domain dot com’, ‘true’, ‘false’)

What are the right properties and where can I find the list for this or any column for that matter, so can learn to solve these questions on my own.

AND

Similarly the correct syntax/properties to use for say a people column, MS help shows this, 

=if([$Owner.email] == ‘name @ domain dot com’, ‘true’, ‘false’)

I assume “Owner.email” is the created by person’s email but that is not working when I change it to local user/email.

Thanks for any direction, suggestions.

​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 formula” to show a column on the default New Experience forms when the current user a specific person (people column-single input).eg=if([$CurrentUser.email] == ‘name @ domain dot com’, ‘true’, ‘false’)What are the right properties and where can I find the list for this or any column for that matter, so can learn to solve these questions on my own. ANDSimilarly the correct syntax/properties to use for say a people column, MS help shows this, =if([$Owner.email] == ‘name @ domain dot com’, ‘true’, ‘false’) I assume “Owner.email” is the created by person’s email but that is not working when I change it to local user/email. Thanks for any direction, suggestions.    Read More

​