Forum Discussion
Prevent repeat entries in SharePoint list
In a column on my SharePoint list, the entries must either be equal to a specific value, or unique from every item in the list. For example, when a user adds a value in this column, it must either be...
ehertel Instead of using power automate, use power apps to customize list forms as it will show the error message to user before saving list item. If you use power automate, list item will be saved then flow will run. In this case you can inform user maybe using email & then you have to delete the list item.
In power apps you can check for existing values in list using formula while saving the item. If value found in list you can notify user using Notify() function else submit the list form.
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.