Forum Discussion
SharePoint List validate column aganist logged in user
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
Try this: [Approver] = [Me]
aliraza3008 Thanks for the Suggestion. But the provided solution is not working for me and is still getting the same error message.
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.
