Forum Discussion
A column validation formula to ensure a "Created By" user doesn't submit an item to a list twice?
Hello, I am seeking a formula to use in either a single line of text column, or in column or list validation that checks "Created By" and prevents a user from submitting an item to the list more than once. I have tried the following formulas with no success:
Tried in column validation
=IF(COUNTIF([Author], [Author])>1, “You have already submitted an item to this list.”, TRUE)
=IF(COUNTIF([Created By], [Created By])>1, “You have already submitted an item to this list.”, TRUE)
Tried in single line text with Default value set to this calculated value:
=IF(COUNTIF([Author], [Author])>1, "Duplicate", "Unique")
=IF(COUNTIF([Created By], [Created By])>1, "Duplicate", "Unique")
What am I doing wrong, here? Thanks in advance for the insights and ideas.
1 Reply
CristinaMorales Unfortunately, you cannot use the Created By (or any person type column) in SharePoint calculated column formula or list validation formula.
Check if you can implement something by looking at the answer given here: How can I limit user to only enter one item in a list?
If not, you will have to either customize the list form using Power Apps to check if 1 item by user is already available in list and then do not allow saving new item OR run power automate flow on item creation --> check if item already available --> delete newly created item --> inform user via email.
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.
