Sep 03 2020 05:34 AM
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.
Sep 03 2020 10:30 PM
Try this: [Approver] = [Me]
Sep 04 2020 02:23 AM
@aliraza3008 Thanks for the Suggestion. But the provided solution is not working for me and is still getting the same error message.
Sep 04 2020 02:30 PM
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.
Sep 05 2020 08:34 AM
@aliraza3008 Thanks but we are not using workflows. For now, we are skipping this functionality.