SharePoint List validate column aganist logged in user

%3CLINGO-SUB%20id%3D%22lingo-sub-1631526%22%20slang%3D%22en-US%22%3ESharePoint%20List%20validate%20column%20aganist%20logged%20in%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1631526%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20using%20the%20Sharepoint%20list%20for%20storing%20data.%20we%20have%20the%20column%20name%20%3CSTRONG%3EApprover%2C%3C%2FSTRONG%3E%26nbsp%3Bthe%20end-user%20can%20select%20the%20approver%20but%20he%20cannot%20select%20his%20own%20name%20as%20an%20approver.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20want%20to%20implement%20validation%20something%20like%20this(%3D%5BApprover%5D%3D%5BCreated%20By%5D).%20But%20the%20SharePoint%20list%20returning%20me%20below%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22ms-pr%22%3E%3CDIV%3ESorry%2C%20something%20went%20wrong%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3EOne%20or%20more%20column%20references%20are%20not%20allowed%2C%20because%20the%20columns%20are%20defined%20as%20a%20data%20type%20that%20is%20not%20supported%20in%20formulas.%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EBoth%20Approver%20Column%20and%20Created%20By%20column%20having%20the%20same%20data%20type%20(Person%20or%20Group).%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3ECan%20anyone%20help%20me%20to%20validate%20the%20Approver%20column%20against%20Logged%20in%20the%20user%3F%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EThanks%20In%20Advance%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3ESrikanth%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1631526%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20List%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1634388%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20validate%20column%20aganist%20logged%20in%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1634388%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759159%22%20target%3D%22_blank%22%3E%40srikanthm26%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%3A%20%5BApprover%5D%20%3D%20%5BMe%5D%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1634951%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20validate%20column%20aganist%20logged%20in%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1634951%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F771000%22%20target%3D%22_blank%22%3E%40aliraza3008%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20Suggestion.%20But%20the%20provided%20solution%20is%20not%20working%20for%20me%20and%20is%20still%20getting%20the%20same%20error%20message.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20182px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F216553i915F508CFD1EB632%2Fimage-dimensions%2F182x122%3Fv%3D1.0%22%20width%3D%22182%22%20height%3D%22122%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

We are using the Sharepoint list for storing data. we have the column name Approver, the end-user can select the approver but he cannot select his own name as an approver.

 

So I want to implement validation something like this(=[Approver]=[Created By]). But the SharePoint list returning me below error.

 

Sorry, something went wrong
 
 
One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.
 
Both Approver Column and Created By column having the same data type (Person or Group).
 
Can anyone help me to validate the Approver column against Logged in the user?
 
Thanks In Advance
Srikanth
 
4 Replies
Highlighted

@srikanthm26 

Try this: [Approver] = [Me]

Highlighted

@aliraza3008 Thanks for the Suggestion. But the provided solution is not working for me and is still getting the same error message.

image.png

Highlighted

@srikanthm26 

People column are not allowed to use in list validation. Use workflow to validate Approver with Created by. If it matches, terminate the workflow and send the email to creator.

Highlighted

@aliraza3008 Thanks but we are not using workflows. For now, we are skipping this functionality.