Forum Discussion

Chandra0225's avatar
Chandra0225
Copper Contributor
Feb 01, 2024

Conditional formatting on custom form in Sharepoint not working for fields that are people picker

I have a custom form that I created using JSON. I also had the form display or hide fields in sections based on values in other fields. This was working perfectly fine a few days ago and today it all of a sudden stopped working and just hides the fields with the conditional formatting in them if the condition is based on a field that is a person picker. 

Here are the formulas I am using: 


Section 1 fields:
=if([$POCWorkingtheRequest.email] == me, 'true', 'false')

Section 2 fields: 
=if([$PeerReviewerPOC.email] == me, 'true', 'false')

 

Here are all the variations tried and their results: 


=if([$POCWorkingtheRequest.email] == me, 'true', 'false')
HIDES

=(@me == me)
SHOWS

=if(@me == me,'true','false')
SHOWS

=if([$POCWorkingtheRequest] == me, 'true', 'false')
HIDES

=if([$POCWorkingtheRequest], 'true', 'false')
SHOWS

=if([$POCWorkingtheRequest.email], 'true', 'false')
HIDES

=if(toLowerCase([$POCWorkingtheRequest.email]) == toLowerCase(@me), 'true', 'false')
HIDES

=(length([$POCWorkingtheRequest.email]) > 0)
HIDES

=if(toLowerCase(substring(@me,0,2)) == 'ab','true','false')
SHOWS

=if(substring(@me,0,2) == 'AB','true','false')
SHOWS

=if(substring([$Requestor.email],0,2) == 'AB','true','false')
HIDES

=if([$Requestor.email] == 'email address removed for privacy reasons', 'true', 'false')
HIDES

=if(toLowerCase(substring([$POCWorkingtheRequest.email],0,2)) == 'ab','true','false')
ERROR

=if(toLowerCase(substring([$POC],0,2)) == 'ab','true','false')
ERROR

=if(toLowerCase(substring([$PeerReviewerPOC.email],0,2)) == 'ab','true','false')
HIDES

=if(length([$POCWorkingtheRequest.email]) > 0,'true','false)
ERROR

=if(length([$POCWorkingtheRequest]) > 0,'true','false)
ERROR

=if(length(@me) > 0,'true','false)
ERROR

=if(@me.length > 0,'true','false)
ERROR


Any help would be much appreciated. 

No RepliesBe the first to reply

Resources