Forum Discussion
Chandra0225
Feb 01, 2024Copper Contributor
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