Forum Discussion
SharePoint Calculated Column to compare two Person fields
Is it possible to create a calculated column to compare Person Field A with Person Field B?
ganeshsanap My use case is if the person that has created the new document (Requestor) is the same person that is marked as the Reviewer, I want it to set my Status field to a specific value, if they are not the same person, then I want an Approver sent to the Reviewer. If I use the "Is Equal" JSON, can I use that value Not Equal or Equal in my flow?
Kim Williams JSON formatting is used to just show the text in list view, it does not actually store any value in the list item level.
However, you can compare the person column values in flow as well using equals() operator.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.