SharePoint List Column Comparison

%3CLINGO-SUB%20id%3D%22lingo-sub-2907978%22%20slang%3D%22en-US%22%3ESharePoint%20List%20Column%20Comparison%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2907978%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3EHi%2C%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EI%20am%20looking%20to%20highlight%20the%20field%20when%20a%20user%20makes%20a%20change%20to%20the%20field%20in%20a%20SharePoint%26nbsp%3Blist.%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EI%20have%20imported%20the%20data%20into%20the%20list%20in%20duplicate%20and%20then%20hide%20the%20column%20that%20is%20being%20referenced%20to%20check%20for%20changes%20to%20the%20column%26nbsp%3Bthat%20the%20user%20can%20edit.%20I%20am%20trying%20to%20use%20the%20JSON%20below%20but%20it%20doesn't%26nbsp%3B%26nbsp%3Bseem%20to%20pick%20the%26nbsp%3B%26nbsp%3B%3CFONT%20color%3D%22%230000FF%22%3E%5B%24Control_11%5D%26nbsp%3B%3CFONT%20color%3D%22%23000000%22%3Ecolumn%20reference%20correctly%20when%20doing%20the%20comparison.%26nbsp%3B%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CFONT%20color%3D%22%23000000%22%3EWould%20anyone%20have%20any%20ideas%20as%20to%20why%20this%20is.%26nbsp%3B%26nbsp%3B%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CFONT%20color%3D%22%23000000%22%3EEssentially%20I%20am%20just%20looking%20to%20compare%20two%20fields%20and%20highlight%20one%20field%20if%20the%20are%20different.%26nbsp%3B%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Paddy420_0-1635765842711.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F322174iE719D7F6F1B83833%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Paddy420_0-1635765842711.png%22%20alt%3D%22Paddy420_0-1635765842711.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Paddy420_0-1635766781679.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F322176i47BE301CE6C6F47E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Paddy420_0-1635766781679.png%22%20alt%3D%22Paddy420_0-1635766781679.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3EPaddy%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2907978%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hi, 
I am looking to highlight the field when a user makes a change to the field in a SharePoint list.
I have imported the data into the list in duplicate and then hide the column that is being referenced to check for changes to the column that the user can edit. I am trying to use the JSON below but it doesn't  seem to pick the  [$Control_11] column reference correctly when doing the comparison. 
Would anyone have any ideas as to why this is.  
Essentially I am just looking to compare two fields and highlight one field if the are different. 
 
 
Paddy420_0-1635765842711.pngPaddy420_0-1635766781679.png

 

Thanks 

Paddy

0 Replies